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