Debian Codegraph @

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

raw
1 # Tests for sys schema
2 # Verify the sys.ps_is_instrument_default_enabled() function performs as expected
3
4 # Should all be enabled
5 SELECT sys.ps_is_instrument_default_enabled('memory/performance_schema/internal_buffers');
6 SELECT sys.ps_is_instrument_default_enabled('statement/sql/select');
7 SELECT sys.ps_is_instrument_default_enabled('statement/sp/error');
8 SELECT sys.ps_is_instrument_default_enabled('statement/com/Prepare');
9 SELECT sys.ps_is_instrument_default_enabled('stage/innodb/buffer pool load');
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 SELECT sys.ps_is_instrument_default_enabled('transaction');
15 SELECT sys.ps_is_instrument_default_enabled('wait/lock/metadata/sql/mdl');
16
17 # Should all be disabled
18 SELECT sys.ps_is_instrument_default_enabled('wait/synch/mutex/sql/LOCK_plugin');
19 SELECT sys.ps_is_instrument_default_enabled('wait/synch/rwlock/sql/LOCK_grant');
20 SELECT sys.ps_is_instrument_default_enabled('wait/synch/prlock/sql/MDL_context::LOCK_waiting_for');
21 SELECT sys.ps_is_instrument_default_enabled('wait/synch/sxlock/innodb/btr_search_latch');
22 SELECT sys.ps_is_instrument_default_enabled('wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond');
23 SELECT sys.ps_is_instrument_default_enabled('stage/sql/Waiting for disk space');
24 SELECT sys.ps_is_instrument_default_enabled('wait/io/socket/sql/server_tcpip_socket');