At times, we may need to figure out what the MySQL server is doing. So, it becomes necessary to find out the process list. The process list is the set of threads currently being executed within the MySQL server.
The following are the sources for getting process list information:
- The SHOW [FULL] PROCESSLIST statement. The following is an example of process list information:
mysql> show processlist;+----+-----------------+-----------------+------+---------+--------+| Id | User | Host | db | Command | Time |+----+-----------------+-----------------+------+---------+--------++------------------------+-----------------------+| State | Info |+------------------------+-----------------------++----+-----------------+-----------------+------+---------+--------+ ...
