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 TICK <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_schema`.`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_schema`.`performance_timers`
19 delete from performance_schema.performance_timers;
20 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`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_schema`.`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_schema`.`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_schema`.`performance_timers`
29 UNLOCK TABLES;
30 #
31 # MDEV-25325 column_comment for performance_schema tables
32 #
33 select column_name, column_comment
34 from information_schema.columns
35 where table_schema='performance_schema' and table_name='performance_timers';
36 column_name column_comment
37 TIMER_NAME Time name, used in the setup_timers table.
38 TIMER_FREQUENCY Number of timer units per second. Dependent on the processor speed.
39 TIMER_RESOLUTION Number of timer units by which timed values increase each time.
40 TIMER_OVERHEAD Minimum timer overhead, determined during initialization by calling the timer 20 times and selecting the smallest value. Total overhead will be at least double this, as the timer is called at the beginning and end of each timed event.