mirror of
https://github.com/MariaDB/server.git
synced 2025-04-21 22:55:35 +02:00
e6961ea311
This patch adds support for SYS_REFCURSOR (a weakly typed cursor)
for both sql_mode=ORACLE and sql_mode=DEFAULT.
Works as a regular stored routine variable, parameter and return value:
- can be passed as an IN parameter to stored functions and procedures
- can be passed as an INOUT and OUT parameter to stored procedures
- can be returned from a stored function
Note, strongly typed REF CURSOR will be added separately.
Note, to maintain dependencies easier, some parts of sql_class.h
and item.h were moved to new header files:
- select_results.h:
class select_result_sink
class select_result
class select_result_interceptor
- sp_cursor.h:
class sp_cursor_statistics
class sp_cursor
- sp_rcontext_handler.h
class Sp_rcontext_handler and its descendants
The implementation consists of the following parts:
- A new class sp_cursor_array deriving from Dynamic_array
- A new class Statement_rcontext which contains data shared
between sub-statements of a compound statement.
It has a member m_statement_cursors of the sp_cursor_array data type,
as well as open cursor counter. THD inherits from Statement_rcontext.
- A new data type handler Type_handler_sys_refcursor in plugins/type_cursor/
It is designed to store uint16 references -
positions of the cursor in THD::m_statement_cursors.
- Type_handler_sys_refcursor suppresses some derived numeric features.
When a SYS_REFCURSOR variable is used as an integer an error is raised.
- A new abstract class sp_instr_fetch_cursor. It's needed to share
the common code between "OPEN cur" (for static cursors) and
"OPER cur FOR stmt" (for SYS_REFCURSORs).
- New sp_instr classes:
* sp_instr_copen_by_ref - OPEN sys_ref_curor FOR stmt;
* sp_instr_cfetch_by_ref - FETCH sys_ref_cursor INTO targets;
* sp_instr_cclose_by_ref - CLOSE sys_ref_cursor;
* sp_instr_destruct_variable - to destruct SYS_REFCURSOR variables when
the execution goes out of the BEGIN..END block
where SYS_REFCURSOR variables are declared.
- New methods in LEX:
* sp_open_cursor_for_stmt - handles "OPEN sys_ref_cursor FOR stmt".
* sp_add_instr_fetch_cursor - "FETCH cur INTO targets" for both
static cursors and SYS_REFCURSORs.
* sp_close - handles "CLOSE cur" both for static cursors and SYS_REFCURSORs.
- Changes in cursor functions to handle both static cursors and SYS_REFCURSORs:
* Item_func_cursor_isopen
* Item_func_cursor_found
* Item_func_cursor_notfound
* Item_func_cursor_rowcount
- A new system variable @@max_open_cursors - to limit the number
of cursors (static and SYS_REFCURSORs) opened at the same time.
Its allowed range is [0-65536], with 50 by default.
- A new virtual method Type_handler::can_return_bool() telling
if calling item->val_bool() is allowed for Items of this data type,
or if otherwise the "Illegal parameter for operation" error should be raised
at fix_fields() time.
- New methods in Sp_rcontext_handler:
* get_cursor()
* get_cursor_by_ref()
- A new class Sp_rcontext_handler_statement to handle top level statement
wide cursors which are shared by all substatements.
- A new virtual method expr_event_handler() in classes Item and Field.
It's needed to close (and make available for a new OPEN)
unused THD::m_statement_cursors elements which do not have any references
any more. It can happen in various moments in time, e.g.
* after evaluation parameters of an SQL routine
* after assigning a cursor expression into a SYS_REFCURSOR variable
* when leaving a BEGIN..END block with SYS_REFCURSOR variables
* after setting OUT/INOUT routine actual parameters from formal
parameters.
1504 lines
52 KiB
Text
1504 lines
52 KiB
Text
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_memory, is_transaction;
|
|
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_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 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 160
|
|
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_transaction
|
|
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_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
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_transaction
|
|
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_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
|
|
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_transaction
|
|
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_transaction
|
|
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_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;
|