1show databases; 2Database 3information_schema 4mtr 5mysql 6performance_schema 7sys 8test 9select count(*) from performance_schema.performance_timers; 10count(*) 114 12select count(*) from performance_schema.setup_consumers; 13count(*) 1415 15select count(*) > 4 from performance_schema.setup_instruments; 16count(*) > 4 171 18select * from performance_schema.accounts; 19select * from performance_schema.cond_instances; 20select * from performance_schema.events_stages_current; 21select * from performance_schema.events_stages_history; 22select * from performance_schema.events_stages_history_long; 23select * from performance_schema.events_stages_summary_by_account_by_event_name; 24select * from performance_schema.events_stages_summary_by_host_by_event_name; 25select * from performance_schema.events_stages_summary_by_thread_by_event_name; 26select * from performance_schema.events_stages_summary_by_user_by_event_name; 27select * from performance_schema.events_stages_summary_global_by_event_name; 28select * from performance_schema.events_statements_current; 29select * from performance_schema.events_statements_histogram_by_digest; 30select * from performance_schema.events_statements_histogram_global; 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_transactions_current; 40select * from performance_schema.events_transactions_history; 41select * from performance_schema.events_transactions_history_long; 42select * from performance_schema.events_transactions_summary_by_account_by_event_name; 43select * from performance_schema.events_transactions_summary_by_host_by_event_name; 44select * from performance_schema.events_transactions_summary_by_thread_by_event_name; 45select * from performance_schema.events_transactions_summary_by_user_by_event_name; 46select * from performance_schema.events_transactions_summary_global_by_event_name; 47select * from performance_schema.events_waits_current; 48select * from performance_schema.events_waits_history; 49select * from performance_schema.events_waits_history_long; 50select * from performance_schema.events_waits_summary_by_account_by_event_name; 51select * from performance_schema.events_waits_summary_by_host_by_event_name; 52select * from performance_schema.events_waits_summary_by_instance; 53select * from performance_schema.events_waits_summary_by_thread_by_event_name; 54select * from performance_schema.events_waits_summary_by_user_by_event_name; 55select * from performance_schema.events_waits_summary_global_by_event_name; 56select * from performance_schema.memory_summary_by_account_by_event_name; 57select * from performance_schema.memory_summary_by_host_by_event_name; 58select * from performance_schema.memory_summary_by_thread_by_event_name; 59select * from performance_schema.memory_summary_by_user_by_event_name; 60select * from performance_schema.memory_summary_global_by_event_name; 61select * from performance_schema.events_errors_summary_by_account_by_error; 62select * from performance_schema.events_errors_summary_by_host_by_error; 63select * from performance_schema.events_errors_summary_by_thread_by_error; 64select * from performance_schema.events_errors_summary_by_user_by_error; 65select * from performance_schema.events_errors_summary_global_by_error; 66select * from performance_schema.file_instances; 67select * from performance_schema.file_summary_by_event_name; 68select * from performance_schema.file_summary_by_instance; 69select * from performance_schema.host_cache; 70select * from performance_schema.hosts; 71select * from performance_schema.memory_summary_by_account_by_event_name; 72select * from performance_schema.memory_summary_by_host_by_event_name; 73select * from performance_schema.memory_summary_by_thread_by_event_name; 74select * from performance_schema.memory_summary_by_user_by_event_name; 75select * from performance_schema.memory_summary_global_by_event_name; 76select * from performance_schema.metadata_locks; 77select * from performance_schema.mutex_instances; 78select * from performance_schema.objects_summary_global_by_type; 79select * from performance_schema.performance_timers; 80select * from performance_schema.rwlock_instances; 81select * from performance_schema.data_locks; 82select * from performance_schema.data_lock_waits; 83select * from performance_schema.session_account_connect_attrs; 84select * from performance_schema.session_connect_attrs; 85select * from performance_schema.setup_actors; 86select * from performance_schema.setup_consumers; 87select * from performance_schema.setup_instruments; 88select * from performance_schema.setup_objects; 89select * from performance_schema.setup_threads; 90select * from performance_schema.socket_instances; 91select * from performance_schema.socket_summary_by_instance; 92select * from performance_schema.socket_summary_by_event_name; 93select * from performance_schema.table_handles; 94select * from performance_schema.table_io_waits_summary_by_index_usage; 95select * from performance_schema.table_io_waits_summary_by_table; 96select * from performance_schema.table_lock_waits_summary_by_table; 97select * from performance_schema.threads; 98select * from performance_schema.users; 99select * from performance_schema.replication_connection_configuration; 100select * from performance_schema.replication_connection_status; 101select * from performance_schema.replication_applier_configuration; 102select * from performance_schema.replication_applier_status; 103select * from performance_schema.replication_applier_status_by_coordinator; 104select * from performance_schema.replication_applier_status_by_worker; 105select * from performance_schema.global_status; 106select * from performance_schema.status_by_thread; 107select * from performance_schema.status_by_user; 108select * from performance_schema.status_by_host; 109select * from performance_schema.status_by_account; 110select * from performance_schema.session_status; 111select * from performance_schema.global_variables; 112select * from performance_schema.variables_by_thread; 113select * from performance_schema.session_variables; 114show engine PERFORMANCE_SCHEMA status; 115show global status like "performance_schema%"; 116CREATE DATABASE db; 117USE db; 118show global variables like "performance_schema_max_prepared_statements_instances"; 119Variable_name Value 120performance_schema_max_prepared_statements_instances 0 121select count(*) from performance_schema.prepared_statements_instances; 122count(*) 1230 124truncate table performance_schema.prepared_statements_instances; 125CREATE TABLE t1 (a INT NOT NULL); 126INSERT INTO t1 VALUES (4), (8), (11), (32), (80); 127PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; 128SET @table = 't1'; 129SET @s = CONCAT('SELECT * FROM ', @table); 130PREPARE st2 FROM @s; 131PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?'; 132PREPARE st4 FROM 133'(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a'; 134show global status like "%performance_schema_prepared_statements_lost%"; 135Variable_name Value 136Performance_schema_prepared_statements_lost 4 137SET @a = 3; 138SET @b = 4; 139EXECUTE st1 USING @a, @b; 140hypotenuse 1415 142EXECUTE st2; 143a 1444 1458 14611 14732 14880 149SET @c=3; 150EXECUTE st3 using @c; 151EXECUTE st4; 152a 1534 1548 15511 15614 15718 15821 15932 16042 16180 16290 163show global status like "%performance_schema_prepared_statements_lost%"; 164Variable_name Value 165Performance_schema_prepared_statements_lost 4 166DEALLOCATE PREPARE st1; 167DEALLOCATE PREPARE st2; 168DEALLOCATE PREPARE st3; 169DEALLOCATE PREPARE st4; 170DROP TABLE t1; 171show global status like "%performance_schema_prepared_statements_lost%"; 172Variable_name Value 173Performance_schema_prepared_statements_lost 4 174flush status; 175show global status like "%performance_schema_prepared_statements_lost%"; 176Variable_name Value 177Performance_schema_prepared_statements_lost 0 178DROP DATABASE db; 179