February 2018
Intermediate to advanced
510 pages
16h 10m
English
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:
mysql> show processlist;+----+-----------------+-----------------+------+---------+--------+| Id | User | Host | db | Command | Time |+----+-----------------+-----------------+------+---------+--------++------------------------+-----------------------+| State | Info |+------------------------+-----------------------++----+-----------------+-----------------+------+---------+--------+ ...