# Tests for PERFORMANCE_SCHEMA

# Verify that the configuration options were applied correctly to the
# performance_schema.setup_instruments table. These instruments that are known to persist across
# platforms and the various compile options.

--echo #
--echo # Verify that the configuration file defaults were processed correctly
--echo #

SELECT * FROM performance_schema.setup_instruments
WHERE name IN (
  'wait/synch/mutex/sql/LOCK_user_conn',
  'wait/synch/mutex/sql/LOCK_uuid_generator',
  'wait/synch/mutex/sql/LOCK_transaction_cache',
  'stage/sql/creating table')
AND enabled = 'yes' AND timed = 'no'
ORDER BY name;

SELECT * FROM performance_schema.setup_instruments
WHERE name = 'wait/synch/mutex/sql/LOCK_thd_list'
AND enabled = 'no' AND timed = 'no';

SELECT * FROM performance_schema.setup_instruments
WHERE name IN (
  'wait/synch/mutex/sql/LOG_INFO::lock',
  'wait/synch/mutex/sql/THD::LOCK_thd_list')
AND enabled = 'yes' AND timed = 'yes'
ORDER BY name;

SELECT * FROM performance_schema.setup_instruments
WHERE name = 'wait/synch/mutex/sql/hash_filo::lock'
AND enabled = 'no' AND timed = 'no'
ORDER BY name;

--echo #
--echo # Verify that the memory instruments are never timed
--echo #
SELECT * FROM performance_schema.setup_instruments
WHERE name like 'memory/%'
AND timed = 'YES';

--echo #
--echo # Verify that the memory/performance_schema instruments are never disabled
--echo #
SELECT * FROM performance_schema.setup_instruments
WHERE name like 'memory/performance_schema/%'
AND enabled = 'NO';


--echo #
--echo # Verify that the instrument startup settings are not not visible.
--echo #
SHOW VARIABLES LIKE "%/wait/synch/mutex%";

--echo #
--echo # Verify command line options are processed correctly
--echo #

# The instrument wait/io/table/sql/handler should be enabled and timed.
--echo #
--echo # Verify that wait/io/table/sql/handler is enabled and timed
--echo #
SELECT * FROM performance_schema.setup_instruments
WHERE name like "%wait/io/table/sql/handler%";