MySQL Statistics

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.

SELECT id, user, host, db, command, time, state, info FROM information_schema.processlist ORDER BY id;