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