Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.2 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA Thread Pool Tables  /  The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table

28.5.3 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table

Note

TheINFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of MySQL. You should use the versions available as Performance Schema tables instead. SeeSection 29.12.16, “Performance Schema Thread Pool Tables”. 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;

TheTP_THREAD_GROUP_STATS table reports statistics per thread group. There is one row per group.

For descriptions of the columns in theINFORMATION_SCHEMATP_THREAD_GROUP_STATS table, seeSection 29.12.16.3, “The tp_thread_group_stats Table”. The Performance Schematp_thread_group_stats table has equivalent columns.