All the data that MySQL provides can be displayed by a SHOW
command, or through the information_schema
table.
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;