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 instead. 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_STATE;
应用程序应改用此查询:The application should use this query instead:
SELECT * FROM performance_schema.tp_thread_state;
TP_THREAD_STATE 表为线程池创建的每个用于处理连接的线程包含一行。The TP_THREAD_STATE table has one row per
thread created by the thread pool to handle connections.
有关 INFORMATION_SCHEMA TP_THREAD_STATE 表中列的描述,请参见 第 29.12.16.4 节,“tp_thread_state 表”。Performance Schema 的 tp_thread_state 表具有等效的列。For descriptions of the columns in the
INFORMATION_SCHEMA
TP_THREAD_STATE table, see
Section 29.12.16.4, “The tp_thread_state Table”. The
Performance Schema tp_thread_state
table has equivalent columns.