Debian Codegraph @

mysql-test/suite/perfschema/t/dml_setup_timers.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5 --source include/have_timer_cycle.inc
6
7 # Set to a known state
8 update performance_schema.setup_timers
9 set timer_name='CYCLE' where name="wait";
10 update performance_schema.setup_timers
11 set timer_name='NANOSECOND' where name="stage";
12 update performance_schema.setup_timers
13 set timer_name='NANOSECOND' where name="statement";
14 update performance_schema.setup_timers
15 set timer_name='MICROSECOND' where name="transaction";
16 update performance_schema.setup_timers
17 set timer_name='MICROSECOND' where name="idle";
18
19 select * from performance_schema.setup_timers;
20
21 select * from performance_schema.setup_timers
22 where name='Wait';
23
24 select * from performance_schema.setup_timers
25 where timer_name='CYCLE';
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 insert into performance_schema.setup_timers
29 set name='FOO', timer_name='CYCLE';
30
31 --error ER_WRONG_PERFSCHEMA_USAGE
32 update performance_schema.setup_timers
33 set name='FOO';
34
35 update performance_schema.setup_timers
36 set timer_name='MILLISECOND';
37
38 select * from performance_schema.setup_timers;
39
40 update performance_schema.setup_timers
41 set timer_name='CYCLE';
42
43 --error ER_TABLEACCESS_DENIED_ERROR
44 delete from performance_schema.setup_timers;
45
46 --error ER_TABLEACCESS_DENIED_ERROR
47 delete from performance_schema.setup_timers
48 where name='Wait';
49
50 LOCK TABLES performance_schema.setup_timers READ;
51 UNLOCK TABLES;
52
53 LOCK TABLES performance_schema.setup_timers WRITE;
54 UNLOCK TABLES;
55
56 # Cleanup, restore the default values
57
58 update performance_schema.setup_timers
59 set timer_name='CYCLE' where name="wait";
60 update performance_schema.setup_timers
61 set timer_name='NANOSECOND' where name="stage";
62 update performance_schema.setup_timers
63 set timer_name='NANOSECOND' where name="statement";
64 update performance_schema.setup_timers
65 set timer_name='MICROSECOND' where name="transaction";
66 update performance_schema.setup_timers
67 set timer_name='MICROSECOND' where name="idle";
68
69 select * from performance_schema.setup_timers;
70
71 --echo #
72 --echo # MDEV-25325 column_comment for performance_schema tables
73 --echo #
74 select column_name, column_comment
75 from information_schema.columns
76 where table_schema='performance_schema' and table_name='setup_timers';