Menu
We're in the process of converting to SQL Server from MySQL. I'm trying to figure out why a call to sqsh isn't returning and I suspect that there's some lock I don't know about.
How do you find out what's going on (preferably via the database connection)?
771
SHOW [FULL] PROCESSLIST. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The SHOW PROCESSLIST statement is one source of process information. For a comparison of this statement with other sources, see Sources of Process Information.
SHOW PROCESSLIST shows you which threads are running. You can also get this information from the information_schema. PROCESSLIST table or the mysqladmin processlist command. If you have the PROCESS privilege , you can see all threads.
Login to SSH. Type in MYSQL to get into the mysql command line. Type show processlist; in order to see current processes on the server.
Right-click a server, and then click Properties. On the Security tab, under Audit Level, click all/success etc(required option). Show activity on this post.
You can look into sp_who and sp_who2 to see if they give you what you need. Otherwise, SQL Profiler can often help with problem diagnoses.
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
