Debian Codegraph @

mysql-test/suite/sysschema/r/pr_ps_setup_show_enabled.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 NOT LIKE 'memory/performance_schema/%'
7 AND NAME NOT LIKE 'stage/innodb/%'
8 AND NAME NOT LIKE 'statement/com/%'
9 AND NAME <> 'idle';
10 UPDATE performance_schema.setup_consumers
11 SET ENABLED = 'NO'
12 WHERE NAME LIKE '%\_history\_long';
13 UPDATE performance_schema.threads
14 SET INSTRUMENTED = 'NO'
15 WHERE NAME LIKE 'thread/innodb/srv\_%'
16 OR NAME LIKE '%con\_%'
17 OR NAME LIKE '%signal_handler%'
18 OR NAME LIKE '%worker%'
19 OR (NAME='thread/sql/one_connection' AND PROCESSLIST_ID!=CONNECTION_ID());
20 CALL sys.ps_setup_show_enabled(FALSE, FALSE);
21 performance_schema_enabled
22 1
23 enabled_users
24 '%'@'%'
25 'foo'@'localhost'
26 object_type objects enabled timed
27 EVENT %.% YES YES
28 FUNCTION %.% YES YES
29 PROCEDURE %.% YES YES
30 TABLE %.% YES YES
31 TRIGGER %.% YES YES
32 enabled_consumers
33 events_stages_current
34 events_stages_history
35 events_statements_current
36 events_statements_history
37 events_transactions_current
38 events_transactions_history
39 events_waits_current
40 events_waits_history
41 global_instrumentation
42 statements_digest
43 thread_instrumentation
44 CALL sys.ps_setup_show_enabled(TRUE, FALSE);
45 performance_schema_enabled
46 1
47 enabled_users
48 '%'@'%'
49 'foo'@'localhost'
50 object_type objects enabled timed
51 EVENT %.% YES YES
52 FUNCTION %.% YES YES
53 PROCEDURE %.% YES YES
54 TABLE %.% YES YES
55 TRIGGER %.% YES YES
56 enabled_consumers
57 events_stages_current
58 events_stages_history
59 events_statements_current
60 events_statements_history
61 events_transactions_current
62 events_transactions_history
63 events_waits_current
64 events_waits_history
65 global_instrumentation
66 statements_digest
67 thread_instrumentation
68 enabled_instruments timed
69 idle YES
70 memory/performance_schema/accounts NO
71 memory/performance_schema/cond_class NO
72 memory/performance_schema/cond_instances NO
73 memory/performance_schema/events_stages_history NO
74 memory/performance_schema/events_stages_history_long NO
75 memory/performance_schema/events_stages_summary_by_account_by_event_name NO
76 memory/performance_schema/events_stages_summary_by_host_by_event_name NO
77 memory/performance_schema/events_stages_summary_by_thread_by_event_name NO
78 memory/performance_schema/events_stages_summary_by_user_by_event_name NO
79 memory/performance_schema/events_stages_summary_global_by_event_name NO
80 memory/performance_schema/events_statements_current NO
81 memory/performance_schema/events_statements_current.sqltext NO
82 memory/performance_schema/events_statements_current.tokens NO
83 memory/performance_schema/events_statements_history NO
84 memory/performance_schema/events_statements_history.sqltext NO
85 memory/performance_schema/events_statements_history.tokens NO
86 memory/performance_schema/events_statements_history_long NO
87 memory/performance_schema/events_statements_history_long.sqltext NO
88 memory/performance_schema/events_statements_history_long.tokens NO
89 memory/performance_schema/events_statements_summary_by_account_by_event_name NO
90 memory/performance_schema/events_statements_summary_by_digest NO
91 memory/performance_schema/events_statements_summary_by_digest.tokens NO
92 memory/performance_schema/events_statements_summary_by_host_by_event_name NO
93 memory/performance_schema/events_statements_summary_by_program NO
94 memory/performance_schema/events_statements_summary_by_thread_by_event_name NO
95 memory/performance_schema/events_statements_summary_by_user_by_event_name NO
96 memory/performance_schema/events_statements_summary_global_by_event_name NO
97 memory/performance_schema/events_transactions_history NO
98 memory/performance_schema/events_transactions_history_long NO
99 memory/performance_schema/events_transactions_summary_by_account_by_event_name NO
100 memory/performance_schema/events_transactions_summary_by_host_by_event_name NO
101 memory/performance_schema/events_transactions_summary_by_thread_by_event_name NO
102 memory/performance_schema/events_transactions_summary_by_user_by_event_name NO
103 memory/performance_schema/events_waits_history NO
104 memory/performance_schema/events_waits_history_long NO
105 memory/performance_schema/events_waits_summary_by_account_by_event_name NO
106 memory/performance_schema/events_waits_summary_by_host_by_event_name NO
107 memory/performance_schema/events_waits_summary_by_thread_by_event_name NO
108 memory/performance_schema/events_waits_summary_by_user_by_event_name NO
109 memory/performance_schema/file_class NO
110 memory/performance_schema/file_handle NO
111 memory/performance_schema/file_instances NO
112 memory/performance_schema/hosts NO
113 memory/performance_schema/memory_class NO
114 memory/performance_schema/memory_summary_by_account_by_event_name NO
115 memory/performance_schema/memory_summary_by_host_by_event_name NO
116 memory/performance_schema/memory_summary_by_thread_by_event_name NO
117 memory/performance_schema/memory_summary_by_user_by_event_name NO
118 memory/performance_schema/memory_summary_global_by_event_name NO
119 memory/performance_schema/metadata_locks NO
120 memory/performance_schema/mutex_class NO
121 memory/performance_schema/mutex_instances NO
122 memory/performance_schema/prepared_statements_instances NO
123 memory/performance_schema/rwlock_class NO
124 memory/performance_schema/rwlock_instances NO
125 memory/performance_schema/scalable_buffer NO
126 memory/performance_schema/session_connect_attrs NO
127 memory/performance_schema/setup_actors NO
128 memory/performance_schema/setup_objects NO
129 memory/performance_schema/socket_class NO
130 memory/performance_schema/socket_instances NO
131 memory/performance_schema/stage_class NO
132 memory/performance_schema/statement_class NO
133 memory/performance_schema/table_handles NO
134 memory/performance_schema/table_io_waits_summary_by_index_usage NO
135 memory/performance_schema/table_lock_waits_summary_by_table NO
136 memory/performance_schema/table_shares NO
137 memory/performance_schema/threads NO
138 memory/performance_schema/thread_class NO
139 memory/performance_schema/users NO
140 stage/innodb/alter table (end) YES
141 stage/innodb/alter table (insert) YES
142 stage/innodb/alter table (log apply index) YES
143 stage/innodb/alter table (log apply table) YES
144 stage/innodb/alter table (merge sort) YES
145 stage/innodb/alter table (read PK and internal sort) YES
146 stage/innodb/buffer pool load YES
147 statement/com/Binlog Dump YES
148 statement/com/Bulk_execute YES
149 statement/com/Change user YES
150 statement/com/Close stmt YES
151 statement/com/Connect YES
152 statement/com/Connect Out YES
153 statement/com/Create DB YES
154 statement/com/Daemon YES
155 statement/com/Debug YES
156 statement/com/Delayed insert YES
157 statement/com/Drop DB YES
158 statement/com/Error YES
159 statement/com/Execute YES
160 statement/com/Fetch YES
161 statement/com/Field List YES
162 statement/com/Init DB YES
163 statement/com/Kill YES
164 statement/com/Long Data YES
165 statement/com/Ping YES
166 statement/com/Prepare YES
167 statement/com/Processlist YES
168 statement/com/Quit YES
169 statement/com/Refresh YES
170 statement/com/Register Slave YES
171 statement/com/Reset connection YES
172 statement/com/Reset stmt YES
173 statement/com/Set option YES
174 statement/com/Shutdown YES
175 statement/com/Slave_IO YES
176 statement/com/Slave_SQL YES
177 statement/com/Slave_worker YES
178 statement/com/Sleep YES
179 statement/com/Statistics YES
180 statement/com/Table Dump YES
181 statement/com/Time YES
182 statement/com/Unimpl get tid YES
183 CALL sys.ps_setup_show_enabled(FALSE, TRUE);
184 performance_schema_enabled
185 1
186 enabled_users
187 '%'@'%'
188 'foo'@'localhost'
189 object_type objects enabled timed
190 EVENT %.% YES YES
191 FUNCTION %.% YES YES
192 PROCEDURE %.% YES YES
193 TABLE %.% YES YES
194 TRIGGER %.% YES YES
195 enabled_consumers
196 events_stages_current
197 events_stages_history
198 events_statements_current
199 events_statements_history
200 events_transactions_current
201 events_transactions_history
202 events_waits_current
203 events_waits_history
204 global_instrumentation
205 statements_digest
206 thread_instrumentation
207 enabled_threads thread_type
208 aria/checkpoint_bg BACKGROUND
209 innodb/page_cleaner BACKGROUND
210 mysys/statement_timer BACKGROUND
211 root@localhost FOREGROUND
212 sql/main BACKGROUND
213 sql/manager BACKGROUND
214 sql/slave_deadlock_handler BACKGROUND
215 CALL sys.ps_setup_show_enabled(TRUE, TRUE);
216 performance_schema_enabled
217 1
218 enabled_users
219 '%'@'%'
220 'foo'@'localhost'
221 object_type objects enabled timed
222 EVENT %.% YES YES
223 FUNCTION %.% YES YES
224 PROCEDURE %.% YES YES
225 TABLE %.% YES YES
226 TRIGGER %.% YES YES
227 enabled_consumers
228 events_stages_current
229 events_stages_history
230 events_statements_current
231 events_statements_history
232 events_transactions_current
233 events_transactions_history
234 events_waits_current
235 events_waits_history
236 global_instrumentation
237 statements_digest
238 thread_instrumentation
239 enabled_threads thread_type
240 aria/checkpoint_bg BACKGROUND
241 innodb/page_cleaner BACKGROUND
242 mysys/statement_timer BACKGROUND
243 root@localhost FOREGROUND
244 sql/main BACKGROUND
245 sql/manager BACKGROUND
246 sql/slave_deadlock_handler BACKGROUND
247 enabled_instruments timed
248 idle YES
249 memory/performance_schema/accounts NO
250 memory/performance_schema/cond_class NO
251 memory/performance_schema/cond_instances NO
252 memory/performance_schema/events_stages_history NO
253 memory/performance_schema/events_stages_history_long NO
254 memory/performance_schema/events_stages_summary_by_account_by_event_name NO
255 memory/performance_schema/events_stages_summary_by_host_by_event_name NO
256 memory/performance_schema/events_stages_summary_by_thread_by_event_name NO
257 memory/performance_schema/events_stages_summary_by_user_by_event_name NO
258 memory/performance_schema/events_stages_summary_global_by_event_name NO
259 memory/performance_schema/events_statements_current NO
260 memory/performance_schema/events_statements_current.sqltext NO
261 memory/performance_schema/events_statements_current.tokens NO
262 memory/performance_schema/events_statements_history NO
263 memory/performance_schema/events_statements_history.sqltext NO
264 memory/performance_schema/events_statements_history.tokens NO
265 memory/performance_schema/events_statements_history_long NO
266 memory/performance_schema/events_statements_history_long.sqltext NO
267 memory/performance_schema/events_statements_history_long.tokens NO
268 memory/performance_schema/events_statements_summary_by_account_by_event_name NO
269 memory/performance_schema/events_statements_summary_by_digest NO
270 memory/performance_schema/events_statements_summary_by_digest.tokens NO
271 memory/performance_schema/events_statements_summary_by_host_by_event_name NO
272 memory/performance_schema/events_statements_summary_by_program NO
273 memory/performance_schema/events_statements_summary_by_thread_by_event_name NO
274 memory/performance_schema/events_statements_summary_by_user_by_event_name NO
275 memory/performance_schema/events_statements_summary_global_by_event_name NO
276 memory/performance_schema/events_transactions_history NO
277 memory/performance_schema/events_transactions_history_long NO
278 memory/performance_schema/events_transactions_summary_by_account_by_event_name NO
279 memory/performance_schema/events_transactions_summary_by_host_by_event_name NO
280 memory/performance_schema/events_transactions_summary_by_thread_by_event_name NO
281 memory/performance_schema/events_transactions_summary_by_user_by_event_name NO
282 memory/performance_schema/events_waits_history NO
283 memory/performance_schema/events_waits_history_long NO
284 memory/performance_schema/events_waits_summary_by_account_by_event_name NO
285 memory/performance_schema/events_waits_summary_by_host_by_event_name NO
286 memory/performance_schema/events_waits_summary_by_thread_by_event_name NO
287 memory/performance_schema/events_waits_summary_by_user_by_event_name NO
288 memory/performance_schema/file_class NO
289 memory/performance_schema/file_handle NO
290 memory/performance_schema/file_instances NO
291 memory/performance_schema/hosts NO
292 memory/performance_schema/memory_class NO
293 memory/performance_schema/memory_summary_by_account_by_event_name NO
294 memory/performance_schema/memory_summary_by_host_by_event_name NO
295 memory/performance_schema/memory_summary_by_thread_by_event_name NO
296 memory/performance_schema/memory_summary_by_user_by_event_name NO
297 memory/performance_schema/memory_summary_global_by_event_name NO
298 memory/performance_schema/metadata_locks NO
299 memory/performance_schema/mutex_class NO
300 memory/performance_schema/mutex_instances NO
301 memory/performance_schema/prepared_statements_instances NO
302 memory/performance_schema/rwlock_class NO
303 memory/performance_schema/rwlock_instances NO
304 memory/performance_schema/scalable_buffer NO
305 memory/performance_schema/session_connect_attrs NO
306 memory/performance_schema/setup_actors NO
307 memory/performance_schema/setup_objects NO
308 memory/performance_schema/socket_class NO
309 memory/performance_schema/socket_instances NO
310 memory/performance_schema/stage_class NO
311 memory/performance_schema/statement_class NO
312 memory/performance_schema/table_handles NO
313 memory/performance_schema/table_io_waits_summary_by_index_usage NO
314 memory/performance_schema/table_lock_waits_summary_by_table NO
315 memory/performance_schema/table_shares NO
316 memory/performance_schema/threads NO
317 memory/performance_schema/thread_class NO
318 memory/performance_schema/users NO
319 stage/innodb/alter table (end) YES
320 stage/innodb/alter table (insert) YES
321 stage/innodb/alter table (log apply index) YES
322 stage/innodb/alter table (log apply table) YES
323 stage/innodb/alter table (merge sort) YES
324 stage/innodb/alter table (read PK and internal sort) YES
325 stage/innodb/buffer pool load YES
326 statement/com/Binlog Dump YES
327 statement/com/Bulk_execute YES
328 statement/com/Change user YES
329 statement/com/Close stmt YES
330 statement/com/Connect YES
331 statement/com/Connect Out YES
332 statement/com/Create DB YES
333 statement/com/Daemon YES
334 statement/com/Debug YES
335 statement/com/Delayed insert YES
336 statement/com/Drop DB YES
337 statement/com/Error YES
338 statement/com/Execute YES
339 statement/com/Fetch YES
340 statement/com/Field List YES
341 statement/com/Init DB YES
342 statement/com/Kill YES
343 statement/com/Long Data YES
344 statement/com/Ping YES
345 statement/com/Prepare YES
346 statement/com/Processlist YES
347 statement/com/Quit YES
348 statement/com/Refresh YES
349 statement/com/Register Slave YES
350 statement/com/Reset connection YES
351 statement/com/Reset stmt YES
352 statement/com/Set option YES
353 statement/com/Shutdown YES
354 statement/com/Slave_IO YES
355 statement/com/Slave_SQL YES
356 statement/com/Slave_worker YES
357 statement/com/Sleep YES
358 statement/com/Statistics YES
359 statement/com/Table Dump YES
360 statement/com/Time YES
361 statement/com/Unimpl get tid YES
362 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
363 TRUNCATE TABLE performance_schema.setup_actors;
364 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
365 UPDATE performance_schema.setup_consumers SET enabled = 'YES';
366 UPDATE performance_schema.threads SET instrumented = 'YES';