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