As of MySQL 8.0.14, the thread pool
INFORMATION_SCHEMA tables are also available
as Performance Schema tables. (See
Section 27.12.16, “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;
TP_THREAD_STATE table has one row per
thread created by the thread pool to handle connections.
For descriptions of the columns in the
TP_THREAD_STATE table, see
Section 18.104.22.168, “The tp_thread_state Table”. The
table has equivalent columns.