Binlog Dump

This is a thread on a master server for sending binary log contents to a slave server.

Change user

The thread is executing a change-user operation.

Close stmt

The thread is closing a prepared statement.

Connect

A replication slave is connected to its master.

Connect Out

A replication slave is connecting to its master.

Create DB

The thread is executing a create-database operation.

Daemon

This thread is internal to the server, not a thread that services a client connection.

Debug

The thread is generating debugging information.

Delayed insert

The thread is a delayed-insert handler.

Drop DB

The thread is executing a drop-database operation.

Error

Execute

The thread is executing a prepared statement.

Fetch

The thread is fetching the results from executing a prepared statement.

Field List

The thread is retrieving information for table columns.

Init DB

The thread is selecting a default database.

Kill

The thread is killing another thread.

Long Data

The thread is retrieving long data in the result of executing a prepared statement.

Ping

The thread is handling a server-ping request.

Prepare

The thread is preparing a prepared statement.

Processlist

The thread is producing information about server threads.

Query

The thread is executing a statement.

Quit

The thread is terminating.

Refresh

The thread is flushing table, logs, or caches, or resetting status variable or replication server information.

Register Slave

The thread is registering a slave server.

Reset stmt

The thread is resetting a prepared statement.

Set option

The thread is setting or resetting a client statement-execution option.

Shutdown

The thread is shutting down the server.

Sleep

The thread is waiting for the client to send a new statement to it.

Statistics

The thread is producing server-status information.

Table Dump

The thread is sending table contents to a slave server.

Time

Unused.