This table has one row per thread created by the thread pool to handle connections. The table has these columns:
The thread group ID.
The ID of the thread within its thread group.
TP_THREAD_NUMBER together 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.
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
table accumulate counts for each wait type.
WAIT_TYPE value is a string that
describes the type of wait, as shown in the following table.
|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|
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices