1 2# Create a temporary table of performance schema table names 3 4CREATE TEMPORARY TABLE table_list (id INT AUTO_INCREMENT, PRIMARY KEY (id)) AS 5SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES 6WHERE TABLE_SCHEMA='performance_schema' 7 ORDER BY TABLE_NAME; 8SELECT COUNT(*) FROM table_list INTO @table_count; 9 10# For each table in the performance schema, attempt HANDLER...OPEN, 11# which should fail with an error 1031, ER_ILLEGAL_HA. 12 13SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=52; 14HANDLER performance_schema.users OPEN; 15ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`users` doesn't have this option 16SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=51; 17HANDLER performance_schema.threads OPEN; 18ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`threads` doesn't have this option 19SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=50; 20HANDLER performance_schema.table_lock_waits_summary_by_table OPEN; 21ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_lock_waits_summary_by_table` doesn't have this option 22SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=49; 23HANDLER performance_schema.table_io_waits_summary_by_table OPEN; 24ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_io_waits_summary_by_table` doesn't have this option 25SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=48; 26HANDLER performance_schema.table_io_waits_summary_by_index_usage OPEN; 27ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_io_waits_summary_by_index_usage` doesn't have this option 28SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=47; 29HANDLER performance_schema.socket_summary_by_instance OPEN; 30ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`socket_summary_by_instance` doesn't have this option 31SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=46; 32HANDLER performance_schema.socket_summary_by_event_name OPEN; 33ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`socket_summary_by_event_name` doesn't have this option 34SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=45; 35HANDLER performance_schema.socket_instances OPEN; 36ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`socket_instances` doesn't have this option 37SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=44; 38HANDLER performance_schema.setup_timers OPEN; 39ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_timers` doesn't have this option 40SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=43; 41HANDLER performance_schema.setup_objects OPEN; 42ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_objects` doesn't have this option 43SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=42; 44HANDLER performance_schema.setup_instruments OPEN; 45ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_instruments` doesn't have this option 46SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=41; 47HANDLER performance_schema.setup_consumers OPEN; 48ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_consumers` doesn't have this option 49SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=40; 50HANDLER performance_schema.setup_actors OPEN; 51ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_actors` doesn't have this option 52SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=39; 53HANDLER performance_schema.session_connect_attrs OPEN; 54ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`session_connect_attrs` doesn't have this option 55SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=38; 56HANDLER performance_schema.session_account_connect_attrs OPEN; 57ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`session_account_connect_attrs` doesn't have this option 58SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=37; 59HANDLER performance_schema.rwlock_instances OPEN; 60ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`rwlock_instances` doesn't have this option 61SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=36; 62HANDLER performance_schema.performance_timers OPEN; 63ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`performance_timers` doesn't have this option 64SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=35; 65HANDLER performance_schema.objects_summary_global_by_type OPEN; 66ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`objects_summary_global_by_type` doesn't have this option 67SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=34; 68HANDLER performance_schema.mutex_instances OPEN; 69ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`mutex_instances` doesn't have this option 70SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=33; 71HANDLER performance_schema.host_cache OPEN; 72ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`host_cache` doesn't have this option 73SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=32; 74HANDLER performance_schema.hosts OPEN; 75ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`hosts` doesn't have this option 76SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=31; 77HANDLER performance_schema.file_summary_by_instance OPEN; 78ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`file_summary_by_instance` doesn't have this option 79SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=30; 80HANDLER performance_schema.file_summary_by_event_name OPEN; 81ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`file_summary_by_event_name` doesn't have this option 82SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=29; 83HANDLER performance_schema.file_instances OPEN; 84ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`file_instances` doesn't have this option 85SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=28; 86HANDLER performance_schema.events_waits_summary_global_by_event_name OPEN; 87ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_global_by_event_name` doesn't have this option 88SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=27; 89HANDLER performance_schema.events_waits_summary_by_user_by_event_name OPEN; 90ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_user_by_event_name` doesn't have this option 91SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=26; 92HANDLER performance_schema.events_waits_summary_by_thread_by_event_name OPEN; 93ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_thread_by_event_name` doesn't have this option 94SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=25; 95HANDLER performance_schema.events_waits_summary_by_instance OPEN; 96ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_instance` doesn't have this option 97SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=24; 98HANDLER performance_schema.events_waits_summary_by_host_by_event_name OPEN; 99ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_host_by_event_name` doesn't have this option 100SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=23; 101HANDLER performance_schema.events_waits_summary_by_account_by_event_name OPEN; 102ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_account_by_event_name` doesn't have this option 103SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=22; 104HANDLER performance_schema.events_waits_history_long OPEN; 105ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_history_long` doesn't have this option 106SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=21; 107HANDLER performance_schema.events_waits_history OPEN; 108ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_history` doesn't have this option 109SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=20; 110HANDLER performance_schema.events_waits_current OPEN; 111ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_current` doesn't have this option 112SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=19; 113HANDLER performance_schema.events_statements_summary_global_by_event_name OPEN; 114ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_global_by_event_name` doesn't have this option 115SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=18; 116HANDLER performance_schema.events_statements_summary_by_user_by_event_name OPEN; 117ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_user_by_event_name` doesn't have this option 118SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=17; 119HANDLER performance_schema.events_statements_summary_by_thread_by_event_name OPEN; 120ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_thread_by_event_name` doesn't have this option 121SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=16; 122HANDLER performance_schema.events_statements_summary_by_host_by_event_name OPEN; 123ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_host_by_event_name` doesn't have this option 124SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=15; 125HANDLER performance_schema.events_statements_summary_by_digest OPEN; 126ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_digest` doesn't have this option 127SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=14; 128HANDLER performance_schema.events_statements_summary_by_account_by_event_name OPEN; 129ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_account_by_event_name` doesn't have this option 130SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=13; 131HANDLER performance_schema.events_statements_history_long OPEN; 132ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_history_long` doesn't have this option 133SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=12; 134HANDLER performance_schema.events_statements_history OPEN; 135ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_history` doesn't have this option 136SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=11; 137HANDLER performance_schema.events_statements_current OPEN; 138ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_current` doesn't have this option 139SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=10; 140HANDLER performance_schema.events_stages_summary_global_by_event_name OPEN; 141ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_global_by_event_name` doesn't have this option 142SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=9; 143HANDLER performance_schema.events_stages_summary_by_user_by_event_name OPEN; 144ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_user_by_event_name` doesn't have this option 145SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=8; 146HANDLER performance_schema.events_stages_summary_by_thread_by_event_name OPEN; 147ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_thread_by_event_name` doesn't have this option 148SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=7; 149HANDLER performance_schema.events_stages_summary_by_host_by_event_name OPEN; 150ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_host_by_event_name` doesn't have this option 151SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=6; 152HANDLER performance_schema.events_stages_summary_by_account_by_event_name OPEN; 153ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_account_by_event_name` doesn't have this option 154SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=5; 155HANDLER performance_schema.events_stages_history_long OPEN; 156ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_history_long` doesn't have this option 157SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=4; 158HANDLER performance_schema.events_stages_history OPEN; 159ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_history` doesn't have this option 160SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=3; 161HANDLER performance_schema.events_stages_current OPEN; 162ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_current` doesn't have this option 163SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=2; 164HANDLER performance_schema.cond_instances OPEN; 165ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`cond_instances` doesn't have this option 166SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=1; 167HANDLER performance_schema.accounts OPEN; 168ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`accounts` doesn't have this option 169DROP TEMPORARY TABLE table_list; 170