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 | 102 |
1 files changed, 102 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 00000000..ed6d30ba --- /dev/null +++ b/mysql-test/suite/perfschema/r/dml_setup_timers.result @@ -0,0 +1,102 @@ +update performance_schema.setup_timers +set timer_name='CYCLE' where name="wait"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="stage"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="statement"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='MICROSECOND' where name="transaction"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='MICROSECOND' where name="idle"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +select * from performance_schema.setup_timers; +NAME TIMER_NAME +idle MICROSECOND +wait CYCLE +stage NANOSECOND +statement NANOSECOND +transaction MICROSECOND +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +select * from performance_schema.setup_timers +where name='Wait'; +NAME TIMER_NAME +wait CYCLE +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +select * from performance_schema.setup_timers +where timer_name='CYCLE'; +NAME TIMER_NAME +wait CYCLE +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +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'; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +select * from performance_schema.setup_timers; +NAME TIMER_NAME +idle MILLISECOND +wait MILLISECOND +stage MILLISECOND +statement MILLISECOND +transaction MILLISECOND +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='CYCLE'; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +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"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="stage"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='NANOSECOND' where name="statement"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='MICROSECOND' where name="transaction"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +update performance_schema.setup_timers +set timer_name='MICROSECOND' where name="idle"; +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release +select * from performance_schema.setup_timers; +NAME TIMER_NAME +idle MICROSECOND +wait CYCLE +stage NANOSECOND +statement NANOSECOND +transaction MICROSECOND +Warnings: +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release |