diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/ortho_iter.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/ortho_iter.result | 859 |
1 files changed, 807 insertions, 52 deletions
diff --git a/mysql-test/suite/perfschema/r/ortho_iter.result b/mysql-test/suite/perfschema/r/ortho_iter.result index dfd31a80b3f..e1b00bdd0f4 100644 --- a/mysql-test/suite/perfschema/r/ortho_iter.result +++ b/mysql-test/suite/perfschema/r/ortho_iter.result @@ -3,14 +3,25 @@ truncate table performance_schema.events_statements_summary_by_digest; flush status; create procedure check_instrument(in instr_name varchar(128)) begin +declare save_count_expected integer; declare count_expected integer; -declare count_actual integer; +declare count_builtin_expected integer; +declare count_global_expected integer; declare is_wait integer; +declare is_wait_file integer; +declare is_wait_socket integer; declare is_stage integer; declare is_statement integer; +declare is_transaction integer; +declare is_memory integer; declare is_wait_table integer; +declare is_wait_file_table integer; +declare is_wait_socket_table integer; declare is_stage_table integer; declare is_statement_table integer; +declare is_transaction_table integer; +declare is_memory_table integer; +declare is_memory_global_table integer; declare pfs_table_name varchar(64); declare msg varchar(512); declare msg_detail varchar(512); @@ -21,19 +32,57 @@ declare debug integer default 0; declare pfs_cursor CURSOR FOR select table_name from information_schema.tables where table_schema= 'performance_schema' +<<<<<<< HEAD and table_name like "events_%_by_event_name%" order by table_name; +======= + and table_name like "%_by_event_name%"; +>>>>>>> 258e16fa2de... WIP 5.7 P_S declare continue handler for sqlstate '02000' set done = 1; -select (instr_name like "wait/%") or (instr_name like "idle/%") into is_wait; +select (instr_name like "wait/%") or (instr_name like "idle") into is_wait; +select (instr_name like "wait/io/file/%") into is_wait_file; +select (instr_name like "wait/io/socket/%") into is_wait_socket; select (instr_name like "stage/%") into is_stage; select (instr_name like "statement/%") into is_statement; -select instr_name, is_wait, is_stage, is_statement; +select (instr_name like "memory/%") into is_memory; +select (instr_name like "transaction") into is_transaction; +select instr_name, is_wait, is_wait_file, is_wait_socket, is_stage, is_statement, is_memory, is_transaction; select count(name) from performance_schema.setup_instruments where (name like (concat(instr_name, "%"))) and (not name like "%/abstract/%") -into count_expected; +and (not name like "memory/performance_schema/%") +into save_count_expected; +select count(name) +from performance_schema.setup_instruments +where (name like (concat(instr_name, "%"))) +and (name like "memory/performance_schema/%") +into count_builtin_expected; +select count(name) +from performance_schema.setup_instruments +where (name like (concat(instr_name, "%"))) +and (name in ( +"memory/sql/buffered_logs", +"memory/sql/sql_acl_mem", +"memory/sql/sql_acl_memex", +"memory/sql/acl_cache", +"memory/sql/TABLE_SHARE::mem_root", +"memory/sql/TABLE", +"memory/sql/Query_cache", +"memory/sql/native_functions", +"memory/sql/Event_basic::mem_root", +"memory/sql/root", +"memory/sql/load_env_plugins", +"memory/sql/plugin_ref", +"memory/sql/plugin_mem_root", +"memory/sql/plugin_bookmark", +"memory/csv/TINA_SHARE", +"memory/sql/tz_storage", +"memory/sql/servers_cache", +"memory/sql/udf_mem" + )) +into count_global_expected; set cmd_1= "select count(*) from (select distinct event_name from performance_schema."; set cmd_2= concat(" where event_name like \"", instr_name, @@ -43,8 +92,22 @@ repeat fetch pfs_cursor into pfs_table_name; if not done then select (pfs_table_name like "%waits%") into is_wait_table; +select (pfs_table_name like "file_summary%") into is_wait_file_table; +select (pfs_table_name like "socket_summary%") into is_wait_socket_table; select (pfs_table_name like "%stages%") into is_stage_table; select (pfs_table_name like "%statements%") into is_statement_table; +select (pfs_table_name like "%memory%") into is_memory_table; +select (pfs_table_name like "memory_summary_global_by_event_name") into is_memory_global_table; +select (pfs_table_name like "%transaction%") into is_transaction_table; +set count_expected = save_count_expected; +if is_memory_global_table +then +set count_expected = save_count_expected + count_builtin_expected; +end if; +if is_memory_table = 1 and is_memory_global_table = 0 +then +set count_expected = save_count_expected - count_global_expected; +end if; select concat("Checking table ", pfs_table_name, " ...") as status; select concat(cmd_1, pfs_table_name, cmd_2) into @cmd; if debug = 1 @@ -57,37 +120,101 @@ drop prepare stmt; set msg_detail= concat("table ", pfs_table_name, ", instruments ", count_expected, ", found ", @count_actual); -if is_wait = 1 and is_wait_table = 1 and @count_actual <> count_expected +if is_wait = 1 +then +if is_wait_table = 1 and @count_actual <> count_expected then set msg= concat("Missing wait events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; -if is_wait = 1 and is_wait_table = 0 and @count_actual <> 0 +if is_wait_table = 0 +and is_wait_file_table = 0 +and is_wait_socket_table = 0 +and @count_actual <> 0 then set msg= concat("Unexpected wait events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; -if is_stage = 1 and is_stage_table = 1 and @count_actual <> count_expected +end if; +if is_wait_file = 1 +then +if is_wait_file_table = 1 and @count_actual <> count_expected +then +set msg= concat("Missing wait/io/file events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +if is_wait_table = 0 and is_wait_file_table = 0 and @count_actual <> 0 +then +set msg= concat("Unexpected wait/io/file events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +end if; +if is_wait_socket = 1 +then +if is_wait_socket_table = 1 and @count_actual <> count_expected +then +set msg= concat("Missing wait/io/socket events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +if is_wait_table = 0 and is_wait_socket_table = 0 and @count_actual <> 0 +then +set msg= concat("Unexpected wait/io/socket events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +end if; +if is_stage = 1 +then +if is_stage_table = 1 and @count_actual <> count_expected then set msg= concat("Missing stage events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; -if is_stage = 1 and is_stage_table = 0 and @count_actual <> 0 +if is_stage_table = 0 and @count_actual <> 0 then set msg= concat("Unexpected stage events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; -if is_statement = 1 and is_statement_table = 1 and @count_actual <> count_expected +end if; +if is_statement = 1 +then +if is_statement_table = 1 and @count_actual <> count_expected then set msg= concat("Missing statement events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; -if is_statement = 1 and is_statement_table = 0 and @count_actual <> 0 +if is_statement_table = 0 and @count_actual <> 0 then set msg= concat("Unexpected statement events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; end if; +if is_memory = 1 +then +if is_memory_table = 1 and @count_actual <> count_expected +then +set msg= concat("Missing memory events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +if is_memory_table = 0 and @count_actual <> 0 +then +set msg= concat("Unexpected memory events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +end if; +if is_transaction = 1 +then +if is_transaction_table = 1 and @count_actual <> count_expected +then +set msg= concat("Missing transaction events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +if is_transaction_table = 0 and @count_actual <> 0 +then +set msg= concat("Unexpected transaction events: ", msg_detail); +signal sqlstate '05000' set message_text= msg; +end if; +end if; +end if; until done end repeat; close pfs_cursor; @@ -95,11 +222,15 @@ close pfs_cursor; signal sqlstate '01000' set message_text='Done', mysql_errno=12000; end $ +<<<<<<< HEAD Warnings: Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead show variables where `Variable_name` != "performance_schema_max_statement_classes" and `Variable_name` like "performance_schema%"; +======= +show global variables like "performance_schema%"; +>>>>>>> 258e16fa2de... WIP 5.7 P_S Variable_name Value performance_schema ON performance_schema_accounts_size 100 @@ -108,24 +239,39 @@ performance_schema_events_stages_history_long_size 1000 performance_schema_events_stages_history_size 10 performance_schema_events_statements_history_long_size 1000 performance_schema_events_statements_history_size 10 +performance_schema_events_transactions_history_long_size 1000 +performance_schema_events_transactions_history_size 10 performance_schema_events_waits_history_long_size 10000 performance_schema_events_waits_history_size 10 performance_schema_hosts_size 100 performance_schema_max_cond_classes 90 performance_schema_max_cond_instances 1000 performance_schema_max_digest_length 1024 -performance_schema_max_file_classes 50 +performance_schema_max_file_classes 80 performance_schema_max_file_handles 32768 performance_schema_max_file_instances 10000 -performance_schema_max_mutex_classes 200 +performance_schema_max_index_stat 5000 +performance_schema_max_memory_classes 320 +performance_schema_max_metadata_locks 10000 +performance_schema_max_mutex_classes 210 performance_schema_max_mutex_instances 5000 -performance_schema_max_rwlock_classes 40 +performance_schema_max_prepared_statements_instances 100 +performance_schema_max_program_instances 5000 +performance_schema_max_rwlock_classes 50 performance_schema_max_rwlock_instances 5000 performance_schema_max_socket_classes 10 performance_schema_max_socket_instances 1000 +<<<<<<< HEAD performance_schema_max_stage_classes 160 +======= +performance_schema_max_sql_text_length 1024 +performance_schema_max_stage_classes 150 +performance_schema_max_statement_classes 193 +performance_schema_max_statement_stack 10 +>>>>>>> 258e16fa2de... WIP 5.7 P_S performance_schema_max_table_handles 1000 performance_schema_max_table_instances 500 +performance_schema_max_table_lock_stat 500 performance_schema_max_thread_classes 50 performance_schema_max_thread_instances 200 performance_schema_session_connect_attrs_size 2048 @@ -133,8 +279,8 @@ performance_schema_setup_actors_size 100 performance_schema_setup_objects_size 100 performance_schema_users_size 100 call check_instrument("wait/synch/mutex/"); -instr_name is_wait is_stage is_statement -wait/synch/mutex/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/synch/mutex/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -156,6 +302,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -165,11 +321,84 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/synch/rwlock/"); -instr_name is_wait is_stage is_statement -wait/synch/rwlock/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/synch/rwlock/ 1 0 0 0 0 0 0 +status +Checking table events_stages_summary_by_account_by_event_name ... +status +Checking table events_stages_summary_by_host_by_event_name ... +status +Checking table events_stages_summary_by_thread_by_event_name ... +status +Checking table events_stages_summary_by_user_by_event_name ... +status +Checking table events_stages_summary_global_by_event_name ... +status +Checking table events_statements_summary_by_account_by_event_name ... +status +Checking table events_statements_summary_by_host_by_event_name ... +status +Checking table events_statements_summary_by_thread_by_event_name ... +status +Checking table events_statements_summary_by_user_by_event_name ... +status +Checking table events_statements_summary_global_by_event_name ... +status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status +Checking table events_waits_summary_by_account_by_event_name ... +status +Checking table events_waits_summary_by_host_by_event_name ... +status +Checking table events_waits_summary_by_thread_by_event_name ... +status +Checking table events_waits_summary_by_user_by_event_name ... +status +Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... +Warnings: +Warning 12000 Done +call check_instrument("wait/synch/sxlock/"); +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/synch/sxlock/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -191,6 +420,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -200,11 +439,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/synch/cond/"); -instr_name is_wait is_stage is_statement -wait/synch/cond/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/synch/cond/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -226,6 +479,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -235,11 +498,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/synch/"); -instr_name is_wait is_stage is_statement -wait/synch/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/synch/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -261,6 +538,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -270,11 +557,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/io/file/"); -instr_name is_wait is_stage is_statement -wait/io/file/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/io/file/ 1 1 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -296,6 +597,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -305,11 +616,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done -call check_instrument("wait/io/net/"); -instr_name is_wait is_stage is_statement -wait/io/net/ 1 0 0 +call check_instrument("wait/io/socket/"); +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/io/socket/ 1 0 1 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -331,6 +656,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -340,11 +675,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/io/table/"); -instr_name is_wait is_stage is_statement -wait/io/table/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/io/table/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -366,6 +715,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -375,11 +734,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/io/"); -instr_name is_wait is_stage is_statement -wait/io/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/io/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -401,6 +774,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -410,11 +793,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/lock/table/"); -instr_name is_wait is_stage is_statement -wait/lock/table/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/lock/table/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -436,6 +833,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -445,11 +852,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/lock/"); -instr_name is_wait is_stage is_statement -wait/lock/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/lock/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -471,6 +892,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -480,11 +911,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("wait/"); -instr_name is_wait is_stage is_statement -wait/ 1 0 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +wait/ 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -506,6 +951,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -515,11 +970,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("stage/"); -instr_name is_wait is_stage is_statement -stage/ 0 1 0 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +stage/ 0 0 0 1 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -541,6 +1010,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -550,11 +1029,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("statement/com/"); -instr_name is_wait is_stage is_statement -statement/com/ 0 0 1 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +statement/com/ 0 0 0 0 1 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -576,6 +1069,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -585,11 +1088,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("statement/sql/"); -instr_name is_wait is_stage is_statement -statement/sql/ 0 0 1 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +statement/sql/ 0 0 0 0 1 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -611,6 +1128,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -620,11 +1147,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("statement/abstract/"); -instr_name is_wait is_stage is_statement -statement/abstract/ 0 0 1 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +statement/abstract/ 0 0 0 0 1 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -646,6 +1187,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -655,11 +1206,84 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done call check_instrument("statement/"); -instr_name is_wait is_stage is_statement -statement/ 0 0 1 +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +statement/ 0 0 0 0 1 0 0 +status +Checking table events_stages_summary_by_account_by_event_name ... +status +Checking table events_stages_summary_by_host_by_event_name ... +status +Checking table events_stages_summary_by_thread_by_event_name ... +status +Checking table events_stages_summary_by_user_by_event_name ... +status +Checking table events_stages_summary_global_by_event_name ... +status +Checking table events_statements_summary_by_account_by_event_name ... +status +Checking table events_statements_summary_by_host_by_event_name ... +status +Checking table events_statements_summary_by_thread_by_event_name ... +status +Checking table events_statements_summary_by_user_by_event_name ... +status +Checking table events_statements_summary_global_by_event_name ... +status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status +Checking table events_waits_summary_by_account_by_event_name ... +status +Checking table events_waits_summary_by_host_by_event_name ... +status +Checking table events_waits_summary_by_thread_by_event_name ... +status +Checking table events_waits_summary_by_user_by_event_name ... +status +Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... +Warnings: +Warning 12000 Done +call check_instrument("idle"); +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +idle 1 0 0 0 0 0 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -681,6 +1305,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -690,11 +1324,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done -call check_instrument("idle/io/socket"); -instr_name is_wait is_stage is_statement -idle/io/socket 1 0 0 +call check_instrument("memory/"); +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +memory/ 0 0 0 0 0 1 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -716,6 +1364,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -725,11 +1383,25 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done -call check_instrument("idle/"); -instr_name is_wait is_stage is_statement -idle/ 1 0 0 +call check_instrument("memory/performance_schema/"); +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +memory/performance_schema/ 0 0 0 0 0 1 0 status Checking table events_stages_summary_by_account_by_event_name ... status @@ -751,6 +1423,16 @@ Checking table events_statements_summary_by_user_by_event_name ... status Checking table events_statements_summary_global_by_event_name ... status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status Checking table events_waits_summary_by_account_by_event_name ... status Checking table events_waits_summary_by_host_by_event_name ... @@ -760,6 +1442,79 @@ status Checking table events_waits_summary_by_user_by_event_name ... status Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... +Warnings: +Warning 12000 Done +call check_instrument("transaction"); +instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_transaction +transaction 0 0 0 0 0 0 1 +status +Checking table events_stages_summary_by_account_by_event_name ... +status +Checking table events_stages_summary_by_host_by_event_name ... +status +Checking table events_stages_summary_by_thread_by_event_name ... +status +Checking table events_stages_summary_by_user_by_event_name ... +status +Checking table events_stages_summary_global_by_event_name ... +status +Checking table events_statements_summary_by_account_by_event_name ... +status +Checking table events_statements_summary_by_host_by_event_name ... +status +Checking table events_statements_summary_by_thread_by_event_name ... +status +Checking table events_statements_summary_by_user_by_event_name ... +status +Checking table events_statements_summary_global_by_event_name ... +status +Checking table events_transactions_summary_by_account_by_event_name ... +status +Checking table events_transactions_summary_by_host_by_event_name ... +status +Checking table events_transactions_summary_by_thread_by_event_name ... +status +Checking table events_transactions_summary_by_user_by_event_name ... +status +Checking table events_transactions_summary_global_by_event_name ... +status +Checking table events_waits_summary_by_account_by_event_name ... +status +Checking table events_waits_summary_by_host_by_event_name ... +status +Checking table events_waits_summary_by_thread_by_event_name ... +status +Checking table events_waits_summary_by_user_by_event_name ... +status +Checking table events_waits_summary_global_by_event_name ... +status +Checking table file_summary_by_event_name ... +status +Checking table memory_summary_by_account_by_event_name ... +status +Checking table memory_summary_by_host_by_event_name ... +status +Checking table memory_summary_by_thread_by_event_name ... +status +Checking table memory_summary_by_user_by_event_name ... +status +Checking table memory_summary_global_by_event_name ... +status +Checking table socket_summary_by_event_name ... Warnings: Warning 12000 Done drop procedure check_instrument; |