Debian Codegraph @

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

raw
1 UPDATE performance_schema.setup_instruments
2 SET ENABLED = 'NO'
3 WHERE NAME NOT LIKE 'memory/performance_schema/%'
4 AND NAME NOT LIKE 'stage/innodb/%'
5 AND NAME NOT LIKE 'statement/com/%'
6 AND NAME <> 'idle';
7 CALL sys.ps_setup_show_enabled_instruments();
8 enabled_instruments timed
9 idle YES
10 memory/performance_schema/accounts NULL
11 memory/performance_schema/cond_class NULL
12 memory/performance_schema/cond_instances NULL
13 memory/performance_schema/data_container NULL
14 memory/performance_schema/events_errors_summary_by_account_by_error NULL
15 memory/performance_schema/events_errors_summary_by_host_by_error NULL
16 memory/performance_schema/events_errors_summary_by_thread_by_error NULL
17 memory/performance_schema/events_errors_summary_by_user_by_error NULL
18 memory/performance_schema/events_errors_summary_global_by_error NULL
19 memory/performance_schema/events_stages_history NULL
20 memory/performance_schema/events_stages_history_long NULL
21 memory/performance_schema/events_stages_summary_by_account_by_event_name NULL
22 memory/performance_schema/events_stages_summary_by_host_by_event_name NULL
23 memory/performance_schema/events_stages_summary_by_thread_by_event_name NULL
24 memory/performance_schema/events_stages_summary_by_user_by_event_name NULL
25 memory/performance_schema/events_stages_summary_global_by_event_name NULL
26 memory/performance_schema/events_statements_current NULL
27 memory/performance_schema/events_statements_current.digest_text NULL
28 memory/performance_schema/events_statements_current.sql_text NULL
29 memory/performance_schema/events_statements_history NULL
30 memory/performance_schema/events_statements_history_long NULL
31 memory/performance_schema/events_statements_history_long.digest_text NULL
32 memory/performance_schema/events_statements_history_long.sql_text NULL
33 memory/performance_schema/events_statements_history.digest_text NULL
34 memory/performance_schema/events_statements_history.sql_text NULL
35 memory/performance_schema/events_statements_summary_by_account_by_event_name NULL
36 memory/performance_schema/events_statements_summary_by_digest NULL
37 memory/performance_schema/events_statements_summary_by_digest.digest_text NULL
38 memory/performance_schema/events_statements_summary_by_host_by_event_name NULL
39 memory/performance_schema/events_statements_summary_by_program NULL
40 memory/performance_schema/events_statements_summary_by_thread_by_event_name NULL
41 memory/performance_schema/events_statements_summary_by_user_by_event_name NULL
42 memory/performance_schema/events_statements_summary_global_by_event_name NULL
43 memory/performance_schema/events_transactions_history NULL
44 memory/performance_schema/events_transactions_history_long NULL
45 memory/performance_schema/events_transactions_summary_by_account_by_event_name NULL
46 memory/performance_schema/events_transactions_summary_by_host_by_event_name NULL
47 memory/performance_schema/events_transactions_summary_by_thread_by_event_name NULL
48 memory/performance_schema/events_transactions_summary_by_user_by_event_name NULL
49 memory/performance_schema/events_waits_history NULL
50 memory/performance_schema/events_waits_history_long NULL
51 memory/performance_schema/events_waits_summary_by_account_by_event_name NULL
52 memory/performance_schema/events_waits_summary_by_host_by_event_name NULL
53 memory/performance_schema/events_waits_summary_by_thread_by_event_name NULL
54 memory/performance_schema/events_waits_summary_by_user_by_event_name NULL
55 memory/performance_schema/file_class NULL
56 memory/performance_schema/file_handle NULL
57 memory/performance_schema/file_instances NULL
58 memory/performance_schema/hosts NULL
59 memory/performance_schema/memory_class NULL
60 memory/performance_schema/memory_summary_by_account_by_event_name NULL
61 memory/performance_schema/memory_summary_by_host_by_event_name NULL
62 memory/performance_schema/memory_summary_by_thread_by_event_name NULL
63 memory/performance_schema/memory_summary_by_user_by_event_name NULL
64 memory/performance_schema/memory_summary_global_by_event_name NULL
65 memory/performance_schema/metadata_locks NULL
66 memory/performance_schema/mutex_class NULL
67 memory/performance_schema/mutex_instances NULL
68 memory/performance_schema/prepared_statements_instances NULL
69 memory/performance_schema/rwlock_class NULL
70 memory/performance_schema/rwlock_instances NULL
71 memory/performance_schema/scalable_buffer NULL
72 memory/performance_schema/session_connect_attrs NULL
73 memory/performance_schema/setup_actors NULL
74 memory/performance_schema/setup_objects NULL
75 memory/performance_schema/socket_class NULL
76 memory/performance_schema/socket_instances NULL
77 memory/performance_schema/stage_class NULL
78 memory/performance_schema/statement_class NULL
79 memory/performance_schema/table_handles NULL
80 memory/performance_schema/table_io_waits_summary_by_index_usage NULL
81 memory/performance_schema/table_lock_waits_summary_by_table NULL
82 memory/performance_schema/table_shares NULL
83 memory/performance_schema/thread_class NULL
84 memory/performance_schema/threads NULL
85 memory/performance_schema/users NULL
86 stage/innodb/alter table (end) YES
87 stage/innodb/alter table (flush) YES
88 stage/innodb/alter table (insert) YES
89 stage/innodb/alter table (log apply index) YES
90 stage/innodb/alter table (log apply table) YES
91 stage/innodb/alter table (merge sort) YES
92 stage/innodb/alter table (read PK and internal sort) YES
93 stage/innodb/alter tablespace (encryption) YES
94 stage/innodb/buffer pool load YES
95 stage/innodb/clone (file copy) YES
96 stage/innodb/clone (page copy) YES
97 stage/innodb/clone (redo copy) YES
98 statement/com/Binlog Dump YES
99 statement/com/Binlog Dump GTID YES
100 statement/com/Change user YES
101 statement/com/Close stmt YES
102 statement/com/Connect YES
103 statement/com/Connect Out YES
104 statement/com/Create DB YES
105 statement/com/Daemon YES
106 statement/com/Debug YES
107 statement/com/Delayed insert YES
108 statement/com/Drop DB YES
109 statement/com/Error YES
110 statement/com/Execute YES
111 statement/com/Fetch YES
112 statement/com/Field List YES
113 statement/com/Group Replication Data Stream subscription YES
114 statement/com/Init DB YES
115 statement/com/Kill YES
116 statement/com/Long Data YES
117 statement/com/Ping YES
118 statement/com/Prepare YES
119 statement/com/Processlist YES
120 statement/com/Quit YES
121 statement/com/Refresh YES
122 statement/com/Register Replica YES
123 statement/com/Reset Connection YES
124 statement/com/Reset stmt YES
125 statement/com/Set option YES
126 statement/com/Shutdown YES
127 statement/com/Sleep YES
128 statement/com/Statistics YES
129 statement/com/Table Dump YES
130 statement/com/Time YES
131 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
132 TRUNCATE TABLE performance_schema.setup_actors;
133 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
134 UPDATE performance_schema.setup_consumers SET enabled = 'YES';
135 UPDATE performance_schema.threads SET instrumented = 'YES';