| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/perfschema/r/ (MariaDB Server Version 8.1-8.4©) Datei vom 1.9.2026 mit Größe 51 kB |
|
Quelle ortho_iter.result Sprache: Lisp |
|||||||||||||||
|
drop procedure if exists check_instrument; truncate table performance_schema.events_statements_summary_by_digest; flush global status; create procedure check_instrument(in instr_name varchar(128)) begin declare save_count_expected integer; declare count_expected 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); declare cmd_1 varchar(512); declare cmd_2 varchar(512); declare done integer default 0; declare dbg integer default 0; declare pfs_cursor CURSOR FOR select table_name from information_schema.tables where table_schema= 'performance_schema' and table_name like "%_by_event_name%" order by table_name; 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/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 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_me select count(name) from performance_schema.setup_instruments where (name like (concat(instr_name, "%"))) and (not name like "%/abstract/%") 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, "%\") t into @count_actual"); open pfs_cursor; 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_glo 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 dbg = 1 then select @cmd; end if; prepare stmt from @cmd; execute stmt; drop prepare stmt; set msg_detail= concat("table ", pfs_table_name, ", instruments ", count_expected, ", found ", @count_actual); 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_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; 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_table = 0 and @count_actual <> 0 then set msg= concat("Unexpected stage events: ", msg_detail); signal sqlstate '05000' set message_text= msg; end if; 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_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; -- Dont want to return a 02000 NOT FOUND, there should be a better way signal sqlstate '01000' set message_text='Done', mysql_errno=12000; end $ show global variables like "performance_schema%"; Variable_name Value performance_schema ON performance_schema_accounts_size 100 performance_schema_digests_size 200 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 1500 performance_schema_max_digest_length 1024 performance_schema_max_file_classes 80 performance_schema_max_file_handles 32768 performance_schema_max_file_instances 10000 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_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 performance_schema_max_sql_text_length 1024 performance_schema_max_stage_classes 170 performance_schema_max_statement_classes 227 performance_schema_max_statement_stack 10 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 400 performance_schema_session_connect_attrs_size 2048 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_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/synch/mutex/ 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/rwlock/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans 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_trans wait/synch/sxlock/ 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/cond/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/synch/cond/ 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/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/synch/ 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/io/file/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/io/file/ 1 1 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/io/socket/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/io/socket/ 1 0 1 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/io/table/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/io/table/ 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/io/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/io/ 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/lock/table/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/lock/table/ 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/lock/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/lock/ 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/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans wait/ 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("stage/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans stage/ 0 0 0 1 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("statement/com/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans statement/com/ 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("statement/sql/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans statement/sql/ 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("statement/abstract/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans statement/abstract/ 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("statement/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans 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_trans idle 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("memory/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans memory/ 0 0 0 0 0 1 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("memory/performance_schema/"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans memory/performance_schema/ 0 0 0 0 0 1 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("transaction"); instr_name is_wait is_wait_file is_wait_socket is_stage is_statement is_memory is_trans 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;
¤ Dauer der Verarbeitung: 0.14 Sekunden (vorverarbeitet am 2026-10-08) ¤*© Formatika GbR, Deutschland |
|
||||||||||||||
2026-10-10