1 performance_schema_max_cond_classes = 256 2 performance_schema_max_file_classes = 80 3 performance_schema_max_memory_classes = 320 4 performance_schema_max_mutex_classes =200 5 performance_schema_max_rwlock_classes = 80 6 performance_schema_max_socket_classes = 20 7 performance_schema_max_...
| performance_schema_events_waits_history_long_size | 10000 | | performance_schema_events_waits_history_size | 10 | | performance_schema_max_cond_classes | 80 | | performance_schema_max_cond_instances | 1000 | | performance_schema_max_file_classes | 50 | | performance_schema_max_file_hand...
1 performance_schema_max_cond_classes = 256 2 performance_schema_max_file_classes = 80 3 performance_schema_max_memory_classes = 320 4 performance_schema_max_mutex_classes =200 5 performance_schema_max_rwlock_classes = 80 6 performance_schema_max_socket_classes = 20 7 performance_schema_max_...
| performance_schema | ON | | performance_schema_events_waits_history_long_size | 10000 | | performance_schema_events_waits_history_size | 10 | | performance_schema_max_cond_classes | 80 | | performance_schema_max_cond_instances | 1000 | | performance_schema_max_file_classes | 50 | | ...
max_cond_classes | 80 | | performance_schema_max_cond_instances | -1 | | performance_schema_max_digest_length | 1024 | | performance_schema_max_file_classes | 50 | | performance_schema_max_file_handles | 32768 | | performance_schema_max_file_instances | -1 | | performance_schema_max...
_schema_hosts_size|-1||performance_schema_max_cond_classes|80||performance_schema_max_cond_instances|-1||performance_schema_max_digest_length|1024||performance_schema_max_file_classes|80||performance_schema_max_file_handles|32768||performance_schema_max_file_instances|-1||performance_schema_max_...
events_waits_history_size | 10 || performance_schema_hosts_size | -1 || performance_schema_max_cond_classes | 80 || performance_schema_max_cond_instances | -1 || performance_schema_max_digest_length | 1024 || performance_schema_max_file_classes | 80 || performance_schema_max_file_...
INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema'; +---+ | TABLE_NAME | +---+ 3 | accounts | | cond_instances | ... | events_stages_current | | events_stages_history | | events_stages_history_long | | events_stages_summary_by_account_by_event_name | | events_s...
performance-schema-instrumentYesYes Performance_schema_locker_lostYesGlobalNo performance_schema_max_cond_classesYesYesYesGlobalNo performance_schema_max_cond_instancesYesYesYesGlobalNo performance_schema_max_digest_lengthYesYesYesGlobalNo performance_schema_max_file_classesYesYesYesGlobalNo ...
mysql5.5版本新增了一个性能优化的引擎：PERFORMANCE_SCHEMA这个功能默认是关闭的： 需要设置参数：performance_schema才可以启动该功能，这个参数是静态参数，只能写在my.cnf中不能动态修改。 先看看有什么东西吧： mysql>useperformance_schema; Databasechanged mysql>showtables; +---+ |Tables_in_performance_schema...