# Thread Command Values

A thread can have any of the following `COMMAND` values (displayed by the `COMMAND` field listed by the [SHOW PROCESSLIST](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-processlist) statement or in the [Information Schema PROCESSLIST Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-processlist-table), as well as the `PROCESSLIST_COMMAND` value listed in the [Performance Schema threads Table](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-threads-table)). These indicate the nature of the thread's activity.

| Value          | Description                                                                                                                                                                                                                                                                                                        |
| -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Binlog Dump    | Master thread for sending [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log) contents to a slave.                                                                                                                                                                   |
| Change user    | Executing a change user operation.                                                                                                                                                                                                                                                                                 |
| Close stmt     | Closing a [prepared statement](https://mariadb.com/docs/server/reference/sql-statements/prepared-statements).                                                                                                                                                                                                      |
| Connect        | [Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-overview) 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](https://mariadb.com/docs/server/reference/sql-statements/prepared-statements).                                                                                                                                                                                                    |
| Fetch          | Fetching the results of an executed [prepared statement](https://mariadb.com/docs/server/reference/sql-statements/prepared-statements).                                                                                                                                                                            |
| 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](https://mariadb.com/docs/server/reference/sql-statements/prepared-statements).                                                                                                                                                            |
| Ping           | Handling a server ping request.                                                                                                                                                                                                                                                                                    |
| Prepare        | Preparing a [prepared statement](https://mariadb.com/docs/server/reference/sql-statements/prepared-statements).                                                                                                                                                                                                    |
| Processlist    | Preparing processlist information about server threads.                                                                                                                                                                                                                                                            |
| Query          | Executing a statement.                                                                                                                                                                                                                                                                                             |
| Quit           | In the process of terminating the thread.                                                                                                                                                                                                                                                                          |
| Refresh        | [Flushing](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush) a table, logs or caches, or refreshing replication server or [status variable](https://mariadb.com/docs/server/server-management/variables-and-modes/server-status-variables) information. |
| Register Slave | Registering a slave server.                                                                                                                                                                                                                                                                                        |
| Reset stmt     | Resetting a [prepared statement](https://mariadb.com/docs/server/reference/sql-statements/prepared-statements).                                                                                                                                                                                                    |
| 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.                                                                                                                                                                                                                                                                                                          |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-command-values.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.