# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc --source include/not_embedded.inc --source suite/perfschema_stress/include/settings.inc let $have_table= `SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1'`; if (!$have_table) { --source suite/perfschema_stress/t/setup.test } UPDATE performance_schema.setup_instruments SET TIMED = 'NO'; UPDATE performance_schema.setup_instruments SET ENABLED = 'NO'; UPDATE performance_schema.setup_timers SET TIMER_NAME = 'NANOSECOND' WHERE NAME = 'Wait'; # Let it run some time with the new timer name and instruments --sleep 1 UPDATE performance_schema.setup_timers SET TIMER_NAME = 'CYCLE' WHERE NAME = 'Wait'; UPDATE performance_schema.setup_instruments SET TIMED = 'YES'; UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME IN ('wait/io/file/sql/FRM', 'thread/sql/Connection', 'wait/synch/cond/sql/COND_mdl', 'wait/synch/rwlock/sql/LOCK_sys_init_connect', 'wait/synch/mutex/sql/LOCK_mdl'); # Two short lived changes to see that switching does not lead # to havoc. UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME = 'events_waits_history'; UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME = 'events_waits_history';