1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# Tests for sys schema
# Verify the sys.ps_is_instrument_default_timed() function performs as expected
# Should all be enabled
SELECT sys.ps_is_instrument_default_timed('wait/io/file/sql/binlog');
SELECT sys.ps_is_instrument_default_timed('statement/sql/select');
SELECT sys.ps_is_instrument_default_timed('statement/sp/error');
SELECT sys.ps_is_instrument_default_timed('statement/com/Prepare');
SELECT sys.ps_is_instrument_default_timed('wait/io/table/sql/handler');
SELECT sys.ps_is_instrument_default_timed('wait/lock/table/sql/handler');
SELECT sys.ps_is_instrument_default_timed('idle');
SELECT sys.ps_is_instrument_default_timed('stage/innodb/buffer pool load');
SELECT sys.ps_is_instrument_default_timed('transaction');
SELECT sys.ps_is_instrument_default_timed('wait/lock/metadata/sql/mdl');
SELECT sys.ps_is_instrument_default_timed('wait/io/socket/sql/server_tcpip_socket');
# Should all be disabled
SELECT sys.ps_is_instrument_default_timed('wait/synch/mutex/sql/LOCK_plugin');
SELECT sys.ps_is_instrument_default_timed('wait/synch/rwlock/sql/LOCK_grant');
SELECT sys.ps_is_instrument_default_timed('wait/synch/sxlock/innodb/btr_search_latch');
SELECT sys.ps_is_instrument_default_timed('wait/synch/prlock/sql/MDL_context::LOCK_waiting_for');
SELECT sys.ps_is_instrument_default_timed('wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond');
SELECT sys.ps_is_instrument_default_timed('stage/sql/end');
SELECT sys.ps_is_instrument_default_timed('memory/performance_schema/internal_buffers');
|
