SHOW PROCESSLIST Syntax

 

https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html

 

SHOW PROCESSLIST shows you which threads are running. You can also get this information from theINFORMATION_SCHEMA PROCESSLIST table or the mysqladmin processlist command. If you have the PROCESSprivilege, you can see all threads. Otherwise, you can see only your own threads (that is, threads associated with the MySQL account that you are using). If you do not use the FULL keyword, only the first 100 characters of each statement are shown in the Info field.

 

 

mysql 单进程，多线程