mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2026-01-10 05:24:49 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/perfschema/r/ortho_iter.result
Alexander Barkov 75142ff496 MDEV-36053 CURSOR declarations in PACKAGE BODY 
This change adds CURSOR declarations inside PACKAGE BODY.

PL/SQL mode:

  SET sql_mode=ORACLE;
  CREATE PACKAGE BODY pkg AS
    CURSOR mc0 IS SELECT c0, c1 FROM t1;
    PROCEDURE p1 AS
      rec mc0%ROWTYPE;
    BEGIN
      OPEN mc0;
      FETCH mc0 INTO rec;
      CLOSE mc0
    END;
  END;
  /

SQL/PSM mode:

  SET sql_mode=DEFAULT;
  CREATE PACKAGE BODY pkg
    mc0 CURSOR FOR SELECT c0, c1 FROM t1;
    PROCEDURE p1()
    BEGIN
      DECLARE rec ROW TYPE OF mc0;
      OPEN mc0;
      FETCH mc0 INTO rec;
      CLOSE mc0
    END;
  END;
  /

PACKAGE BODY cursors like local cursors
(declared inside a FUNCTION or a PROCEDURE) support:
  - OPEN/FETCH/CLOSE
  - FOR rec IN cur - an explicit cursor loop
  - Using a cursor row as an anchored variable data type:
    * DECLARE var cur%ROWTYPE;     -- sql_mode=ORACLE
    * DECLARE var ROW TYPE OF cur; -- sql_mode=DEFAULT

The patch details:

- Changing various class members and function/method parameters which
  store a CURSOR run-time address from "uint" to sp_rcontext_addr.
  A few classes now derive from sp_rcontext_addr instead of having
  a "uint m_cursor;" member.

  This change uses the same idea with what we did for SP variables,
  when we implemented PACKAGE BODY variables a few years ago.

- Fixing the grammar in sql_yacc.yy to allow CURSOR declarations
  inside PACKAGE BODY.

- Adding a new class sp_pcontext_top. It's used for the top level parse
  context (of an sp_head). Note, its children contexts still use the old
  class sp_pcontext.

  sp_pcontext_top context additionally to sp_pcontext has:

    const sp_head *m_sp; -- The pointer to the sp_head owning this context
    Dynamic_array<sp_pcursor> m_member_cursors; -- PACKAGE BODY wide cursors

  m_sp->m_parent->get_parse_context() is used to find the sp_pcontext
  belonging to the parent PACKAGE BODY from a sp_pcontext_top instance
  belonging to a PROCEDURE/FUNCTION sp_pcontext_top.

- Adding a new member in sp_rcontext:
    Dynamic_array<sp_cursor*> m_member_cursors;
  It's used to store run-time data of PACKAGE BODY wide cursors.

- Adding a new class sp_instr_copen2. It's used to open PACKAGE BODY cursors.
  Unlike the usual cursors, PACKAGE BODY cursors:
  * do not use the cursor stack (sp_rcontext::m_cstack)
  * do not need a preceeding sp_instr_cpush
  * do not need a following sp_instr_cpop

  All cursor information such as "sp_lex_cursor" resides inside
  sp_instr_copen2 itself (rather than inside sp_instr_cpush which is
  used to store "sp_lex_cursor" in case of sp_instr_copen).

  Note, the other cursor related instructions:
    sp_instr_cfetch
    sp_instr_cclose
    sp_instr_cursor_copy_struct
  do not need sp_instr_xxx2 counter-parts.
  Thy just use sp_rcontext_addr to address cursors.

- Adding Sp_rcontext_handler_member
  It's used to handle PACKAGE BODY members:
  cursors and variables declared in the PACKAGE BODY,
  when they are accessed from its executable initialization section:

    CREATE PACKAGE BODY pkg AS
      CURSOR mc0 IS SELECT c0, c1 FROM t1; -- A member (PACKAGE BODY cursor)
      mv0 mc0%ROWTYPE;                     -- A member (PACKAGE BODY variable)
      PROCEDURE p1 AS
      BEGIN
        -- Accessing members from here use sp_rcontext_handler_package_body
        -- (members of the parent PACKAGE BODY)
        OPEN mc0;
        FETCH mc0 INTO mv0;
        CLOSE mc0;
      END;
    BEGIN
      -- NEW:
      -- Accessing members from here use sp_rcontext_handler_member
      -- (PACKAGE BODY own members)
      OPEN mc0;
      FETCH mc0 INTO mv0;
      CLOSE mc0;
    END;
    /

  Member variables and cursor are now marked with the "MEMBER." prefix
  in the "SHOW PACKAGE BODY code" output.
  Some old MTR tests have been re-recorded accordingly.

- Adding new virtual methods into Sp_rcontext_handler:

  virtual const sp_variable *get_pvariable(const sp_pcontext *pctx,
                                           uint offset) const;

  virtual const sp_pcursor *get_pcursor(const sp_pcontext *pctx,
                                        uint offset) const;

  They're used from sp_instr::print() virtual implementations.
  They internally calculate a proper sp_pcontext using as a parameter
  the sp_pcontext pointed by sp_instr::m_ctx.

  For example, Sp_handler_package_body::get_pvariable()/get_pcursor()
  accesses to this sp_pcontext:
      m_ctx->top_context()->m_sp->m_parent->get_parse_context(),
  i.e. the parse context of the PACKAGE BODY which is the parent for
   the current package PROCEDURE of FUNCTION an sp_instr belongs to.

- Adding a new method LEX::find_cursor(). It searches for a cursor in
  this order:
  1.  Local cursors in the nearst surrounding BEGIN/END block.
  2a. A member cursor of the current PACKAGE BODY
      (used from the PACKAGE BODY initialization section)
  OR
  2b. A member cursor of the parrent PACKAGE BODY
      (used from a package PROCEDURE or a package FUNCTION)

  Adding a new method LEX::find_cursor_with_error().
  In case when a cursor is not found, it automatically
  raises the ER_SP_CURSOR_MISMATCH SQL condition into
  the diagnostics area.

- Adding a new method sp_head::add_instr_copenX().
  It creates sp_instr_copen for local cursors,
  or sp_instr_copen2 for non-local cursors.

- Adding a new abstract class sp_lex_cursor_instr.
  It's used a common parent class for a few sp_instr_xxx classes,
  including the new sp_instr_copen2.
  This change is needed to avoid code duplication.

- Adding a new protected method sp_instr::print_cmd_and_var(), to print
  an instruction using this format: "command name@offset".
  It's used from a few implementations of sp_instr_xxx::print(),
  including sp_instr_copen2::print().
  This change is also needed to avoid code duplication.

- Adding a new method sp_pcontext::frame_for_members_candidate(),
  to distinguish easier between local cursors/variables and
  PACKAGE BODY cursors/variables.

- Fixing "struct Lex_for_loop_st" to addionally store
  a const pointer to Sp_rcontext_handler, to distinguish between:
    * FOR rec IN local_cursor
    * FOR rec IN package_body_cursor
2025-07-03 13:36:06 +04:00

1504 lines
52 KiB
Text
Raw Permalink Blame History

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 228
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;
Reference in a new issue View git blame Copy permalink