MySQLSessions

Running threads

All non-sleeping connections, longest running first.

Not yet verified. How scripts are tested

b-my-proc.sql

1SELECT id, user, host, db, command,2       time AS secs, state,3       LEFT(info, 200) AS query4FROM information_schema.processlist5WHERE command <> 'Sleep'6ORDER BY time DESC;

Paste it into your query tool.

Open in denrepo

More MySQL scripts: Sessions

Kill a query or connectionKILL QUERY stops the statement and keeps the connection; KILL closes the connection and rolls back its transaction.