TP_THREAD_STATE table has one row
per thread created by the thread pool to handle connections.
TP_THREAD_STATE table has these
The thread group ID.
The ID of the thread within its thread group.
TP_THREAD_NUMBERtogether provide a unique key within the table.
The 10ms interval in which the statement that uses this thread is currently executing. 0 means no statement is executing, 1 means it is in the first 10ms, and so forth.
The type of wait for the thread.
NULLmeans the thread is not blocked. Otherwise, the thread is blocked by a call to
thd_wait_begin()and the value specifies the type of wait. The
columns of the
TP_THREAD_GROUP_STATStable accumulate counts for each wait type.
WAIT_TYPEvalue is a string that describes the type of wait, as shown in the following table.
Table 6.2 TP_THREAD_STATE Table WAIT_TYPE Values
Wait Type Meaning
Waiting for sleep
Waiting for Disk IO
Waiting for row lock
Waiting for global lock
Waiting for metadata lock
Waiting for table lock
Waiting for user lock
Waiting for binlog
Waiting for group commit
Waiting for fsync