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=87; 13HANDLER performance_schema.variables_by_thread OPEN; 14ERROR HY000: Table storage engine for 'variables_by_thread' doesn't have this option 15SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=86; 16HANDLER performance_schema.users OPEN; 17ERROR HY000: Table storage engine for 'users' doesn't have this option 18SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=85; 19HANDLER performance_schema.user_variables_by_thread OPEN; 20ERROR HY000: Table storage engine for 'user_variables_by_thread' doesn't have this option 21SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=84; 22HANDLER performance_schema.threads OPEN; 23ERROR HY000: Table storage engine for 'threads' doesn't have this option 24SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=83; 25HANDLER performance_schema.table_lock_waits_summary_by_table OPEN; 26ERROR HY000: Table storage engine for 'table_lock_waits_summary_by_table' doesn't have this option 27SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=82; 28HANDLER performance_schema.table_io_waits_summary_by_table OPEN; 29ERROR HY000: Table storage engine for 'table_io_waits_summary_by_table' doesn't have this option 30SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=81; 31HANDLER performance_schema.table_io_waits_summary_by_index_usage OPEN; 32ERROR HY000: Table storage engine for 'table_io_waits_summary_by_index_usage' doesn't have this option 33SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=80; 34HANDLER performance_schema.table_handles OPEN; 35ERROR HY000: Table storage engine for 'table_handles' doesn't have this option 36SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=79; 37HANDLER performance_schema.status_by_user OPEN; 38ERROR HY000: Table storage engine for 'status_by_user' doesn't have this option 39SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=78; 40HANDLER performance_schema.status_by_thread OPEN; 41ERROR HY000: Table storage engine for 'status_by_thread' doesn't have this option 42SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=77; 43HANDLER performance_schema.status_by_host OPEN; 44ERROR HY000: Table storage engine for 'status_by_host' doesn't have this option 45SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=76; 46HANDLER performance_schema.status_by_account OPEN; 47ERROR HY000: Table storage engine for 'status_by_account' doesn't have this option 48SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=75; 49HANDLER performance_schema.socket_summary_by_instance OPEN; 50ERROR HY000: Table storage engine for 'socket_summary_by_instance' doesn't have this option 51SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=74; 52HANDLER performance_schema.socket_summary_by_event_name OPEN; 53ERROR HY000: Table storage engine for 'socket_summary_by_event_name' doesn't have this option 54SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=73; 55HANDLER performance_schema.socket_instances OPEN; 56ERROR HY000: Table storage engine for 'socket_instances' doesn't have this option 57SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=72; 58HANDLER performance_schema.setup_timers OPEN; 59ERROR HY000: Table storage engine for 'setup_timers' doesn't have this option 60SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=71; 61HANDLER performance_schema.setup_objects OPEN; 62ERROR HY000: Table storage engine for 'setup_objects' doesn't have this option 63SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=70; 64HANDLER performance_schema.setup_instruments OPEN; 65ERROR HY000: Table storage engine for 'setup_instruments' doesn't have this option 66SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=69; 67HANDLER performance_schema.setup_consumers OPEN; 68ERROR HY000: Table storage engine for 'setup_consumers' doesn't have this option 69SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=68; 70HANDLER performance_schema.setup_actors OPEN; 71ERROR HY000: Table storage engine for 'setup_actors' doesn't have this option 72SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=67; 73HANDLER performance_schema.session_variables OPEN; 74ERROR HY000: Table storage engine for 'session_variables' doesn't have this option 75SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=66; 76HANDLER performance_schema.session_status OPEN; 77ERROR HY000: Table storage engine for 'session_status' doesn't have this option 78SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=65; 79HANDLER performance_schema.session_connect_attrs OPEN; 80ERROR HY000: Table storage engine for 'session_connect_attrs' doesn't have this option 81SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=64; 82HANDLER performance_schema.session_account_connect_attrs OPEN; 83ERROR HY000: Table storage engine for 'session_account_connect_attrs' doesn't have this option 84SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=63; 85HANDLER performance_schema.rwlock_instances OPEN; 86ERROR HY000: Table storage engine for 'rwlock_instances' doesn't have this option 87SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=62; 88HANDLER performance_schema.replication_group_members OPEN; 89ERROR HY000: Table storage engine for 'replication_group_members' doesn't have this option 90SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=61; 91HANDLER performance_schema.replication_group_member_stats OPEN; 92ERROR HY000: Table storage engine for 'replication_group_member_stats' doesn't have this option 93SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=60; 94HANDLER performance_schema.replication_connection_status OPEN; 95ERROR HY000: Table storage engine for 'replication_connection_status' doesn't have this option 96SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=59; 97HANDLER performance_schema.replication_connection_configuration OPEN; 98ERROR HY000: Table storage engine for 'replication_connection_configuration' doesn't have this option 99SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=58; 100HANDLER performance_schema.replication_applier_status_by_worker OPEN; 101ERROR HY000: Table storage engine for 'replication_applier_status_by_worker' doesn't have this option 102SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=57; 103HANDLER performance_schema.replication_applier_status_by_coordinator OPEN; 104ERROR HY000: Table storage engine for 'replication_applier_status_by_coordinator' doesn't have this option 105SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=56; 106HANDLER performance_schema.replication_applier_status OPEN; 107ERROR HY000: Table storage engine for 'replication_applier_status' doesn't have this option 108SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=55; 109HANDLER performance_schema.replication_applier_configuration OPEN; 110ERROR HY000: Table storage engine for 'replication_applier_configuration' doesn't have this option 111SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=54; 112HANDLER performance_schema.prepared_statements_instances OPEN; 113ERROR HY000: Table storage engine for 'prepared_statements_instances' doesn't have this option 114SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=53; 115HANDLER performance_schema.performance_timers OPEN; 116ERROR HY000: Table storage engine for 'performance_timers' doesn't have this option 117SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=52; 118HANDLER performance_schema.objects_summary_global_by_type OPEN; 119ERROR HY000: Table storage engine for 'objects_summary_global_by_type' doesn't have this option 120SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=51; 121HANDLER performance_schema.mutex_instances OPEN; 122ERROR HY000: Table storage engine for 'mutex_instances' doesn't have this option 123SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=50; 124HANDLER performance_schema.metadata_locks OPEN; 125ERROR HY000: Table storage engine for 'metadata_locks' doesn't have this option 126SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=49; 127HANDLER performance_schema.memory_summary_global_by_event_name OPEN; 128ERROR HY000: Table storage engine for 'memory_summary_global_by_event_name' doesn't have this option 129SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=48; 130HANDLER performance_schema.memory_summary_by_user_by_event_name OPEN; 131ERROR HY000: Table storage engine for 'memory_summary_by_user_by_event_name' doesn't have this option 132SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=47; 133HANDLER performance_schema.memory_summary_by_thread_by_event_name OPEN; 134ERROR HY000: Table storage engine for 'memory_summary_by_thread_by_event_name' doesn't have this option 135SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=46; 136HANDLER performance_schema.memory_summary_by_host_by_event_name OPEN; 137ERROR HY000: Table storage engine for 'memory_summary_by_host_by_event_name' doesn't have this option 138SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=45; 139HANDLER performance_schema.memory_summary_by_account_by_event_name OPEN; 140ERROR HY000: Table storage engine for 'memory_summary_by_account_by_event_name' doesn't have this option 141SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=44; 142HANDLER performance_schema.hosts OPEN; 143ERROR HY000: Table storage engine for 'hosts' doesn't have this option 144SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=43; 145HANDLER performance_schema.host_cache OPEN; 146ERROR HY000: Table storage engine for 'host_cache' doesn't have this option 147SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=42; 148HANDLER performance_schema.global_variables OPEN; 149ERROR HY000: Table storage engine for 'global_variables' doesn't have this option 150SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=41; 151HANDLER performance_schema.global_status OPEN; 152ERROR HY000: Table storage engine for 'global_status' doesn't have this option 153SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=40; 154HANDLER performance_schema.file_summary_by_instance OPEN; 155ERROR HY000: Table storage engine for 'file_summary_by_instance' doesn't have this option 156SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=39; 157HANDLER performance_schema.file_summary_by_event_name OPEN; 158ERROR HY000: Table storage engine for 'file_summary_by_event_name' doesn't have this option 159SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=38; 160HANDLER performance_schema.file_instances OPEN; 161ERROR HY000: Table storage engine for 'file_instances' doesn't have this option 162SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=37; 163HANDLER performance_schema.events_waits_summary_global_by_event_name OPEN; 164ERROR HY000: Table storage engine for 'events_waits_summary_global_by_event_name' doesn't have this option 165SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=36; 166HANDLER performance_schema.events_waits_summary_by_user_by_event_name OPEN; 167ERROR HY000: Table storage engine for 'events_waits_summary_by_user_by_event_name' doesn't have this option 168SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=35; 169HANDLER performance_schema.events_waits_summary_by_thread_by_event_name OPEN; 170ERROR HY000: Table storage engine for 'events_waits_summary_by_thread_by_event_name' doesn't have this option 171SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=34; 172HANDLER performance_schema.events_waits_summary_by_instance OPEN; 173ERROR HY000: Table storage engine for 'events_waits_summary_by_instance' doesn't have this option 174SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=33; 175HANDLER performance_schema.events_waits_summary_by_host_by_event_name OPEN; 176ERROR HY000: Table storage engine for 'events_waits_summary_by_host_by_event_name' doesn't have this option 177SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=32; 178HANDLER performance_schema.events_waits_summary_by_account_by_event_name OPEN; 179ERROR HY000: Table storage engine for 'events_waits_summary_by_account_by_event_name' doesn't have this option 180SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=31; 181HANDLER performance_schema.events_waits_history_long OPEN; 182ERROR HY000: Table storage engine for 'events_waits_history_long' doesn't have this option 183SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=30; 184HANDLER performance_schema.events_waits_history OPEN; 185ERROR HY000: Table storage engine for 'events_waits_history' doesn't have this option 186SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=29; 187HANDLER performance_schema.events_waits_current OPEN; 188ERROR HY000: Table storage engine for 'events_waits_current' doesn't have this option 189SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=28; 190HANDLER performance_schema.events_transactions_summary_global_by_event_name OPEN; 191ERROR HY000: Table storage engine for 'events_transactions_summary_global_by_event_name' doesn't have this option 192SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=27; 193HANDLER performance_schema.events_transactions_summary_by_user_by_event_name OPEN; 194ERROR HY000: Table storage engine for 'events_transactions_summary_by_user_by_event_name' doesn't have this option 195SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=26; 196HANDLER performance_schema.events_transactions_summary_by_thread_by_event_name OPEN; 197ERROR HY000: Table storage engine for 'events_transactions_summary_by_thread_by_event_name' doesn't have this option 198SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=25; 199HANDLER performance_schema.events_transactions_summary_by_host_by_event_name OPEN; 200ERROR HY000: Table storage engine for 'events_transactions_summary_by_host_by_event_name' doesn't have this option 201SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=24; 202HANDLER performance_schema.events_transactions_summary_by_account_by_event_name OPEN; 203ERROR HY000: Table storage engine for 'events_transactions_summary_by_account_by_event_name' doesn't have this option 204SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=23; 205HANDLER performance_schema.events_transactions_history_long OPEN; 206ERROR HY000: Table storage engine for 'events_transactions_history_long' doesn't have this option 207SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=22; 208HANDLER performance_schema.events_transactions_history OPEN; 209ERROR HY000: Table storage engine for 'events_transactions_history' doesn't have this option 210SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=21; 211HANDLER performance_schema.events_transactions_current OPEN; 212ERROR HY000: Table storage engine for 'events_transactions_current' doesn't have this option 213SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=20; 214HANDLER performance_schema.events_statements_summary_global_by_event_name OPEN; 215ERROR HY000: Table storage engine for 'events_statements_summary_global_by_event_name' doesn't have this option 216SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=19; 217HANDLER performance_schema.events_statements_summary_by_user_by_event_name OPEN; 218ERROR HY000: Table storage engine for 'events_statements_summary_by_user_by_event_name' doesn't have this option 219SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=18; 220HANDLER performance_schema.events_statements_summary_by_thread_by_event_name OPEN; 221ERROR HY000: Table storage engine for 'events_statements_summary_by_thread_by_event_name' doesn't have this option 222SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=17; 223HANDLER performance_schema.events_statements_summary_by_program OPEN; 224ERROR HY000: Table storage engine for 'events_statements_summary_by_program' doesn't have this option 225SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=16; 226HANDLER performance_schema.events_statements_summary_by_host_by_event_name OPEN; 227ERROR HY000: Table storage engine for 'events_statements_summary_by_host_by_event_name' doesn't have this option 228SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=15; 229HANDLER performance_schema.events_statements_summary_by_digest OPEN; 230ERROR HY000: Table storage engine for 'events_statements_summary_by_digest' doesn't have this option 231SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=14; 232HANDLER performance_schema.events_statements_summary_by_account_by_event_name OPEN; 233ERROR HY000: Table storage engine for 'events_statements_summary_by_account_by_event_name' doesn't have this option 234SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=13; 235HANDLER performance_schema.events_statements_history_long OPEN; 236ERROR HY000: Table storage engine for 'events_statements_history_long' doesn't have this option 237SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=12; 238HANDLER performance_schema.events_statements_history OPEN; 239ERROR HY000: Table storage engine for 'events_statements_history' doesn't have this option 240SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=11; 241HANDLER performance_schema.events_statements_current OPEN; 242ERROR HY000: Table storage engine for 'events_statements_current' doesn't have this option 243SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=10; 244HANDLER performance_schema.events_stages_summary_global_by_event_name OPEN; 245ERROR HY000: Table storage engine for 'events_stages_summary_global_by_event_name' doesn't have this option 246SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=9; 247HANDLER performance_schema.events_stages_summary_by_user_by_event_name OPEN; 248ERROR HY000: Table storage engine for 'events_stages_summary_by_user_by_event_name' doesn't have this option 249SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=8; 250HANDLER performance_schema.events_stages_summary_by_thread_by_event_name OPEN; 251ERROR HY000: Table storage engine for 'events_stages_summary_by_thread_by_event_name' doesn't have this option 252SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=7; 253HANDLER performance_schema.events_stages_summary_by_host_by_event_name OPEN; 254ERROR HY000: Table storage engine for 'events_stages_summary_by_host_by_event_name' doesn't have this option 255SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=6; 256HANDLER performance_schema.events_stages_summary_by_account_by_event_name OPEN; 257ERROR HY000: Table storage engine for 'events_stages_summary_by_account_by_event_name' doesn't have this option 258SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=5; 259HANDLER performance_schema.events_stages_history_long OPEN; 260ERROR HY000: Table storage engine for 'events_stages_history_long' doesn't have this option 261SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=4; 262HANDLER performance_schema.events_stages_history OPEN; 263ERROR HY000: Table storage engine for 'events_stages_history' doesn't have this option 264SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=3; 265HANDLER performance_schema.events_stages_current OPEN; 266ERROR HY000: Table storage engine for 'events_stages_current' doesn't have this option 267SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=2; 268HANDLER performance_schema.cond_instances OPEN; 269ERROR HY000: Table storage engine for 'cond_instances' doesn't have this option 270SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=1; 271HANDLER performance_schema.accounts OPEN; 272ERROR HY000: Table storage engine for 'accounts' doesn't have this option 273DROP TEMPORARY TABLE table_list; 274