1show databases; 2Database 3information_schema 4mtr 5mysql 6performance_schema 7sys 8test 9select count(*) from performance_schema.performance_timers; 10count(*) 115 12select count(*) from performance_schema.setup_consumers; 13count(*) 1415 15select count(*) > 4 from performance_schema.setup_instruments; 16count(*) > 4 171 18select count(*) from performance_schema.setup_timers; 19count(*) 205 21Warnings: 22Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. 23select * from performance_schema.accounts; 24select * from performance_schema.cond_instances; 25select * from performance_schema.events_stages_current; 26select * from performance_schema.events_stages_history; 27select * from performance_schema.events_stages_history_long; 28select * from performance_schema.events_stages_summary_by_account_by_event_name; 29select * from performance_schema.events_stages_summary_by_host_by_event_name; 30select * from performance_schema.events_stages_summary_by_thread_by_event_name; 31select * from performance_schema.events_stages_summary_by_user_by_event_name; 32select * from performance_schema.events_stages_summary_global_by_event_name; 33select * from performance_schema.events_statements_current; 34select * from performance_schema.events_statements_history; 35select * from performance_schema.events_statements_history_long; 36select * from performance_schema.events_statements_summary_by_account_by_event_name; 37select * from performance_schema.events_statements_summary_by_digest; 38select * from performance_schema.events_statements_summary_by_host_by_event_name; 39select * from performance_schema.events_statements_summary_by_thread_by_event_name; 40select * from performance_schema.events_statements_summary_by_user_by_event_name; 41select * from performance_schema.events_statements_summary_global_by_event_name; 42select * from performance_schema.events_transactions_current; 43select * from performance_schema.events_transactions_history; 44select * from performance_schema.events_transactions_history_long; 45select * from performance_schema.events_transactions_summary_by_account_by_event_name; 46select * from performance_schema.events_transactions_summary_by_host_by_event_name; 47select * from performance_schema.events_transactions_summary_by_thread_by_event_name; 48select * from performance_schema.events_transactions_summary_by_user_by_event_name; 49select * from performance_schema.events_transactions_summary_global_by_event_name; 50select * from performance_schema.events_waits_current; 51select * from performance_schema.events_waits_history; 52select * from performance_schema.events_waits_history_long; 53select * from performance_schema.events_waits_summary_by_account_by_event_name; 54select * from performance_schema.events_waits_summary_by_host_by_event_name; 55select * from performance_schema.events_waits_summary_by_instance; 56select * from performance_schema.events_waits_summary_by_thread_by_event_name; 57select * from performance_schema.events_waits_summary_by_user_by_event_name; 58select * from performance_schema.events_waits_summary_global_by_event_name; 59select * from performance_schema.memory_summary_by_account_by_event_name; 60select * from performance_schema.memory_summary_by_host_by_event_name; 61select * from performance_schema.memory_summary_by_thread_by_event_name; 62select * from performance_schema.memory_summary_by_user_by_event_name; 63select * from performance_schema.memory_summary_global_by_event_name; 64select * from performance_schema.file_instances; 65select * from performance_schema.file_summary_by_event_name; 66select * from performance_schema.file_summary_by_instance; 67select * from performance_schema.host_cache; 68select * from performance_schema.hosts; 69select * from performance_schema.memory_summary_by_account_by_event_name; 70select * from performance_schema.memory_summary_by_host_by_event_name; 71select * from performance_schema.memory_summary_by_thread_by_event_name; 72select * from performance_schema.memory_summary_by_user_by_event_name; 73select * from performance_schema.memory_summary_global_by_event_name; 74select * from performance_schema.metadata_locks; 75select * from performance_schema.mutex_instances; 76select * from performance_schema.objects_summary_global_by_type; 77select * from performance_schema.performance_timers; 78select * from performance_schema.rwlock_instances; 79select * from performance_schema.session_account_connect_attrs; 80select * from performance_schema.session_connect_attrs; 81select * from performance_schema.setup_actors; 82select * from performance_schema.setup_consumers; 83select * from performance_schema.setup_instruments; 84select * from performance_schema.setup_objects; 85select * from performance_schema.setup_timers; 86select * from performance_schema.socket_instances; 87select * from performance_schema.socket_summary_by_instance; 88select * from performance_schema.socket_summary_by_event_name; 89select * from performance_schema.table_handles; 90select * from performance_schema.table_io_waits_summary_by_index_usage; 91select * from performance_schema.table_io_waits_summary_by_table; 92select * from performance_schema.table_lock_waits_summary_by_table; 93select * from performance_schema.threads; 94select * from performance_schema.users; 95select * from performance_schema.replication_connection_configuration; 96select * from performance_schema.replication_connection_status; 97select * from performance_schema.replication_applier_configuration; 98select * from performance_schema.replication_applier_status; 99select * from performance_schema.replication_applier_status_by_coordinator; 100select * from performance_schema.replication_applier_status_by_worker; 101select * from performance_schema.global_status; 102select * from performance_schema.status_by_thread; 103select * from performance_schema.status_by_user; 104select * from performance_schema.status_by_host; 105select * from performance_schema.status_by_account; 106select * from performance_schema.session_status; 107select * from performance_schema.global_variables; 108select * from performance_schema.variables_by_thread; 109select * from performance_schema.session_variables; 110show global variables where 111`Variable_name` != "performance_schema_max_statement_classes" and 112`Variable_name` like "performance_schema%"; 113Variable_name Value 114performance_schema ON 115performance_schema_accounts_size 100 116performance_schema_digests_size 200 117performance_schema_events_stages_history_long_size 1000 118performance_schema_events_stages_history_size 10 119performance_schema_events_statements_history_long_size 1000 120performance_schema_events_statements_history_size 10 121performance_schema_events_transactions_history_long_size 1000 122performance_schema_events_transactions_history_size 10 123performance_schema_events_waits_history_long_size 10000 124performance_schema_events_waits_history_size 10 125performance_schema_hosts_size 100 126performance_schema_max_cond_classes 80 127performance_schema_max_cond_instances -1 128performance_schema_max_digest_length 1024 129performance_schema_max_file_classes 80 130performance_schema_max_file_handles 32768 131performance_schema_max_file_instances -1 132performance_schema_max_index_stat -1 133performance_schema_max_memory_classes 400 134performance_schema_max_metadata_locks -1 135performance_schema_max_mutex_classes 0 136performance_schema_max_mutex_instances -1 137performance_schema_max_prepared_statements_instances -1 138performance_schema_max_program_instances -1 139performance_schema_max_rwlock_classes 50 140performance_schema_max_rwlock_instances -1 141performance_schema_max_socket_classes 10 142performance_schema_max_socket_instances -1 143performance_schema_max_sql_text_length 1024 144performance_schema_max_stage_classes 150 145performance_schema_max_statement_stack 10 146performance_schema_max_table_handles -1 147performance_schema_max_table_instances -1 148performance_schema_max_table_lock_stat -1 149performance_schema_max_thread_classes 50 150performance_schema_max_thread_instances -1 151performance_schema_session_connect_attrs_size 2048 152performance_schema_setup_actors_size 100 153performance_schema_setup_objects_size 100 154performance_schema_users_size 100 155show engine PERFORMANCE_SCHEMA status; 156show global status like "performance_schema%"; 157show global variables like "performance_schema_max_mutex_classes"; 158Variable_name Value 159performance_schema_max_mutex_classes 0 160select count(*) from performance_schema.setup_instruments 161where name like "wait/synch/mutex/%"; 162count(*) 1630 164select variable_value > 0 from information_schema.global_status 165where variable_name like 'PERFORMANCE_SCHEMA_MUTEX_CLASSES_LOST'; 166variable_value > 0 1671 168select count(*) from performance_schema.mutex_instances; 169count(*) 1700 171show global status like "performance_schema_mutex_instances_lost"; 172Variable_name Value 173Performance_schema_mutex_instances_lost 0 174