Debian Codegraph @

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

raw
1 update performance_schema.setup_timers
2 set timer_name='CYCLE' where name="wait";
3 Warnings:
4 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
5 update performance_schema.setup_timers
6 set timer_name='NANOSECOND' where name="stage";
7 Warnings:
8 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
9 update performance_schema.setup_timers
10 set timer_name='NANOSECOND' where name="statement";
11 Warnings:
12 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
13 update performance_schema.setup_timers
14 set timer_name='MICROSECOND' where name="transaction";
15 Warnings:
16 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
17 update performance_schema.setup_timers
18 set timer_name='MICROSECOND' where name="idle";
19 Warnings:
20 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
21 select * from performance_schema.setup_timers;
22 NAME TIMER_NAME
23 idle MICROSECOND
24 wait CYCLE
25 stage NANOSECOND
26 statement NANOSECOND
27 transaction MICROSECOND
28 Warnings:
29 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
30 select * from performance_schema.setup_timers
31 where name='Wait';
32 NAME TIMER_NAME
33 wait CYCLE
34 Warnings:
35 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
36 select * from performance_schema.setup_timers
37 where timer_name='CYCLE';
38 NAME TIMER_NAME
39 wait CYCLE
40 Warnings:
41 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
42 insert into performance_schema.setup_timers
43 set name='FOO', timer_name='CYCLE';
44 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`setup_timers`
45 update performance_schema.setup_timers
46 set name='FOO';
47 ERROR HY000: Invalid performance_schema usage
48 update performance_schema.setup_timers
49 set timer_name='MILLISECOND';
50 Warnings:
51 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
52 select * from performance_schema.setup_timers;
53 NAME TIMER_NAME
54 idle MILLISECOND
55 wait MILLISECOND
56 stage MILLISECOND
57 statement MILLISECOND
58 transaction MILLISECOND
59 Warnings:
60 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
61 update performance_schema.setup_timers
62 set timer_name='CYCLE';
63 Warnings:
64 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
65 delete from performance_schema.setup_timers;
66 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`setup_timers`
67 delete from performance_schema.setup_timers
68 where name='Wait';
69 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`setup_timers`
70 LOCK TABLES performance_schema.setup_timers READ;
71 UNLOCK TABLES;
72 LOCK TABLES performance_schema.setup_timers WRITE;
73 UNLOCK TABLES;
74 update performance_schema.setup_timers
75 set timer_name='CYCLE' where name="wait";
76 Warnings:
77 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
78 update performance_schema.setup_timers
79 set timer_name='NANOSECOND' where name="stage";
80 Warnings:
81 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
82 update performance_schema.setup_timers
83 set timer_name='NANOSECOND' where name="statement";
84 Warnings:
85 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
86 update performance_schema.setup_timers
87 set timer_name='MICROSECOND' where name="transaction";
88 Warnings:
89 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
90 update performance_schema.setup_timers
91 set timer_name='MICROSECOND' where name="idle";
92 Warnings:
93 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
94 select * from performance_schema.setup_timers;
95 NAME TIMER_NAME
96 idle MICROSECOND
97 wait CYCLE
98 stage NANOSECOND
99 statement NANOSECOND
100 transaction MICROSECOND
101 Warnings:
102 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
103 #
104 # MDEV-25325 column_comment for performance_schema tables
105 #
106 select column_name, column_comment
107 from information_schema.columns
108 where table_schema='performance_schema' and table_name='setup_timers';
109 column_name column_comment
110 NAME Type of instrument the timer is used for.
111 TIMER_NAME Timer applying to the instrument type. Can be modified.