A thread can have any of the following COMMAND values (displayed by the COMMAND field listed by the SHOW PROCESSLIST statement or in the Information Schema PROCESSLIST Table, as well as the PROCESSLIST_COMMAND value listed in the Performance Schema threads Table). These indicate the nature of the thread's activity.
| Value | Description |
|---|---|
| Binlog Dump | Master thread for sending binary log contents to a slave. |
| Change user | Executing a change user operation. |
| Close stmt | Closing a prepared statement. |
| Connect | Replication slave is connected to its master. |
| Connect Out | Replication slave is in the process of connecting to its master. |
| Create DB | Executing an operation to create a database. |
| Daemon | Internal server thread rather than for servicing a client connection. |
| Debug | Generating debug information. |
| Delayed insert | A delayed-insert handler. |
| Drop DB | Executing an operation to drop a database. |
| Error | Error. |
| Execute | Executing a prepared statement. |
| Fetch | Fetching the results of an executed prepared statement. |
| Field List | Retrieving table column information. |
| Init DB | Selecting default database. |
| Kill | Killing another thread. |
| Long Data | Retrieving long data from the result of executing a prepared statement. |
| Ping | Handling a server ping request. |
| Prepare | Preparing a prepared statement. |
| Processlist | Preparing processlist information about server threads. |
| Query | Executing a statement. |
| Quit | In the process of terminating the thread. |
| Refresh | Flushing a table, logs or caches, or refreshing replication server or status variable information. |
| Register Slave | Registering a slave server. |
| Reset stmt | Resetting a prepared statement. |
| Set option | Setting or resetting a client statement execution option. |
| Sleep | Waiting for the client to send a new statement. |
| Shutdown | Shutting down the server. |
| Statistics | Preparing status information about the server. |
| Table Dump | Sending the contents of a table to a slave. |
| Time | Not used. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/thread-command-values/