Documentation Home
MySQL 8.0 参考手册  / 第 27 章 MySQL 性能模式  /  22.16 性能模式状态变量

22.16 性能模式状态变量

Performance Schema 实现了几个状态变量,这些变量提供有关由于内存限制而无法加载或创建的仪器的信息:

Press CTRL+C to copy
mysql> SHOW STATUS LIKE 'perf%'; +-------------------------------------------+-------+ | Variable_name | Value | +-------------------------------------------+-------+ | Performance_schema_accounts_lost | 0 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_hosts_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_socket_classes_lost | 0 | | Performance_schema_socket_instances_lost | 0 | | Performance_schema_stage_classes_lost | 0 | | Performance_schema_statement_classes_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Performance_schema_users_lost | 0 | +-------------------------------------------+-------+

有关使用这些变量检查性能模式状态的信息,请参阅 第 22.7 节,“性能模式状态监控”

性能模式状态变量具有以下含义: