Documentation Home
MySQL 8.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.7Mb
PDF (A4) - 40.8Mb
Man Pages (TGZ) - 293.3Kb
Man Pages (Zip) - 408.3Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.3 Reference Manual  /  ...  /  The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table

28.5.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table

Note

The INFORMATION_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 insted. See Section 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_STATE;

The application should use this query instead:

SELECT * FROM performance_schema.tp_thread_group_state;

The TP_THREAD_GROUP_STATE table has one row per thread group in the thread pool. Each row provides information about the current state of a group.

For descriptions of the columns in the INFORMATION_SCHEMA TP_THREAD_GROUP_STATE table, see Section 29.12.16.2, “The tp_thread_group_state Table”. The Performance Schema tp_thread_group_state table has equivalent columns.