mysql_processlist []

This is an old revision of the document!

Investigating mysql

https://mariadb.com/kb/en/mariadb/thread-command-values/
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;

mysql Common Commands

Command	Description
Connect
Connect Out
Drop DB
Error
Execute
Fetch
Kill
Query
Quit
Sleep
Table Dump