# Tests for sys schema # Verify the sys.ps_is_instrument_default_enabled() function performs as expected # Should all be enabled SELECT sys.ps_is_instrument_default_enabled('memory/performance_schema/internal_buffers'); SELECT sys.ps_is_instrument_default_enabled('statement/sql/select'); SELECT sys.ps_is_instrument_default_enabled('statement/sp/error'); SELECT sys.ps_is_instrument_default_enabled('statement/com/Prepare'); SELECT sys.ps_is_instrument_default_enabled('stage/innodb/buffer pool load'); SELECT sys.ps_is_instrument_default_enabled('wait/io/file/sql/binlog'); SELECT sys.ps_is_instrument_default_enabled('wait/io/table/sql/handler'); SELECT sys.ps_is_instrument_default_enabled('wait/lock/table/sql/handler'); SELECT sys.ps_is_instrument_default_enabled('idle'); SELECT sys.ps_is_instrument_default_enabled('transaction'); SELECT sys.ps_is_instrument_default_enabled('wait/lock/metadata/sql/mdl'); # Should all be disabled SELECT sys.ps_is_instrument_default_enabled('wait/synch/mutex/sql/LOCK_plugin'); SELECT sys.ps_is_instrument_default_enabled('wait/synch/rwlock/sql/LOCK_grant'); SELECT sys.ps_is_instrument_default_enabled('wait/synch/prlock/sql/MDL_context::LOCK_waiting_for'); SELECT sys.ps_is_instrument_default_enabled('wait/synch/sxlock/innodb/btr_search_latch'); SELECT sys.ps_is_instrument_default_enabled('wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond'); SELECT sys.ps_is_instrument_default_enabled('stage/sql/Waiting for disk space'); SELECT sys.ps_is_instrument_default_enabled('wait/io/socket/sql/server_tcpip_socket');