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_GROUP_STATS;
The application should use this query instead:
SELECT * FROM performance_schema.tp_thread_group_stats;
The TP_THREAD_GROUP_STATS
table reports
statistics per thread group. There is one row per group.
For descriptions of the columns in the
INFORMATION_SCHEMA
TP_THREAD_GROUP_STATS
table, see
The tp_thread_group_stats Table.
The Performance Schema
tp_thread_group_stats
table has
equivalent columns.