{"id":7394,"date":"2018-09-07T18:54:08","date_gmt":"2018-09-08T01:54:08","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=7394"},"modified":"2020-07-12T01:09:55","modified_gmt":"2020-07-12T08:09:55","slug":"mysql-show-processlist","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/mysql-show-processlist\/","title":{"rendered":"MySQL SHOW PROCESSLIST"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SHOW PROCESSLIST<\/code> command to find the currently running threads.<\/p>\n\n\n\n

Sometimes, you may get the “too many connections” error returned by the MySQL Server. To find out the reasons, you can use the SHOW PROCESSLIST<\/code> command.<\/p>\n\n\n\n

The SHOW PROCESSLIST<\/code> command returns all currently running threads. You then can terminate the idle threads with the KILL<\/code> statement.<\/p>\n\n\n\n

The following shows the syntax of the SHOW PROCESSLIST<\/code> command:<\/p>\n\n\n

SHOW<\/span> [FULL<\/span>] PROCESSLIST<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Accounts with the PROCESS<\/code> privilege<\/a> can view all threads. Otherwise, they can view only threads associated with their accounts.<\/p>\n\n\n\n
The following shows an example of the output of the SHOW PROCESSLIST<\/code> command:<\/p>\n\n\n
mysql>SHOW PROCESSLIST;\n\n+----+-----------------+-----------------+---------------+---------+------+------------------------+------------------+\n| Id | User            | Host            | db            | Command | Time | State                  | Info             |\n+----+-----------------+-----------------+---------------+---------+------+------------------------+------------------+\n|  4<\/span> | event_scheduler | localhost       | NULL<\/span>          | Daemon  | 2246<\/span> | Waiting on empty<\/span> queue | NULL<\/span>             |\n| 14<\/span> | root            | localhost:50924<\/span> | NULL<\/span>          | Query   |    0<\/span> | starting               | SHOW PROCESSLIST |\n| 15<\/span> | car             | localhost:50933<\/span> | classicmodels | Sleep   |    2<\/span> |                        | NULL<\/span>             |\n+----+-----------------+-----------------+---------------+---------+------+------------------------+------------------+\n3<\/span> rows in set (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The output of the SHOW PROCESSLIST<\/code> command consists of the following columns:<\/p>\n\n\n\n
Id<\/h3>\n\n\n\n
The client process’s Id<\/p>\n\n\n\n
User<\/h3>\n\n\n\n
The username associated with the thread.<\/p>\n\n\n\n
Host<\/h3>\n\n\n\n
The host to which the client is connected<\/p>\n\n\n\n
DB<\/h3>\n\n\n\n
The default database if one selected otherwise NULL<\/a><\/code><\/p>\n\n\n\n
Command<\/h3>\n\n\n\n
The command type<\/p>\n\n\n\n
Time<\/h3>\n\n\n\n
The number of seconds that the current thread has been in its current state.<\/p>\n\n\n\n
State<\/h3>\n\n\n\n
The thread state which represents an action, event, or state that indicates what thread is executing.<\/p>\n\n\n\n
Info<\/h3>\n\n\n\n
The statement is being executed, or NULL<\/code> if it is not executing any statement. If you do not use the FULL<\/code> keyword in the SHOW PROCESSLIST<\/code> command, then only the first 100 characters of each statement are returned in the Info column.<\/p>\n\n\n\n
In this tutorial, you have learned how to use the MySQL SHOW PROCESSLIST<\/code> statement to find the currently running threads.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful? <\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t