Debian Codegraph @

mysql-test/suite/sysschema/r/pr_ps_setup_show_disabled.result

raw
1 INSERT INTO performance_schema.setup_actors
2 VALUES ('localhost', 'foo', '%', 'YES', 'YES'),
3 ('localhost', 'bar', '%', 'NO', 'NO');
4 UPDATE performance_schema.setup_instruments
5 SET ENABLED = 'NO'
6 WHERE NAME LIKE 'stage/innodb/%'
7 OR NAME LIKE 'statement/com/%'
8 OR NAME = 'idle';
9 UPDATE performance_schema.setup_consumers
10 SET ENABLED = 'NO'
11 WHERE NAME LIKE '%\_history\_long';
12 UPDATE performance_schema.threads SET INSTRUMENTED = 'NO' WHERE NAME LIKE 'thread/innodb/srv\_%';
13 CALL sys.ps_setup_show_disabled(FALSE, FALSE);
14 performance_schema_enabled
15 1
16 disabled_users
17 'bar'@'localhost'
18 object_type objects enabled timed
19 EVENT information_schema.% NO NO
20 EVENT mysql.% NO NO
21 EVENT performance_schema.% NO NO
22 FUNCTION information_schema.% NO NO
23 FUNCTION mysql.% NO NO
24 FUNCTION performance_schema.% NO NO
25 PROCEDURE information_schema.% NO NO
26 PROCEDURE mysql.% NO NO
27 PROCEDURE performance_schema.% NO NO
28 TABLE information_schema.% NO NO
29 TABLE mysql.% NO NO
30 TABLE performance_schema.% NO NO
31 TRIGGER information_schema.% NO NO
32 TRIGGER mysql.% NO NO
33 TRIGGER performance_schema.% NO NO
34 disabled_consumers
35 events_stages_history_long
36 events_statements_history_long
37 events_transactions_history_long
38 events_waits_history_long
39 CALL sys.ps_setup_show_disabled(TRUE, FALSE);
40 performance_schema_enabled
41 1
42 disabled_users
43 'bar'@'localhost'
44 object_type objects enabled timed
45 EVENT information_schema.% NO NO
46 EVENT mysql.% NO NO
47 EVENT performance_schema.% NO NO
48 FUNCTION information_schema.% NO NO
49 FUNCTION mysql.% NO NO
50 FUNCTION performance_schema.% NO NO
51 PROCEDURE information_schema.% NO NO
52 PROCEDURE mysql.% NO NO
53 PROCEDURE performance_schema.% NO NO
54 TABLE information_schema.% NO NO
55 TABLE mysql.% NO NO
56 TABLE performance_schema.% NO NO
57 TRIGGER information_schema.% NO NO
58 TRIGGER mysql.% NO NO
59 TRIGGER performance_schema.% NO NO
60 disabled_consumers
61 events_stages_history_long
62 events_statements_history_long
63 events_transactions_history_long
64 events_waits_history_long
65 disabled_instruments timed
66 idle YES
67 stage/innodb/alter table (end) YES
68 stage/innodb/alter table (flush) YES
69 stage/innodb/alter table (insert) YES
70 stage/innodb/alter table (log apply index) YES
71 stage/innodb/alter table (log apply table) YES
72 stage/innodb/alter table (merge sort) YES
73 stage/innodb/alter table (read PK and internal sort) YES
74 stage/innodb/alter tablespace (encryption) YES
75 stage/innodb/buffer pool load YES
76 stage/innodb/clone (file copy) YES
77 stage/innodb/clone (page copy) YES
78 stage/innodb/clone (redo copy) YES
79 statement/com/Binlog Dump YES
80 statement/com/Binlog Dump GTID YES
81 statement/com/Change user YES
82 statement/com/Close stmt YES
83 statement/com/Connect YES
84 statement/com/Connect Out YES
85 statement/com/Create DB YES
86 statement/com/Daemon YES
87 statement/com/Debug YES
88 statement/com/Delayed insert YES
89 statement/com/Drop DB YES
90 statement/com/Error YES
91 statement/com/Execute YES
92 statement/com/Fetch YES
93 statement/com/Field List YES
94 statement/com/Group Replication Data Stream subscription YES
95 statement/com/Init DB YES
96 statement/com/Kill YES
97 statement/com/Long Data YES
98 statement/com/Ping YES
99 statement/com/Prepare YES
100 statement/com/Processlist YES
101 statement/com/Quit YES
102 statement/com/Refresh YES
103 statement/com/Register Replica YES
104 statement/com/Reset Connection YES
105 statement/com/Reset stmt YES
106 statement/com/Set option YES
107 statement/com/Shutdown YES
108 statement/com/Sleep YES
109 statement/com/Statistics YES
110 statement/com/Table Dump YES
111 statement/com/Time YES
112 CALL sys.ps_setup_show_disabled(FALSE, TRUE);
113 performance_schema_enabled
114 1
115 disabled_users
116 'bar'@'localhost'
117 object_type objects enabled timed
118 EVENT information_schema.% NO NO
119 EVENT mysql.% NO NO
120 EVENT performance_schema.% NO NO
121 FUNCTION information_schema.% NO NO
122 FUNCTION mysql.% NO NO
123 FUNCTION performance_schema.% NO NO
124 PROCEDURE information_schema.% NO NO
125 PROCEDURE mysql.% NO NO
126 PROCEDURE performance_schema.% NO NO
127 TABLE information_schema.% NO NO
128 TABLE mysql.% NO NO
129 TABLE performance_schema.% NO NO
130 TRIGGER information_schema.% NO NO
131 TRIGGER mysql.% NO NO
132 TRIGGER performance_schema.% NO NO
133 disabled_consumers
134 events_stages_history_long
135 events_statements_history_long
136 events_transactions_history_long
137 events_waits_history_long
138 disabled_threads thread_type
139 innodb/srv_error_monitor_thread BACKGROUND
140 innodb/srv_lock_timeout_thread BACKGROUND
141 innodb/srv_master_thread BACKGROUND
142 innodb/srv_monitor_thread BACKGROUND
143 innodb/srv_purge_thread BACKGROUND
144 innodb/srv_worker_thread BACKGROUND
145 innodb/srv_worker_thread BACKGROUND
146 innodb/srv_worker_thread BACKGROUND
147 CALL sys.ps_setup_show_disabled(TRUE, TRUE);
148 performance_schema_enabled
149 1
150 disabled_users
151 'bar'@'localhost'
152 object_type objects enabled timed
153 EVENT information_schema.% NO NO
154 EVENT mysql.% NO NO
155 EVENT performance_schema.% NO NO
156 FUNCTION information_schema.% NO NO
157 FUNCTION mysql.% NO NO
158 FUNCTION performance_schema.% NO NO
159 PROCEDURE information_schema.% NO NO
160 PROCEDURE mysql.% NO NO
161 PROCEDURE performance_schema.% NO NO
162 TABLE information_schema.% NO NO
163 TABLE mysql.% NO NO
164 TABLE performance_schema.% NO NO
165 TRIGGER information_schema.% NO NO
166 TRIGGER mysql.% NO NO
167 TRIGGER performance_schema.% NO NO
168 disabled_consumers
169 events_stages_history_long
170 events_statements_history_long
171 events_transactions_history_long
172 events_waits_history_long
173 disabled_threads thread_type
174 innodb/srv_error_monitor_thread BACKGROUND
175 innodb/srv_lock_timeout_thread BACKGROUND
176 innodb/srv_master_thread BACKGROUND
177 innodb/srv_monitor_thread BACKGROUND
178 innodb/srv_purge_thread BACKGROUND
179 innodb/srv_worker_thread BACKGROUND
180 innodb/srv_worker_thread BACKGROUND
181 innodb/srv_worker_thread BACKGROUND
182 disabled_instruments timed
183 idle YES
184 stage/innodb/alter table (end) YES
185 stage/innodb/alter table (flush) YES
186 stage/innodb/alter table (insert) YES
187 stage/innodb/alter table (log apply index) YES
188 stage/innodb/alter table (log apply table) YES
189 stage/innodb/alter table (merge sort) YES
190 stage/innodb/alter table (read PK and internal sort) YES
191 stage/innodb/alter tablespace (encryption) YES
192 stage/innodb/buffer pool load YES
193 stage/innodb/clone (file copy) YES
194 stage/innodb/clone (page copy) YES
195 stage/innodb/clone (redo copy) YES
196 statement/com/Binlog Dump YES
197 statement/com/Binlog Dump GTID YES
198 statement/com/Change user YES
199 statement/com/Close stmt YES
200 statement/com/Connect YES
201 statement/com/Connect Out YES
202 statement/com/Create DB YES
203 statement/com/Daemon YES
204 statement/com/Debug YES
205 statement/com/Delayed insert YES
206 statement/com/Drop DB YES
207 statement/com/Error YES
208 statement/com/Execute YES
209 statement/com/Fetch YES
210 statement/com/Field List YES
211 statement/com/Group Replication Data Stream subscription YES
212 statement/com/Init DB YES
213 statement/com/Kill YES
214 statement/com/Long Data YES
215 statement/com/Ping YES
216 statement/com/Prepare YES
217 statement/com/Processlist YES
218 statement/com/Quit YES
219 statement/com/Refresh YES
220 statement/com/Register Replica YES
221 statement/com/Reset Connection YES
222 statement/com/Reset stmt YES
223 statement/com/Set option YES
224 statement/com/Shutdown YES
225 statement/com/Sleep YES
226 statement/com/Statistics YES
227 statement/com/Table Dump YES
228 statement/com/Time YES
229 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
230 TRUNCATE TABLE performance_schema.setup_actors;
231 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
232 UPDATE performance_schema.setup_consumers SET enabled = 'YES';
233 UPDATE performance_schema.threads SET instrumented = 'YES';