INFORMATION_SCHEMA 线程池表已被弃用,并可能在未来版本的 MySQL 中移除。您应使用 Performance Schema 表中可用的版本。请参见 第 29.12.16 节,“Performance Schema 线程池表”。应用程序应从旧表过渡到新表。例如,如果应用程序使用以下查询: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;
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.
有关 INFORMATION_SCHEMA TP_THREAD_GROUP_STATE 表中列的描述,请参阅 第 29.12.16.2 节,“tp_thread_group_state 表”。Performance Schema tp_thread_group_state 表具有相应的列。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.