Sometimes you need to determine which queries are running too long in MySQL db, this script may help you:
SHOW PROCESSLIST; (get first 100 characters of the query)
OR
SHOW FULL PROCESSLIST; for more detail in the query
Wednesday, February 3, 2010
Get all running queries in MySQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment