Wednesday, February 3, 2010

Get all running queries in MySQL

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)
SHOW FULL PROCESSLIST; for more detail in the query

No comments:

Post a Comment

Oracle Query