SHOW PROCESSLIST

SHOW PROCESSLIST is a SQL statement in the Administration category. Shows all currently executing database connections/queries. Useful for finding long-running queries. The syntax is SHOW [FULL] PROCESSLIST;. It returns process list. A typical example: SHOW FULL PROCESSLIST; -- Shows: Id, User, Host, db, Command, Time, State, Info -- Find and kill slow queries: -- KILL 1234; -- Kills connection with Id=1234 A close relative is CREATE USER, which creates a new database user account. A close relative is GRANT, which grants specific privileges (SELECT, INSERT, UPDATE, DELETE, ALL) to a user on a database/table. A close relative is REVOKE, which removes previously granted privileges from a user. More about this category: Database administration — CREATE DATABASE, GRANT, REVOKE, SHOW, DESCRIBE. Related Administration entries: CREATE USER, GRANT, REVOKE, SHOW TABLES, DESCRIBE / DESC, SHOW INDEX, SHOW CREATE TABLE, SHOW DATABASES.