diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/dml_setup_timers.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/dml_setup_timers.result | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/dml_setup_timers.result b/mysql-test/suite/perfschema/r/dml_setup_timers.result new file mode 100644 index 00000000000..1667e58f7ed --- /dev/null +++ b/mysql-test/suite/perfschema/r/dml_setup_timers.result @@ -0,0 +1,61 @@ +update performance_schema.setup_timers +set timer_name='CYCLE' where name="wait"; +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="stage"; +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="statement"; +update performance_schema.setup_timers +set timer_name='MICROSECOND' where name="idle"; +select * from performance_schema.setup_timers; +NAME TIMER_NAME +idle MICROSECOND +wait CYCLE +stage NANOSECOND +statement NANOSECOND +select * from performance_schema.setup_timers +where name='Wait'; +NAME TIMER_NAME +wait CYCLE +select * from performance_schema.setup_timers +where timer_name='CYCLE'; +NAME TIMER_NAME +wait CYCLE +insert into performance_schema.setup_timers +set name='FOO', timer_name='CYCLE'; +ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_timers' +update performance_schema.setup_timers +set name='FOO'; +ERROR HY000: Invalid performance_schema usage. +update performance_schema.setup_timers +set timer_name='MILLISECOND'; +select * from performance_schema.setup_timers; +NAME TIMER_NAME +idle MILLISECOND +wait MILLISECOND +stage MILLISECOND +statement MILLISECOND +update performance_schema.setup_timers +set timer_name='CYCLE'; +delete from performance_schema.setup_timers; +ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_timers' +delete from performance_schema.setup_timers +where name='Wait'; +ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_timers' +LOCK TABLES performance_schema.setup_timers READ; +UNLOCK TABLES; +LOCK TABLES performance_schema.setup_timers WRITE; +UNLOCK TABLES; +update performance_schema.setup_timers +set timer_name='CYCLE' where name="wait"; +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="stage"; +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="statement"; +update performance_schema.setup_timers +set timer_name='MICROSECOND' where name="idle"; +select * from performance_schema.setup_timers; +NAME TIMER_NAME +idle MICROSECOND +wait CYCLE +stage NANOSECOND +statement NANOSECOND |