1show databases; 2Database 3information_schema 4mtr 5mysql 6performance_schema 7test 8select count(*) from performance_schema.performance_timers; 9count(*) 105 11select count(*) from performance_schema.setup_consumers; 12count(*) 1312 14select count(*) > 3 from performance_schema.setup_instruments; 15count(*) > 3 161 17select count(*) from performance_schema.setup_timers; 18count(*) 194 20select * from performance_schema.accounts; 21select * from performance_schema.cond_instances; 22select * from performance_schema.events_stages_current; 23select * from performance_schema.events_stages_history; 24select * from performance_schema.events_stages_history_long; 25select * from performance_schema.events_stages_summary_by_account_by_event_name; 26select * from performance_schema.events_stages_summary_by_host_by_event_name; 27select * from performance_schema.events_stages_summary_by_thread_by_event_name; 28select * from performance_schema.events_stages_summary_by_user_by_event_name; 29select * from performance_schema.events_stages_summary_global_by_event_name; 30select * from performance_schema.events_statements_current; 31select * from performance_schema.events_statements_history; 32select * from performance_schema.events_statements_history_long; 33select * from performance_schema.events_statements_summary_by_account_by_event_name; 34select * from performance_schema.events_statements_summary_by_digest; 35select * from performance_schema.events_statements_summary_by_host_by_event_name; 36select * from performance_schema.events_statements_summary_by_thread_by_event_name; 37select * from performance_schema.events_statements_summary_by_user_by_event_name; 38select * from performance_schema.events_statements_summary_global_by_event_name; 39select * from performance_schema.events_waits_current; 40select * from performance_schema.events_waits_history; 41select * from performance_schema.events_waits_history_long; 42select * from performance_schema.events_waits_summary_by_account_by_event_name; 43select * from performance_schema.events_waits_summary_by_host_by_event_name; 44select * from performance_schema.events_waits_summary_by_instance; 45select * from performance_schema.events_waits_summary_by_thread_by_event_name; 46select * from performance_schema.events_waits_summary_by_user_by_event_name; 47select * from performance_schema.events_waits_summary_global_by_event_name; 48select * from performance_schema.file_instances; 49select * from performance_schema.file_summary_by_event_name; 50select * from performance_schema.file_summary_by_instance; 51select * from performance_schema.host_cache; 52select * from performance_schema.hosts; 53select * from performance_schema.mutex_instances; 54select * from performance_schema.objects_summary_global_by_type; 55select * from performance_schema.performance_timers; 56select * from performance_schema.rwlock_instances; 57select * from performance_schema.session_account_connect_attrs; 58select * from performance_schema.session_connect_attrs; 59select * from performance_schema.setup_actors; 60select * from performance_schema.setup_consumers; 61select * from performance_schema.setup_instruments; 62select * from performance_schema.setup_objects; 63select * from performance_schema.setup_timers; 64select * from performance_schema.socket_instances; 65select * from performance_schema.socket_summary_by_instance; 66select * from performance_schema.socket_summary_by_event_name; 67select * from performance_schema.table_io_waits_summary_by_index_usage; 68select * from performance_schema.table_io_waits_summary_by_table; 69select * from performance_schema.table_lock_waits_summary_by_table; 70select * from performance_schema.threads; 71select * from performance_schema.users; 72show variables where 73`Variable_name` != "performance_schema_max_statement_classes" and 74`Variable_name` like "performance_schema%"; 75Variable_name Value 76performance_schema ON 77performance_schema_accounts_size 100 78performance_schema_digests_size 200 79performance_schema_events_stages_history_long_size 1000 80performance_schema_events_stages_history_size 10 81performance_schema_events_statements_history_long_size 1000 82performance_schema_events_statements_history_size 10 83performance_schema_events_waits_history_long_size 10000 84performance_schema_events_waits_history_size 10 85performance_schema_hosts_size 100 86performance_schema_max_cond_classes 80 87performance_schema_max_cond_instances 1000 88performance_schema_max_digest_length 1024 89performance_schema_max_file_classes 0 90performance_schema_max_file_handles 32768 91performance_schema_max_file_instances 10000 92performance_schema_max_mutex_classes 200 93performance_schema_max_mutex_instances 5000 94performance_schema_max_rwlock_classes 40 95performance_schema_max_rwlock_instances 5000 96performance_schema_max_socket_classes 10 97performance_schema_max_socket_instances 1000 98performance_schema_max_stage_classes 150 99performance_schema_max_table_handles 1000 100performance_schema_max_table_instances 500 101performance_schema_max_thread_classes 50 102performance_schema_max_thread_instances 200 103performance_schema_session_connect_attrs_size 2048 104performance_schema_setup_actors_size 100 105performance_schema_setup_objects_size 100 106performance_schema_users_size 100 107show engine PERFORMANCE_SCHEMA status; 108show status like "performance_schema%"; 109show variables like "performance_schema_max_file_classes"; 110Variable_name Value 111performance_schema_max_file_classes 0 112select count(*) from performance_schema.setup_instruments 113where name like "wait/io/file/%"; 114count(*) 1150 116select variable_value > 0 from information_schema.global_status 117where variable_name like 'PERFORMANCE_SCHEMA_FILE_CLASSES_LOST'; 118variable_value > 0 1191 120select count(*) from performance_schema.file_instances; 121count(*) 1220 123show status like "performance_schema_file_instances_lost"; 124Variable_name Value 125Performance_schema_file_instances_lost 0 126