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 object_type objects enabled timed
17 EVENT information_schema.% NO NO
18 EVENT mysql.% NO NO
19 EVENT performance_schema.% NO NO
20 FUNCTION information_schema.% NO NO
21 FUNCTION mysql.% NO NO
22 FUNCTION performance_schema.% NO NO
23 PROCEDURE information_schema.% NO NO
24 PROCEDURE mysql.% NO NO
25 PROCEDURE performance_schema.% NO NO
26 TABLE information_schema.% NO NO
27 TABLE mysql.% NO NO
28 TABLE performance_schema.% NO NO
29 TRIGGER information_schema.% NO NO
30 TRIGGER mysql.% NO NO
31 TRIGGER performance_schema.% NO NO
32 disabled_consumers
33 events_stages_history_long
34 events_statements_history_long
35 events_transactions_history_long
36 events_waits_history_long
37 CALL sys.ps_setup_show_disabled(TRUE, FALSE);
38 performance_schema_enabled
39 1
40 object_type objects enabled timed
41 EVENT information_schema.% NO NO
42 EVENT mysql.% NO NO
43 EVENT performance_schema.% NO NO
44 FUNCTION information_schema.% NO NO
45 FUNCTION mysql.% NO NO
46 FUNCTION performance_schema.% NO NO
47 PROCEDURE information_schema.% NO NO
48 PROCEDURE mysql.% NO NO
49 PROCEDURE performance_schema.% NO NO
50 TABLE information_schema.% NO NO
51 TABLE mysql.% NO NO
52 TABLE performance_schema.% NO NO
53 TRIGGER information_schema.% NO NO
54 TRIGGER mysql.% NO NO
55 TRIGGER performance_schema.% NO NO
56 disabled_consumers
57 events_stages_history_long
58 events_statements_history_long
59 events_transactions_history_long
60 events_waits_history_long
61 disabled_instruments timed
62 idle YES
63 stage/innodb/alter table (end) YES
64 stage/innodb/alter table (insert) YES
65 stage/innodb/alter table (log apply index) YES
66 stage/innodb/alter table (log apply table) YES
67 stage/innodb/alter table (merge sort) YES
68 stage/innodb/alter table (read PK and internal sort) YES
69 stage/innodb/buffer pool load YES
70 statement/com/Binlog Dump YES
71 statement/com/Bulk_execute YES
72 statement/com/Change user YES
73 statement/com/Close stmt YES
74 statement/com/Connect YES
75 statement/com/Connect Out YES
76 statement/com/Create DB YES
77 statement/com/Daemon YES
78 statement/com/Debug YES
79 statement/com/Delayed insert YES
80 statement/com/Drop DB YES
81 statement/com/Error YES
82 statement/com/Execute YES
83 statement/com/Fetch YES
84 statement/com/Field List YES
85 statement/com/Init DB YES
86 statement/com/Kill YES
87 statement/com/Long Data YES
88 statement/com/Ping YES
89 statement/com/Prepare YES
90 statement/com/Processlist YES
91 statement/com/Quit YES
92 statement/com/Refresh YES
93 statement/com/Register Slave YES
94 statement/com/Reset connection YES
95 statement/com/Reset stmt YES
96 statement/com/Set option YES
97 statement/com/Shutdown YES
98 statement/com/Slave_IO YES
99 statement/com/Slave_SQL YES
100 statement/com/Slave_worker YES
101 statement/com/Sleep YES
102 statement/com/Statistics YES
103 statement/com/Table Dump YES
104 statement/com/Time YES
105 statement/com/Unimpl get tid YES
106 CALL sys.ps_setup_show_disabled(FALSE, TRUE);
107 performance_schema_enabled
108 1
109 object_type objects enabled timed
110 EVENT information_schema.% NO NO
111 EVENT mysql.% NO NO
112 EVENT performance_schema.% NO NO
113 FUNCTION information_schema.% NO NO
114 FUNCTION mysql.% NO NO
115 FUNCTION performance_schema.% NO NO
116 PROCEDURE information_schema.% NO NO
117 PROCEDURE mysql.% NO NO
118 PROCEDURE performance_schema.% NO NO
119 TABLE information_schema.% NO NO
120 TABLE mysql.% NO NO
121 TABLE performance_schema.% NO NO
122 TRIGGER information_schema.% NO NO
123 TRIGGER mysql.% NO NO
124 TRIGGER performance_schema.% NO NO
125 disabled_consumers
126 events_stages_history_long
127 events_statements_history_long
128 events_transactions_history_long
129 events_waits_history_long
130 disabled_threads thread_type
131 CALL sys.ps_setup_show_disabled(TRUE, TRUE);
132 performance_schema_enabled
133 1
134 object_type objects enabled timed
135 EVENT information_schema.% NO NO
136 EVENT mysql.% NO NO
137 EVENT performance_schema.% NO NO
138 FUNCTION information_schema.% NO NO
139 FUNCTION mysql.% NO NO
140 FUNCTION performance_schema.% NO NO
141 PROCEDURE information_schema.% NO NO
142 PROCEDURE mysql.% NO NO
143 PROCEDURE performance_schema.% NO NO
144 TABLE information_schema.% NO NO
145 TABLE mysql.% NO NO
146 TABLE performance_schema.% NO NO
147 TRIGGER information_schema.% NO NO
148 TRIGGER mysql.% NO NO
149 TRIGGER performance_schema.% NO NO
150 disabled_consumers
151 events_stages_history_long
152 events_statements_history_long
153 events_transactions_history_long
154 events_waits_history_long
155 disabled_threads thread_type
156 disabled_instruments timed
157 idle YES
158 stage/innodb/alter table (end) YES
159 stage/innodb/alter table (insert) YES
160 stage/innodb/alter table (log apply index) YES
161 stage/innodb/alter table (log apply table) YES
162 stage/innodb/alter table (merge sort) YES
163 stage/innodb/alter table (read PK and internal sort) YES
164 stage/innodb/buffer pool load YES
165 statement/com/Binlog Dump YES
166 statement/com/Bulk_execute YES
167 statement/com/Change user YES
168 statement/com/Close stmt YES
169 statement/com/Connect YES
170 statement/com/Connect Out YES
171 statement/com/Create DB YES
172 statement/com/Daemon YES
173 statement/com/Debug YES
174 statement/com/Delayed insert YES
175 statement/com/Drop DB YES
176 statement/com/Error YES
177 statement/com/Execute YES
178 statement/com/Fetch YES
179 statement/com/Field List YES
180 statement/com/Init DB YES
181 statement/com/Kill YES
182 statement/com/Long Data YES
183 statement/com/Ping YES
184 statement/com/Prepare YES
185 statement/com/Processlist YES
186 statement/com/Quit YES
187 statement/com/Refresh YES
188 statement/com/Register Slave YES
189 statement/com/Reset connection YES
190 statement/com/Reset stmt YES
191 statement/com/Set option YES
192 statement/com/Shutdown YES
193 statement/com/Slave_IO YES
194 statement/com/Slave_SQL YES
195 statement/com/Slave_worker YES
196 statement/com/Sleep YES
197 statement/com/Statistics YES
198 statement/com/Table Dump YES
199 statement/com/Time YES
200 statement/com/Unimpl get tid YES
201 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
202 TRUNCATE TABLE performance_schema.setup_actors;
203 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
204 UPDATE performance_schema.setup_consumers SET enabled = 'YES';
205 UPDATE performance_schema.threads SET instrumented = 'YES';