​SHOW PROCESSLIST​​ shows you which threads are running. You can also get this information from the​​INFORMATION_SCHEMA​​ ​​PROCESSLIST​​ table or the ​mysqladmin processlist​ command. If you have the ​​PROCESS​​privilege, 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 单进程,多线程