Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

29.12.16.3 The tp_thread_state Table

Note

The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the correspondingINFORMATION_SCHEMA table instead; seeSection 28.5.4, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”.

Thetp_thread_state table has one row per thread created by the thread pool to handle connections.

Thetp_thread_state table has these columns:

  • TP_GROUP_ID

    The thread group ID.

  • TP_THREAD_NUMBER

    The ID of the thread within its thread group.TP_GROUP_ID andTP_THREAD_NUMBER together provide a unique key within the table.

  • PROCESS_COUNT

    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.

  • WAIT_TYPE

    The type of wait for the thread.NULL means the thread is not blocked. Otherwise, the thread is blocked by a call tothd_wait_begin() and the value specifies the type of wait. Thexxx_WAIT columns of thetp_thread_group_stats table accumulate counts for each wait type.

    TheWAIT_TYPE value is a string that describes the type of wait, as shown in the following table.

    Table 29.6 tp_thread_state Table WAIT_TYPE Values

    Wait TypeMeaning
    THD_WAIT_SLEEPWaiting for sleep
    THD_WAIT_DISKIOWaiting for Disk IO
    THD_WAIT_ROW_LOCKWaiting for row lock
    THD_WAIT_GLOBAL_LOCKWaiting for global lock
    THD_WAIT_META_DATA_LOCKWaiting for metadata lock
    THD_WAIT_TABLE_LOCKWaiting for table lock
    THD_WAIT_USER_LOCKWaiting for user lock
    THD_WAIT_BINLOGWaiting for binlog
    THD_WAIT_GROUP_COMMITWaiting for group commit
    THD_WAIT_SYNCWaiting for fsync

  • TP_THREAD_TYPE

    The type of thread. The value shown in this column is one ofCONNECTION_HANDLER_WORKER_THREAD,LISTENER_WORKER_THREAD,QUERY_WORKER_THREAD, orTIMER_WORKER_THREAD.

    This column was added in MySQL 8.0.32.

  • THREAD_ID

    This thread's unique identifier. The value is the same as that used in theTHREAD_ID column of the Performance Schemathreads table.

    This column was added in MySQL 8.0.32.

Thetp_thread_state table has these indexes:

  • Unique index on (TP_GROUP_ID,TP_THREAD_NUMBER)

TRUNCATE TABLE is not permitted for thetp_thread_state table.