Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --replace_column 2 <frequency> 3 <resolution> 4 <overhead>
4 select * from performance_schema.performance_timers;
5
6 --replace_column 2 <frequency> 3 <resolution> 4 <overhead>
7 select * from performance_schema.performance_timers
8 where timer_name='CYCLE';
9
10 --error ER_TABLEACCESS_DENIED_ERROR
11 insert into performance_schema.performance_timers
12 set timer_name='FOO', timer_frequency=1,
13 timer_resolution=2, timer_overhead=3;
14
15 --error ER_TABLEACCESS_DENIED_ERROR
16 update performance_schema.performance_timers
17 set timer_frequency=12 where timer_name='CYCLE';
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 delete from performance_schema.performance_timers;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 delete from performance_schema.performance_timers
24 where timer_name='CYCLE';
25
26 -- error ER_TABLEACCESS_DENIED_ERROR
27 LOCK TABLES performance_schema.performance_timers READ;
28 UNLOCK TABLES;
29
30 -- error ER_TABLEACCESS_DENIED_ERROR
31 LOCK TABLES performance_schema.performance_timers WRITE;
32 UNLOCK TABLES;
33