Differences
This shows you the differences between two versions of the page.
|
mysql_statistics [2012/05/22 10:21] |
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> | ||
