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 'thread/innodb/trx\_%'
17 OR NAME LIKE '%con\_%'
18 OR NAME LIKE '%signal_handler%'
19 OR NAME LIKE '%thread_timer_notifier';
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_cpu
36 events_statements_current
37 events_statements_history
38 events_transactions_current
39 events_transactions_history
40 events_waits_current
41 events_waits_history
42 global_instrumentation
43 statements_digest
44 thread_instrumentation
45 CALL sys.ps_setup_show_enabled(TRUE, FALSE);
46 performance_schema_enabled
47 1
48 enabled_users
49 '%'@'%'
50 'foo'@'localhost'
51 object_type objects enabled timed
52 EVENT %.% YES YES
53 FUNCTION %.% YES YES
54 PROCEDURE %.% YES YES
55 TABLE %.% YES YES
56 TRIGGER %.% YES YES
57 enabled_consumers
58 events_stages_current
59 events_stages_history
60 events_statements_cpu
61 events_statements_current
62 events_statements_history
63 events_transactions_current
64 events_transactions_history
65 events_waits_current
66 events_waits_history
67 global_instrumentation
68 statements_digest
69 thread_instrumentation
70 enabled_instruments timed
71 idle YES
72 memory/performance_schema/accounts NULL
73 memory/performance_schema/cond_class NULL
74 memory/performance_schema/cond_instances NULL
75 memory/performance_schema/data_container NULL
76 memory/performance_schema/events_errors_summary_by_account_by_error NULL
77 memory/performance_schema/events_errors_summary_by_host_by_error NULL
78 memory/performance_schema/events_errors_summary_by_thread_by_error NULL
79 memory/performance_schema/events_errors_summary_by_user_by_error NULL
80 memory/performance_schema/events_errors_summary_global_by_error NULL
81 memory/performance_schema/events_stages_history NULL
82 memory/performance_schema/events_stages_history_long NULL
83 memory/performance_schema/events_stages_summary_by_account_by_event_name NULL
84 memory/performance_schema/events_stages_summary_by_host_by_event_name NULL
85 memory/performance_schema/events_stages_summary_by_thread_by_event_name NULL
86 memory/performance_schema/events_stages_summary_by_user_by_event_name NULL
87 memory/performance_schema/events_stages_summary_global_by_event_name NULL
88 memory/performance_schema/events_statements_current NULL
89 memory/performance_schema/events_statements_current.digest_text NULL
90 memory/performance_schema/events_statements_current.sql_text NULL
91 memory/performance_schema/events_statements_history NULL
92 memory/performance_schema/events_statements_history_long NULL
93 memory/performance_schema/events_statements_history_long.digest_text NULL
94 memory/performance_schema/events_statements_history_long.sql_text NULL
95 memory/performance_schema/events_statements_history.digest_text NULL
96 memory/performance_schema/events_statements_history.sql_text NULL
97 memory/performance_schema/events_statements_summary_by_account_by_event_name NULL
98 memory/performance_schema/events_statements_summary_by_digest NULL
99 memory/performance_schema/events_statements_summary_by_digest.digest_text NULL
100 memory/performance_schema/events_statements_summary_by_host_by_event_name NULL
101 memory/performance_schema/events_statements_summary_by_program NULL
102 memory/performance_schema/events_statements_summary_by_thread_by_event_name NULL
103 memory/performance_schema/events_statements_summary_by_user_by_event_name NULL
104 memory/performance_schema/events_statements_summary_global_by_event_name NULL
105 memory/performance_schema/events_transactions_history NULL
106 memory/performance_schema/events_transactions_history_long NULL
107 memory/performance_schema/events_transactions_summary_by_account_by_event_name NULL
108 memory/performance_schema/events_transactions_summary_by_host_by_event_name NULL
109 memory/performance_schema/events_transactions_summary_by_thread_by_event_name NULL
110 memory/performance_schema/events_transactions_summary_by_user_by_event_name NULL
111 memory/performance_schema/events_waits_history NULL
112 memory/performance_schema/events_waits_history_long NULL
113 memory/performance_schema/events_waits_summary_by_account_by_event_name NULL
114 memory/performance_schema/events_waits_summary_by_host_by_event_name NULL
115 memory/performance_schema/events_waits_summary_by_thread_by_event_name NULL
116 memory/performance_schema/events_waits_summary_by_user_by_event_name NULL
117 memory/performance_schema/file_class NULL
118 memory/performance_schema/file_handle NULL
119 memory/performance_schema/file_instances NULL
120 memory/performance_schema/hosts NULL
121 memory/performance_schema/memory_class NULL
122 memory/performance_schema/memory_summary_by_account_by_event_name NULL
123 memory/performance_schema/memory_summary_by_host_by_event_name NULL
124 memory/performance_schema/memory_summary_by_thread_by_event_name NULL
125 memory/performance_schema/memory_summary_by_user_by_event_name NULL
126 memory/performance_schema/memory_summary_global_by_event_name NULL
127 memory/performance_schema/metadata_locks NULL
128 memory/performance_schema/mutex_class NULL
129 memory/performance_schema/mutex_instances NULL
130 memory/performance_schema/prepared_statements_instances NULL
131 memory/performance_schema/rwlock_class NULL
132 memory/performance_schema/rwlock_instances NULL
133 memory/performance_schema/scalable_buffer NULL
134 memory/performance_schema/session_connect_attrs NULL
135 memory/performance_schema/setup_actors NULL
136 memory/performance_schema/setup_objects NULL
137 memory/performance_schema/socket_class NULL
138 memory/performance_schema/socket_instances NULL
139 memory/performance_schema/stage_class NULL
140 memory/performance_schema/statement_class NULL
141 memory/performance_schema/table_handles NULL
142 memory/performance_schema/table_io_waits_summary_by_index_usage NULL
143 memory/performance_schema/table_lock_waits_summary_by_table NULL
144 memory/performance_schema/table_shares NULL
145 memory/performance_schema/thread_class NULL
146 memory/performance_schema/threads NULL
147 memory/performance_schema/users NULL
148 stage/innodb/alter table (end) YES
149 stage/innodb/alter table (flush) YES
150 stage/innodb/alter table (insert) YES
151 stage/innodb/alter table (log apply index) YES
152 stage/innodb/alter table (log apply table) YES
153 stage/innodb/alter table (merge sort) YES
154 stage/innodb/alter table (read PK and internal sort) YES
155 stage/innodb/alter tablespace (encryption) YES
156 stage/innodb/buffer pool load YES
157 stage/innodb/clone (file copy) YES
158 stage/innodb/clone (page copy) YES
159 stage/innodb/clone (redo copy) YES
160 statement/com/Binlog Dump YES
161 statement/com/Binlog Dump GTID YES
162 statement/com/Change user YES
163 statement/com/Close stmt YES
164 statement/com/Connect YES
165 statement/com/Connect Out YES
166 statement/com/Create DB YES
167 statement/com/Daemon YES
168 statement/com/Debug YES
169 statement/com/Delayed insert YES
170 statement/com/Drop DB YES
171 statement/com/Error YES
172 statement/com/Execute YES
173 statement/com/Fetch YES
174 statement/com/Field List YES
175 statement/com/Group Replication Data Stream subscription YES
176 statement/com/Init DB YES
177 statement/com/Kill YES
178 statement/com/Long Data YES
179 statement/com/Ping YES
180 statement/com/Prepare YES
181 statement/com/Processlist YES
182 statement/com/Quit YES
183 statement/com/Refresh YES
184 statement/com/Register Replica YES
185 statement/com/Reset Connection YES
186 statement/com/Reset stmt YES
187 statement/com/Set option YES
188 statement/com/Shutdown YES
189 statement/com/Sleep YES
190 statement/com/Statistics YES
191 statement/com/Table Dump YES
192 statement/com/Time YES
193 CALL sys.ps_setup_show_enabled(FALSE, TRUE);
194 performance_schema_enabled
195 1
196 enabled_users
197 '%'@'%'
198 'foo'@'localhost'
199 object_type objects enabled timed
200 EVENT %.% YES YES
201 FUNCTION %.% YES YES
202 PROCEDURE %.% YES YES
203 TABLE %.% YES YES
204 TRIGGER %.% YES YES
205 enabled_consumers
206 events_stages_current
207 events_stages_history
208 events_statements_cpu
209 events_statements_current
210 events_statements_history
211 events_transactions_current
212 events_transactions_history
213 events_waits_current
214 events_waits_history
215 global_instrumentation
216 statements_digest
217 thread_instrumentation
218 enabled_threads thread_type
219 innodb/buf_dump_thread BACKGROUND
220 innodb/buf_resize_thread BACKGROUND
221 innodb/clone_gtid_thread BACKGROUND
222 innodb/dict_stats_thread BACKGROUND
223 innodb/fts_optimize_thread BACKGROUND
224 innodb/io_ibuf_thread BACKGROUND
225 innodb/io_read_thread BACKGROUND
226 innodb/io_read_thread BACKGROUND
227 innodb/io_read_thread BACKGROUND
228 innodb/io_read_thread BACKGROUND
229 innodb/io_write_thread BACKGROUND
230 innodb/io_write_thread BACKGROUND
231 innodb/io_write_thread BACKGROUND
232 innodb/io_write_thread BACKGROUND
233 innodb/log_checkpointer_thread BACKGROUND
234 innodb/log_files_governor_thread BACKGROUND
235 innodb/log_flush_notifier_thread BACKGROUND
236 innodb/log_flusher_thread BACKGROUND
237 innodb/log_write_notifier_thread BACKGROUND
238 innodb/log_writer_thread BACKGROUND
239 innodb/page_flush_coordinator_thread BACKGROUND
240 root@localhost FOREGROUND
241 sql/compress_gtid_table FOREGROUND
242 sql/event_scheduler FOREGROUND
243 sql/main BACKGROUND
244 CALL sys.ps_setup_show_enabled(TRUE, TRUE);
245 performance_schema_enabled
246 1
247 enabled_users
248 '%'@'%'
249 'foo'@'localhost'
250 object_type objects enabled timed
251 EVENT %.% YES YES
252 FUNCTION %.% YES YES
253 PROCEDURE %.% YES YES
254 TABLE %.% YES YES
255 TRIGGER %.% YES YES
256 enabled_consumers
257 events_stages_current
258 events_stages_history
259 events_statements_cpu
260 events_statements_current
261 events_statements_history
262 events_transactions_current
263 events_transactions_history
264 events_waits_current
265 events_waits_history
266 global_instrumentation
267 statements_digest
268 thread_instrumentation
269 enabled_threads thread_type
270 innodb/buf_dump_thread BACKGROUND
271 innodb/buf_resize_thread BACKGROUND
272 innodb/clone_gtid_thread BACKGROUND
273 innodb/dict_stats_thread BACKGROUND
274 innodb/fts_optimize_thread BACKGROUND
275 innodb/io_ibuf_thread BACKGROUND
276 innodb/io_read_thread BACKGROUND
277 innodb/io_read_thread BACKGROUND
278 innodb/io_read_thread BACKGROUND
279 innodb/io_read_thread BACKGROUND
280 innodb/io_write_thread BACKGROUND
281 innodb/io_write_thread BACKGROUND
282 innodb/io_write_thread BACKGROUND
283 innodb/io_write_thread BACKGROUND
284 innodb/log_checkpointer_thread BACKGROUND
285 innodb/log_files_governor_thread BACKGROUND
286 innodb/log_flush_notifier_thread BACKGROUND
287 innodb/log_flusher_thread BACKGROUND
288 innodb/log_write_notifier_thread BACKGROUND
289 innodb/log_writer_thread BACKGROUND
290 innodb/page_flush_coordinator_thread BACKGROUND
291 root@localhost FOREGROUND
292 sql/compress_gtid_table FOREGROUND
293 sql/event_scheduler FOREGROUND
294 sql/main BACKGROUND
295 enabled_instruments timed
296 idle YES
297 memory/performance_schema/accounts NULL
298 memory/performance_schema/cond_class NULL
299 memory/performance_schema/cond_instances NULL
300 memory/performance_schema/data_container NULL
301 memory/performance_schema/events_errors_summary_by_account_by_error NULL
302 memory/performance_schema/events_errors_summary_by_host_by_error NULL
303 memory/performance_schema/events_errors_summary_by_thread_by_error NULL
304 memory/performance_schema/events_errors_summary_by_user_by_error NULL
305 memory/performance_schema/events_errors_summary_global_by_error NULL
306 memory/performance_schema/events_stages_history NULL
307 memory/performance_schema/events_stages_history_long NULL
308 memory/performance_schema/events_stages_summary_by_account_by_event_name NULL
309 memory/performance_schema/events_stages_summary_by_host_by_event_name NULL
310 memory/performance_schema/events_stages_summary_by_thread_by_event_name NULL
311 memory/performance_schema/events_stages_summary_by_user_by_event_name NULL
312 memory/performance_schema/events_stages_summary_global_by_event_name NULL
313 memory/performance_schema/events_statements_current NULL
314 memory/performance_schema/events_statements_current.digest_text NULL
315 memory/performance_schema/events_statements_current.sql_text NULL
316 memory/performance_schema/events_statements_history NULL
317 memory/performance_schema/events_statements_history_long NULL
318 memory/performance_schema/events_statements_history_long.digest_text NULL
319 memory/performance_schema/events_statements_history_long.sql_text NULL
320 memory/performance_schema/events_statements_history.digest_text NULL
321 memory/performance_schema/events_statements_history.sql_text NULL
322 memory/performance_schema/events_statements_summary_by_account_by_event_name NULL
323 memory/performance_schema/events_statements_summary_by_digest NULL
324 memory/performance_schema/events_statements_summary_by_digest.digest_text NULL
325 memory/performance_schema/events_statements_summary_by_host_by_event_name NULL
326 memory/performance_schema/events_statements_summary_by_program NULL
327 memory/performance_schema/events_statements_summary_by_thread_by_event_name NULL
328 memory/performance_schema/events_statements_summary_by_user_by_event_name NULL
329 memory/performance_schema/events_statements_summary_global_by_event_name NULL
330 memory/performance_schema/events_transactions_history NULL
331 memory/performance_schema/events_transactions_history_long NULL
332 memory/performance_schema/events_transactions_summary_by_account_by_event_name NULL
333 memory/performance_schema/events_transactions_summary_by_host_by_event_name NULL
334 memory/performance_schema/events_transactions_summary_by_thread_by_event_name NULL
335 memory/performance_schema/events_transactions_summary_by_user_by_event_name NULL
336 memory/performance_schema/events_waits_history NULL
337 memory/performance_schema/events_waits_history_long NULL
338 memory/performance_schema/events_waits_summary_by_account_by_event_name NULL
339 memory/performance_schema/events_waits_summary_by_host_by_event_name NULL
340 memory/performance_schema/events_waits_summary_by_thread_by_event_name NULL
341 memory/performance_schema/events_waits_summary_by_user_by_event_name NULL
342 memory/performance_schema/file_class NULL
343 memory/performance_schema/file_handle NULL
344 memory/performance_schema/file_instances NULL
345 memory/performance_schema/hosts NULL
346 memory/performance_schema/memory_class NULL
347 memory/performance_schema/memory_summary_by_account_by_event_name NULL
348 memory/performance_schema/memory_summary_by_host_by_event_name NULL
349 memory/performance_schema/memory_summary_by_thread_by_event_name NULL
350 memory/performance_schema/memory_summary_by_user_by_event_name NULL
351 memory/performance_schema/memory_summary_global_by_event_name NULL
352 memory/performance_schema/metadata_locks NULL
353 memory/performance_schema/mutex_class NULL
354 memory/performance_schema/mutex_instances NULL
355 memory/performance_schema/prepared_statements_instances NULL
356 memory/performance_schema/rwlock_class NULL
357 memory/performance_schema/rwlock_instances NULL
358 memory/performance_schema/scalable_buffer NULL
359 memory/performance_schema/session_connect_attrs NULL
360 memory/performance_schema/setup_actors NULL
361 memory/performance_schema/setup_objects NULL
362 memory/performance_schema/socket_class NULL
363 memory/performance_schema/socket_instances NULL
364 memory/performance_schema/stage_class NULL
365 memory/performance_schema/statement_class NULL
366 memory/performance_schema/table_handles NULL
367 memory/performance_schema/table_io_waits_summary_by_index_usage NULL
368 memory/performance_schema/table_lock_waits_summary_by_table NULL
369 memory/performance_schema/table_shares NULL
370 memory/performance_schema/thread_class NULL
371 memory/performance_schema/threads NULL
372 memory/performance_schema/users NULL
373 stage/innodb/alter table (end) YES
374 stage/innodb/alter table (flush) YES
375 stage/innodb/alter table (insert) YES
376 stage/innodb/alter table (log apply index) YES
377 stage/innodb/alter table (log apply table) YES
378 stage/innodb/alter table (merge sort) YES
379 stage/innodb/alter table (read PK and internal sort) YES
380 stage/innodb/alter tablespace (encryption) YES
381 stage/innodb/buffer pool load YES
382 stage/innodb/clone (file copy) YES
383 stage/innodb/clone (page copy) YES
384 stage/innodb/clone (redo copy) YES
385 statement/com/Binlog Dump YES
386 statement/com/Binlog Dump GTID YES
387 statement/com/Change user YES
388 statement/com/Close stmt YES
389 statement/com/Connect YES
390 statement/com/Connect Out YES
391 statement/com/Create DB YES
392 statement/com/Daemon YES
393 statement/com/Debug YES
394 statement/com/Delayed insert YES
395 statement/com/Drop DB YES
396 statement/com/Error YES
397 statement/com/Execute YES
398 statement/com/Fetch YES
399 statement/com/Field List YES
400 statement/com/Group Replication Data Stream subscription YES
401 statement/com/Init DB YES
402 statement/com/Kill YES
403 statement/com/Long Data YES
404 statement/com/Ping YES
405 statement/com/Prepare YES
406 statement/com/Processlist YES
407 statement/com/Quit YES
408 statement/com/Refresh YES
409 statement/com/Register Replica YES
410 statement/com/Reset Connection YES
411 statement/com/Reset stmt YES
412 statement/com/Set option YES
413 statement/com/Shutdown YES
414 statement/com/Sleep YES
415 statement/com/Statistics YES
416 statement/com/Table Dump YES
417 statement/com/Time YES
418 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
419 TRUNCATE TABLE performance_schema.setup_actors;
420 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
421 UPDATE performance_schema.setup_consumers SET enabled = 'YES';
422 UPDATE performance_schema.threads SET instrumented = 'YES';