8.14.2 Thread Command Values
A thread can have any of the following Command values:
-
Binlog DumpThis is a thread on a replication source for sending binary log contents to a replica.
-
Change userThe thread is executing a change user operation.
-
Close stmtThe thread is closing a prepared statement.
-
ConnectA replica is connected to its source.
-
Connect OutA replica is connecting to its source.
-
Create DBThe thread is executing a create database operation.
-
DaemonThis thread is internal to the server, not a thread that services a client connection.
-
DebugThe thread is generating debugging information.
-
Delayed insertThe thread is a delayed insert handler.
-
Drop DBThe thread is executing a drop database operation.
Error-
ExecuteThe thread is executing a prepared statement.
-
FetchThe thread is fetching the results from executing a prepared statement.
-
Field ListThe thread is retrieving information for table columns.
-
Init DBThe thread is selecting a default database.
-
KillThe thread is killing another thread.
-
Long DataThe thread is retrieving long data in the result of executing a prepared statement.
-
PingThe thread is handling a server ping request.
-
PrepareThe thread is preparing a prepared statement.
-
ProcesslistThe thread is producing information about server threads.
-
QueryThe thread is executing a statement.
-
QuitThe thread is terminating.
-
RefreshThe thread is flushing table, logs, or caches, or resetting status variable or replication server information.
-
Register SlaveThe thread is registering a replica server.
-
Reset stmtThe thread is resetting a prepared statement.
-
Set optionThe thread is setting or resetting a client statement execution option.
-
ShutdownThe thread is shutting down the server.
-
SleepThe thread is waiting for the client to send a new statement to it.
-
StatisticsThe thread is producing server status information.
-
TimeUnused.
© 2025 Oracle
Licensed under the GPLv2 License.