Debian Codegraph @

mysql-test/suite/perfschema/r/dml_performance_timers.result

raw
1 select * from performance_schema.performance_timers;
2 TIMER_NAME TIMER_FREQUENCY TIMER_RESOLUTION TIMER_OVERHEAD
3 CYCLE <frequency> <resolution> <overhead>
4 NANOSECOND <frequency> <resolution> <overhead>
5 MICROSECOND <frequency> <resolution> <overhead>
6 MILLISECOND <frequency> <resolution> <overhead>
7 THREAD_CPU <frequency> <resolution> <overhead>
8 select * from performance_schema.performance_timers
9 where timer_name='CYCLE';
10 TIMER_NAME TIMER_FREQUENCY TIMER_RESOLUTION TIMER_OVERHEAD
11 CYCLE <frequency> <resolution> <overhead>
12 insert into performance_schema.performance_timers
13 set timer_name='FOO', timer_frequency=1,
14 timer_resolution=2, timer_overhead=3;
15 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'performance_timers'
16 update performance_schema.performance_timers
17 set timer_frequency=12 where timer_name='CYCLE';
18 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'performance_timers'
19 delete from performance_schema.performance_timers;
20 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'performance_timers'
21 delete from performance_schema.performance_timers
22 where timer_name='CYCLE';
23 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'performance_timers'
24 LOCK TABLES performance_schema.performance_timers READ;
25 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'performance_timers'
26 UNLOCK TABLES;
27 LOCK TABLES performance_schema.performance_timers WRITE;
28 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'performance_timers'
29 UNLOCK TABLES;