W3cubDocs

/MariaDB

Thread Command Values

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.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 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/