1update performance_schema.setup_timers 2set timer_name='CYCLE' where name="wait"; 3update performance_schema.setup_timers 4set timer_name='NANOSECOND' where name="stage"; 5update performance_schema.setup_timers 6set timer_name='NANOSECOND' where name="statement"; 7update performance_schema.setup_timers 8set timer_name='MICROSECOND' where name="idle"; 9select * from performance_schema.setup_timers; 10NAME TIMER_NAME 11idle MICROSECOND 12wait CYCLE 13stage NANOSECOND 14statement NANOSECOND 15select * from performance_schema.setup_timers 16where name='Wait'; 17NAME TIMER_NAME 18wait CYCLE 19select * from performance_schema.setup_timers 20where timer_name='CYCLE'; 21NAME TIMER_NAME 22wait CYCLE 23insert into performance_schema.setup_timers 24set name='FOO', timer_name='CYCLE'; 25ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_timers' 26update performance_schema.setup_timers 27set name='FOO'; 28ERROR HY000: Invalid performance_schema usage 29update performance_schema.setup_timers 30set timer_name='MILLISECOND'; 31select * from performance_schema.setup_timers; 32NAME TIMER_NAME 33idle MILLISECOND 34wait MILLISECOND 35stage MILLISECOND 36statement MILLISECOND 37update performance_schema.setup_timers 38set timer_name='CYCLE'; 39delete from performance_schema.setup_timers; 40ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_timers' 41delete from performance_schema.setup_timers 42where name='Wait'; 43ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_timers' 44LOCK TABLES performance_schema.setup_timers READ; 45UNLOCK TABLES; 46LOCK TABLES performance_schema.setup_timers WRITE; 47UNLOCK TABLES; 48update performance_schema.setup_timers 49set timer_name='CYCLE' where name="wait"; 50update performance_schema.setup_timers 51set timer_name='NANOSECOND' where name="stage"; 52update performance_schema.setup_timers 53set timer_name='NANOSECOND' where name="statement"; 54update performance_schema.setup_timers 55set timer_name='MICROSECOND' where name="idle"; 56select * from performance_schema.setup_timers; 57NAME TIMER_NAME 58idle MICROSECOND 59wait CYCLE 60stage NANOSECOND 61statement NANOSECOND 62# 63# MDEV-25325 column_comment for performance_schema tables 64# 65select column_name, column_comment 66from information_schema.columns 67where table_schema='performance_schema' and table_name='setup_timers'; 68column_name column_comment 69NAME Type of instrument the timer is used for. 70TIMER_NAME Timer applying to the instrument type. Can be modified. 71