mysql_processlist []

This is an old revision of the document!

Investigating mysql

If you need to investigate mysql you can troubleshoot by investigating the processlist

show processlist;

You should see an output similar to the following:

+--------+---------+-----------+------+---------+-------+-------+------------------+ 
| Id     | User    | Host      | db   | Command | Time  | State | Info             | 
+--------+---------+-----------+------+---------+-------+-------+------------------+ 
| 109530 | root   | localhost | NULL | Query   |     0 | NULL  | show processlist | 
| 106092 | wp_usr | localhost | wp   | Sleep   | 25140 |       | NULL             |
| 106090 | wp_usr | localhost | wp   | Sleep   | 25140 |       | NULL             |
| 106091 | wp_usr | localhost | wp   | Sleep   | 25139 |       | NULL             |
| 109751 | root   | localhost | NULL | Sleep   |   244 |       | NULL             |

Process list WITHOUT sleeping processes

SELECT * FROM information_schema.processlist WHERE command != 'Sleep' ORDER BY id;

source: https://mariadb.com/kb/en/mariadb/thread-command-values/

mysql Common Commands

Command	Description
Connect	Replication slave is connected to its master
Connect Out	Replication slave is in the process of connecting to its master
Drop DB	Executing an operation to drop a database
Error	Error
Execute	Executing a prepared statement
Fetch	Fetching the results of an executed prepared statement
Kill	Killing another thread
Query	Executing a statement
Quit	In the process of terminating the thread
Sleep	Waiting for the client to send a new statement
Table Dump	Sending the contents of a table to a slave