mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
1f4a9f086a
This was done after discussions with Igor, Sanja and Bar. The main reason for removing the deprication was to ensure that MariaDB is always backward compatible whenever possible. Other things: - Added statistics counters, mainly for the feedback plugin. - INTO OUTFILE - INTO variable - If INTO is using the old syntax (end of query)
256 lines
21 KiB
Text
256 lines
21 KiB
Text
#
|
|
# Create a temporary table of performance schema table names
|
|
#
|
|
CREATE TEMPORARY TABLE table_list (id INT AUTO_INCREMENT, PRIMARY KEY (id)) AS
|
|
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
|
|
WHERE TABLE_SCHEMA='performance_schema'
|
|
ORDER BY TABLE_NAME;
|
|
SELECT COUNT(*) FROM table_list INTO @table_count;
|
|
#
|
|
# For each table in the performance schema, attempt HANDLER...OPEN,
|
|
# which should fail with an error 1031, ER_ILLEGAL_HA.
|
|
#
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=81;
|
|
HANDLER performance_schema.user_variables_by_thread OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`user_variables_by_thread` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=80;
|
|
HANDLER performance_schema.users OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`users` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=79;
|
|
HANDLER performance_schema.threads OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`threads` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=78;
|
|
HANDLER performance_schema.table_lock_waits_summary_by_table OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_lock_waits_summary_by_table` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=77;
|
|
HANDLER performance_schema.table_io_waits_summary_by_table OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_io_waits_summary_by_table` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=76;
|
|
HANDLER performance_schema.table_io_waits_summary_by_index_usage OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_io_waits_summary_by_index_usage` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=75;
|
|
HANDLER performance_schema.table_handles OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`table_handles` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=74;
|
|
HANDLER performance_schema.status_by_user OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`status_by_user` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=73;
|
|
HANDLER performance_schema.status_by_thread OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`status_by_thread` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=72;
|
|
HANDLER performance_schema.status_by_host OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`status_by_host` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=71;
|
|
HANDLER performance_schema.status_by_account OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`status_by_account` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=70;
|
|
HANDLER performance_schema.socket_summary_by_instance OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`socket_summary_by_instance` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=69;
|
|
HANDLER performance_schema.socket_summary_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`socket_summary_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=68;
|
|
HANDLER performance_schema.socket_instances OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`socket_instances` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=67;
|
|
HANDLER performance_schema.setup_timers OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_timers` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=66;
|
|
HANDLER performance_schema.setup_objects OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_objects` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=65;
|
|
HANDLER performance_schema.setup_instruments OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_instruments` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=64;
|
|
HANDLER performance_schema.setup_consumers OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_consumers` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=63;
|
|
HANDLER performance_schema.setup_actors OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`setup_actors` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=62;
|
|
HANDLER performance_schema.session_status OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`session_status` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=61;
|
|
HANDLER performance_schema.session_connect_attrs OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`session_connect_attrs` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=60;
|
|
HANDLER performance_schema.session_account_connect_attrs OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`session_account_connect_attrs` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=59;
|
|
HANDLER performance_schema.rwlock_instances OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`rwlock_instances` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=58;
|
|
HANDLER performance_schema.replication_connection_configuration OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`replication_connection_configuration` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=57;
|
|
HANDLER performance_schema.replication_applier_status_by_worker OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`replication_applier_status_by_worker` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=56;
|
|
HANDLER performance_schema.replication_applier_status_by_coordinator OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`replication_applier_status_by_coordinator` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=55;
|
|
HANDLER performance_schema.replication_applier_status OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`replication_applier_status` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=54;
|
|
HANDLER performance_schema.replication_applier_configuration OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`replication_applier_configuration` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=53;
|
|
HANDLER performance_schema.prepared_statements_instances OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`prepared_statements_instances` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=52;
|
|
HANDLER performance_schema.performance_timers OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`performance_timers` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=51;
|
|
HANDLER performance_schema.objects_summary_global_by_type OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`objects_summary_global_by_type` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=50;
|
|
HANDLER performance_schema.mutex_instances OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`mutex_instances` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=49;
|
|
HANDLER performance_schema.metadata_locks OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`metadata_locks` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=48;
|
|
HANDLER performance_schema.memory_summary_global_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`memory_summary_global_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=47;
|
|
HANDLER performance_schema.memory_summary_by_user_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`memory_summary_by_user_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=46;
|
|
HANDLER performance_schema.memory_summary_by_thread_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`memory_summary_by_thread_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=45;
|
|
HANDLER performance_schema.memory_summary_by_host_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`memory_summary_by_host_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=44;
|
|
HANDLER performance_schema.memory_summary_by_account_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`memory_summary_by_account_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=43;
|
|
HANDLER performance_schema.host_cache OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`host_cache` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=42;
|
|
HANDLER performance_schema.hosts OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`hosts` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=41;
|
|
HANDLER performance_schema.global_status OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`global_status` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=40;
|
|
HANDLER performance_schema.file_summary_by_instance OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`file_summary_by_instance` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=39;
|
|
HANDLER performance_schema.file_summary_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`file_summary_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=38;
|
|
HANDLER performance_schema.file_instances OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`file_instances` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=37;
|
|
HANDLER performance_schema.events_waits_summary_global_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_global_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=36;
|
|
HANDLER performance_schema.events_waits_summary_by_user_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_user_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=35;
|
|
HANDLER performance_schema.events_waits_summary_by_thread_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_thread_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=34;
|
|
HANDLER performance_schema.events_waits_summary_by_instance OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_instance` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=33;
|
|
HANDLER performance_schema.events_waits_summary_by_host_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_host_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=32;
|
|
HANDLER performance_schema.events_waits_summary_by_account_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_summary_by_account_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=31;
|
|
HANDLER performance_schema.events_waits_history_long OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_history_long` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=30;
|
|
HANDLER performance_schema.events_waits_history OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_history` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=29;
|
|
HANDLER performance_schema.events_waits_current OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_waits_current` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=28;
|
|
HANDLER performance_schema.events_transactions_summary_global_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_summary_global_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=27;
|
|
HANDLER performance_schema.events_transactions_summary_by_user_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_summary_by_user_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=26;
|
|
HANDLER performance_schema.events_transactions_summary_by_thread_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_summary_by_thread_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=25;
|
|
HANDLER performance_schema.events_transactions_summary_by_host_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_summary_by_host_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=24;
|
|
HANDLER performance_schema.events_transactions_summary_by_account_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_summary_by_account_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=23;
|
|
HANDLER performance_schema.events_transactions_history_long OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_history_long` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=22;
|
|
HANDLER performance_schema.events_transactions_history OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_history` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=21;
|
|
HANDLER performance_schema.events_transactions_current OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_transactions_current` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=20;
|
|
HANDLER performance_schema.events_statements_summary_global_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_global_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=19;
|
|
HANDLER performance_schema.events_statements_summary_by_user_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_user_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=18;
|
|
HANDLER performance_schema.events_statements_summary_by_thread_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_thread_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=17;
|
|
HANDLER performance_schema.events_statements_summary_by_program OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_program` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=16;
|
|
HANDLER performance_schema.events_statements_summary_by_host_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_host_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=15;
|
|
HANDLER performance_schema.events_statements_summary_by_digest OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_digest` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=14;
|
|
HANDLER performance_schema.events_statements_summary_by_account_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_summary_by_account_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=13;
|
|
HANDLER performance_schema.events_statements_history_long OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_history_long` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=12;
|
|
HANDLER performance_schema.events_statements_history OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_history` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=11;
|
|
HANDLER performance_schema.events_statements_current OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_statements_current` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=10;
|
|
HANDLER performance_schema.events_stages_summary_global_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_global_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=9;
|
|
HANDLER performance_schema.events_stages_summary_by_user_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_user_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=8;
|
|
HANDLER performance_schema.events_stages_summary_by_thread_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_thread_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=7;
|
|
HANDLER performance_schema.events_stages_summary_by_host_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_host_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=6;
|
|
HANDLER performance_schema.events_stages_summary_by_account_by_event_name OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_summary_by_account_by_event_name` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=5;
|
|
HANDLER performance_schema.events_stages_history_long OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_history_long` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=4;
|
|
HANDLER performance_schema.events_stages_history OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_history` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=3;
|
|
HANDLER performance_schema.events_stages_current OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`events_stages_current` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=2;
|
|
HANDLER performance_schema.cond_instances OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`cond_instances` doesn't have this option
|
|
SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=1;
|
|
HANDLER performance_schema.accounts OPEN;
|
|
ERROR HY000: Storage engine PERFORMANCE_SCHEMA of the table `performance_schema`.`accounts` doesn't have this option
|
|
DROP TEMPORARY TABLE table_list;
|