Debian Codegraph @

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

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