Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mysql_statistics [2012/05/22 10:21] (current)
Line 1: Line 1:
 +====== MySQL Statistics ======
  
 +  * [[MySQL]]
 +  * [[pt-find]]
 +
 +All the data that MySQL provides can be displayed by a ''​SHOW''​ command, or through the ''​information_schema''​ table.
 +
 +== Display process list ==
 +
 +The ''​info''​ column is the SQL query being executed.
 +
 +<​code>​
 +SELECT id, user, host, db, command, time, state, info FROM information_schema.processlist ORDER BY id;
 +</​code>​