Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


MySQL Information Schema  /  INFORMATION_SCHEMA Thread Pool Tables  /  The INFORMATION_SCHEMA TP_THREAD_STATE Table

6.4 The INFORMATION_SCHEMA TP_THREAD_STATE Table

Note

As of MySQL 8.0.14, the thread pool INFORMATION_SCHEMA tables are also available as Performance Schema tables. (See Performance Schema Thread Pool Tables.) The INFORMATION_SCHEMA tables are deprecated; expect them to be removed in a future version of MySQL. Applications should transition away from the old tables to the new tables. For example, if an application uses this query:

SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE;

The application should use this query instead:

SELECT * FROM performance_schema.tp_thread_state;

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

For descriptions of the columns in the INFORMATION_SCHEMA TP_THREAD_STATE table, see The tp_thread_state Table. The Performance Schema tp_thread_state table has equivalent columns.