Debian Codegraph @

mysql-test/suite/sysschema/t/fn_ps_is_instrument_default_timed.test

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