MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

26.12.15.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 corresponding INFORMATION_SCHEMA table instead; see Section 25.40.3, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”.

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

The tp_thread_state table has these columns:

The tp_thread_state table has these indexes:

TRUNCATE TABLE is not permitted for the tp_thread_state table.