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