Mysql process View showprocesslist_MySQL

Mysql process View showprocesslist bitsCN.com

Show processlist is used to show which threads are running.

1. for SUPER permission, you can see all the threads;

2. if you are a separate user, you can only view your own thread;

3. if FULL is not applicable, only the first 100 characters of each query are displayed.

4. if a thread is in update or insert a table, the status of the process is updating or sending data.

The most important of this command is the state column. mysql lists the following states:

Checking table

Check data tables

Closing table

Refreshing the modified data in the table to the disk and closing the used table. This is a very fast operation. if not, check whether the disk space is full or the disk is under a heavy load.

Sending Date

Processing the record of the SELECT query and sending the result to the client.

Updating

Searching for matched records and modifying them.

BitsCN.com