Debian Codegraph @

mysql-test/suite/perfschema_stress/t/modify.test

raw
1 # The include statement below is a temp one for tests that are yet to
2 #be ported to run with InnoDB,
3 #but needs to be kept for tests that would need MyISAM in future.
4 --source include/force_myisam_default.inc
5
6 --source include/not_embedded.inc
7 --source suite/perfschema_stress/include/settings.inc
8
9 let $have_table= `SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES
10 WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1'`;
11
12 if (!$have_table) {
13 --source suite/perfschema_stress/t/setup.test
14 }
15
16 UPDATE performance_schema.setup_instruments SET TIMED = 'NO';
17
18 UPDATE performance_schema.setup_instruments SET ENABLED = 'NO';
19
20 UPDATE performance_schema.setup_timers
21 SET TIMER_NAME = 'NANOSECOND' WHERE NAME = 'Wait';
22
23 # Let it run some time with the new timer name and instruments
24 --sleep 1
25
26 UPDATE performance_schema.setup_timers
27 SET TIMER_NAME = 'CYCLE' WHERE NAME = 'Wait';
28
29 UPDATE performance_schema.setup_instruments SET TIMED = 'YES';
30
31 UPDATE performance_schema.setup_instruments SET ENABLED = 'YES'
32 WHERE NAME IN ('wait/io/file/sql/FRM',
33 'thread/sql/Connection',
34 'wait/synch/cond/sql/COND_mdl',
35 'wait/synch/rwlock/sql/LOCK_sys_init_connect',
36 'wait/synch/mutex/sql/LOCK_mdl');
37
38 # Two short lived changes to see that switching does not lead
39 # to havoc.
40
41 UPDATE performance_schema.setup_consumers SET ENABLED = 'NO'
42 WHERE NAME = 'events_waits_history';
43
44 UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'
45 WHERE NAME = 'events_waits_history';