MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

25.40.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table

Note

As of MySQL 8.0.14, the thread pool INFORMATION_SCHEMA tables are also available as Performance Schema tables. (See Section 26.12.15, “Performance Schema Thread Pool Tables”.) The INFORMATION_SCHEMA tables are deprecated and will be removed in a future MySQL version. 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 Section 26.12.15.2, “The tp_thread_group_stats Table”. The Performance Schema tp_thread_group_stats table has equivalent columns.