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
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
|
show databases;
Database
information_schema
mtr
mysql
performance_schema
sys
test
select count(*) from performance_schema.performance_timers;
count(*)
5
select count(*) from performance_schema.setup_consumers;
count(*)
16
select count(*) > 4 from performance_schema.setup_instruments;
count(*) > 4
1
select * from performance_schema.accounts;
select * from performance_schema.cond_instances;
select * from performance_schema.events_stages_current;
select * from performance_schema.events_stages_history;
select * from performance_schema.events_stages_history_long;
select * from performance_schema.events_stages_summary_by_account_by_event_name;
select * from performance_schema.events_stages_summary_by_host_by_event_name;
select * from performance_schema.events_stages_summary_by_thread_by_event_name;
select * from performance_schema.events_stages_summary_by_user_by_event_name;
select * from performance_schema.events_stages_summary_global_by_event_name;
select * from performance_schema.events_statements_current;
select * from performance_schema.events_statements_histogram_by_digest;
select * from performance_schema.events_statements_histogram_global;
select * from performance_schema.events_statements_history;
select * from performance_schema.events_statements_history_long;
select * from performance_schema.events_statements_summary_by_account_by_event_name;
select * from performance_schema.events_statements_summary_by_digest;
select * from performance_schema.events_statements_summary_by_host_by_event_name;
select * from performance_schema.events_statements_summary_by_thread_by_event_name;
select * from performance_schema.events_statements_summary_by_user_by_event_name;
select * from performance_schema.events_statements_summary_global_by_event_name;
select * from performance_schema.events_transactions_current;
select * from performance_schema.events_transactions_history;
select * from performance_schema.events_transactions_history_long;
select * from performance_schema.events_transactions_summary_by_account_by_event_name;
select * from performance_schema.events_transactions_summary_by_host_by_event_name;
select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
select * from performance_schema.events_transactions_summary_by_user_by_event_name;
select * from performance_schema.events_transactions_summary_global_by_event_name;
select * from performance_schema.events_waits_current;
select * from performance_schema.events_waits_history;
select * from performance_schema.events_waits_history_long;
select * from performance_schema.events_waits_summary_by_account_by_event_name;
select * from performance_schema.events_waits_summary_by_host_by_event_name;
select * from performance_schema.events_waits_summary_by_instance;
select * from performance_schema.events_waits_summary_by_thread_by_event_name;
select * from performance_schema.events_waits_summary_by_user_by_event_name;
select * from performance_schema.events_waits_summary_global_by_event_name;
select * from performance_schema.memory_summary_by_account_by_event_name;
select * from performance_schema.memory_summary_by_host_by_event_name;
select * from performance_schema.memory_summary_by_thread_by_event_name;
select * from performance_schema.memory_summary_by_user_by_event_name;
select * from performance_schema.memory_summary_global_by_event_name;
select * from performance_schema.events_errors_summary_by_account_by_error;
select * from performance_schema.events_errors_summary_by_host_by_error;
select * from performance_schema.events_errors_summary_by_thread_by_error;
select * from performance_schema.events_errors_summary_by_user_by_error;
select * from performance_schema.events_errors_summary_global_by_error;
select * from performance_schema.file_instances;
select * from performance_schema.file_summary_by_event_name;
select * from performance_schema.file_summary_by_instance;
select * from performance_schema.host_cache;
select * from performance_schema.hosts;
select * from performance_schema.memory_summary_by_account_by_event_name;
select * from performance_schema.memory_summary_by_host_by_event_name;
select * from performance_schema.memory_summary_by_thread_by_event_name;
select * from performance_schema.memory_summary_by_user_by_event_name;
select * from performance_schema.memory_summary_global_by_event_name;
select * from performance_schema.metadata_locks;
select * from performance_schema.mutex_instances;
select * from performance_schema.objects_summary_global_by_type;
select * from performance_schema.performance_timers;
select * from performance_schema.rwlock_instances;
select * from performance_schema.data_locks;
select * from performance_schema.data_lock_waits;
select * from performance_schema.session_account_connect_attrs;
select * from performance_schema.session_connect_attrs;
select * from performance_schema.setup_actors;
select * from performance_schema.setup_consumers;
select * from performance_schema.setup_instruments;
select * from performance_schema.setup_objects;
select * from performance_schema.setup_threads;
select * from performance_schema.socket_instances;
select * from performance_schema.socket_summary_by_instance;
select * from performance_schema.socket_summary_by_event_name;
select * from performance_schema.table_handles;
select * from performance_schema.table_io_waits_summary_by_index_usage;
select * from performance_schema.table_io_waits_summary_by_table;
select * from performance_schema.table_lock_waits_summary_by_table;
select * from performance_schema.threads;
select * from performance_schema.users;
select * from performance_schema.replication_connection_configuration;
select * from performance_schema.replication_connection_status;
select * from performance_schema.replication_applier_configuration;
select * from performance_schema.replication_applier_status;
select * from performance_schema.replication_applier_status_by_coordinator;
select * from performance_schema.replication_applier_status_by_worker;
select * from performance_schema.global_status;
select * from performance_schema.status_by_thread;
select * from performance_schema.status_by_user;
select * from performance_schema.status_by_host;
select * from performance_schema.status_by_account;
select * from performance_schema.session_status;
select * from performance_schema.global_variables;
select * from performance_schema.variables_by_thread;
select * from performance_schema.session_variables;
show engine PERFORMANCE_SCHEMA status;
show global status like "performance_schema%";
show global variables like "performance_schema%";
Variable_name Value
performance_schema ON
performance_schema_accounts_size 0
performance_schema_digests_size 0
performance_schema_error_size 0
performance_schema_events_stages_history_long_size 0
performance_schema_events_stages_history_size 0
performance_schema_events_statements_history_long_size 0
performance_schema_events_statements_history_size 0
performance_schema_events_transactions_history_long_size 1000
performance_schema_events_transactions_history_size 10
performance_schema_events_waits_history_long_size 0
performance_schema_events_waits_history_size 0
performance_schema_hosts_size 0
performance_schema_max_cond_classes 0
performance_schema_max_cond_instances 0
performance_schema_max_digest_length 1024
performance_schema_max_digest_sample_age 60
performance_schema_max_file_classes 0
performance_schema_max_file_handles 0
performance_schema_max_file_instances 0
performance_schema_max_index_stat 0
performance_schema_max_memory_classes 0
performance_schema_max_metadata_locks 0
performance_schema_max_mutex_classes 0
performance_schema_max_mutex_instances 0
performance_schema_max_prepared_statements_instances -1
performance_schema_max_program_instances 0
performance_schema_max_rwlock_classes 0
performance_schema_max_rwlock_instances 0
performance_schema_max_socket_classes 0
performance_schema_max_socket_instances 0
performance_schema_max_sql_text_length 1024
performance_schema_max_stage_classes 0
performance_schema_max_statement_classes 0
performance_schema_max_statement_stack 1
performance_schema_max_table_handles 0
performance_schema_max_table_instances 0
performance_schema_max_table_lock_stat 0
performance_schema_max_thread_classes 0
performance_schema_max_thread_instances 0
performance_schema_session_connect_attrs_size 0
performance_schema_setup_actors_size 0
performance_schema_setup_objects_size 0
performance_schema_show_processlist OFF
performance_schema_users_size 0
select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
from performance_schema.setup_instruments
order by name;
NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
error YES NULL 0 NULL
idle YES YES user 0 NULL
memory/performance_schema/accounts YES NULL global_statistics 1 Memory used for table performance_schema.accounts
memory/performance_schema/cond_class YES NULL global_statistics 1 Memory used for cond instrument classes
memory/performance_schema/cond_instances YES NULL global_statistics 1 Memory used for table performance_schema.cond_instances
memory/performance_schema/data_container YES NULL global_statistics 8 Memory used during queries on tables performance_schema.data_locks or performance_schema.data_lock_waits
memory/performance_schema/events_errors_summary_by_account_by_error YES NULL global_statistics 1 Memory used for table performance_schema.events_errors_summary_by_account_by_error
memory/performance_schema/events_errors_summary_by_host_by_error YES NULL global_statistics 1 Memory used for table performance_schema.events_errors_summary_by_host_by_error
memory/performance_schema/events_errors_summary_by_thread_by_error YES NULL global_statistics 1 Memory used for table performance_schema.events_errors_summary_by_thread_by_error
memory/performance_schema/events_errors_summary_by_user_by_error YES NULL global_statistics 1 Memory used for table performance_schema.events_errors_summary_by_user_by_error
memory/performance_schema/events_errors_summary_global_by_error YES NULL global_statistics 1 Memory used for table performance_schema.events_errors_summary_global_by_error
memory/performance_schema/events_stages_history YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_history
memory/performance_schema/events_stages_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_history_long
memory/performance_schema/events_stages_summary_by_account_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_summary_by_account_by_event_name
memory/performance_schema/events_stages_summary_by_host_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_summary_by_host_by_event_name
memory/performance_schema/events_stages_summary_by_thread_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_summary_by_thread_by_event_name
memory/performance_schema/events_stages_summary_by_user_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_summary_by_user_by_event_name
memory/performance_schema/events_stages_summary_global_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_summary_global_by_event_name
memory/performance_schema/events_statements_current YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_current
memory/performance_schema/events_statements_current.digest_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_current, column digest_text
memory/performance_schema/events_statements_current.sql_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_current, column sql_text
memory/performance_schema/events_statements_history YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history
memory/performance_schema/events_statements_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history_long
memory/performance_schema/events_statements_history_long.digest_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history_long, column digest_text
memory/performance_schema/events_statements_history_long.sql_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history_long, column sql_text
memory/performance_schema/events_statements_history.digest_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history, column digest_text
memory/performance_schema/events_statements_history.sql_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history, column sql_text
memory/performance_schema/events_statements_summary_by_account_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_account_by_event_name
memory/performance_schema/events_statements_summary_by_digest YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_digest
memory/performance_schema/events_statements_summary_by_digest.digest_text YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_digest, column digest_text
memory/performance_schema/events_statements_summary_by_host_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_host_by_event_name
memory/performance_schema/events_statements_summary_by_program YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_program
memory/performance_schema/events_statements_summary_by_thread_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_thread_by_event_name
memory/performance_schema/events_statements_summary_by_user_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_user_by_event_name
memory/performance_schema/events_statements_summary_global_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_global_by_event_name
memory/performance_schema/events_transactions_history YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_history
memory/performance_schema/events_transactions_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_history_long
memory/performance_schema/events_transactions_summary_by_account_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_summary_by_account_by_event_name
memory/performance_schema/events_transactions_summary_by_host_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_summary_by_host_by_event_name
memory/performance_schema/events_transactions_summary_by_thread_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_summary_by_thread_by_event_name
memory/performance_schema/events_transactions_summary_by_user_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_summary_by_user_by_event_name
memory/performance_schema/events_waits_history YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_history
memory/performance_schema/events_waits_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_history_long
memory/performance_schema/events_waits_summary_by_account_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_summary_by_account_by_event_name
memory/performance_schema/events_waits_summary_by_host_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_summary_by_host_by_event_name
memory/performance_schema/events_waits_summary_by_thread_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_summary_by_thread_by_event_name
memory/performance_schema/events_waits_summary_by_user_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_summary_by_user_by_event_name
memory/performance_schema/file_class YES NULL global_statistics 1 Memory used for file instrument classes
memory/performance_schema/file_handle YES NULL global_statistics 1 Memory used for table performance_schema.file_handle
memory/performance_schema/file_instances YES NULL global_statistics 1 Memory used for table performance_schema.file_instances
memory/performance_schema/hosts YES NULL global_statistics 1 Memory used for table performance_schema.hosts
memory/performance_schema/memory_class YES NULL global_statistics 1 Memory used for memory instrument classes
memory/performance_schema/memory_summary_by_account_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.memory_summary_by_account_by_event_name
memory/performance_schema/memory_summary_by_host_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.memory_summary_by_host_by_event_name
memory/performance_schema/memory_summary_by_thread_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.memory_summary_by_thread_by_event_name
memory/performance_schema/memory_summary_by_user_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.memory_summary_by_user_by_event_name
memory/performance_schema/memory_summary_global_by_event_name YES NULL global_statistics 1 Memory used for table performance_schema.memory_summary_global_by_event_name
memory/performance_schema/metadata_locks YES NULL global_statistics 1 Memory used for table performance_schema.metadata_locks
memory/performance_schema/mutex_class YES NULL global_statistics 1 Memory used for mutex instrument classes
memory/performance_schema/mutex_instances YES NULL global_statistics 1 Memory used for table performance_schema.mutex_instances
memory/performance_schema/prepared_statements_instances YES NULL global_statistics 1 Memory used for table performance_schema.prepared_statements_instances
memory/performance_schema/rwlock_class YES NULL global_statistics 1 Memory used for rwlock instrument classes
memory/performance_schema/rwlock_instances YES NULL global_statistics 1 Memory used for table performance_schema.rwlock_instances
memory/performance_schema/scalable_buffer YES NULL global_statistics 1 Memory used for scalable buffers
memory/performance_schema/session_connect_attrs YES NULL global_statistics 1 Memory used for table performance_schema.session_connect_attrs
memory/performance_schema/setup_actors YES NULL global_statistics 1 Memory used for table performance_schema.setup_actors
memory/performance_schema/setup_objects YES NULL global_statistics 1 Memory used for table performance_schema.setup_objects
memory/performance_schema/socket_class YES NULL global_statistics 1 Memory used for socket instrument classes
memory/performance_schema/socket_instances YES NULL global_statistics 1 Memory used for table performance_schema.socket_instances
memory/performance_schema/stage_class YES NULL global_statistics 1 Memory used for stage instrument classes
memory/performance_schema/statement_class YES NULL global_statistics 1 Memory used for statement instrument classes
memory/performance_schema/table_handles YES NULL global_statistics 1 Memory used for table performance_schema.table_handles
memory/performance_schema/table_io_waits_summary_by_index_usage YES NULL global_statistics 1 Memory used for table performance_schema.table_io_waits_summary_by_index_usage
memory/performance_schema/table_lock_waits_summary_by_table YES NULL global_statistics 1 Memory used for table performance_schema.table_lock_waits_summary_by_table
memory/performance_schema/table_shares YES NULL global_statistics 1 Memory used for table performance_schema.table_shares
memory/performance_schema/thread_class YES NULL global_statistics 1 Memory used for thread instrument classes
memory/performance_schema/threads YES NULL global_statistics 1 Memory used for table performance_schema.threads
memory/performance_schema/users YES NULL global_statistics 1 Memory used for table performance_schema.users
transaction YES YES 0 NULL
wait/io/table/sql/handler YES YES 0 NULL
wait/lock/metadata/sql/mdl YES YES 0 NULL
wait/lock/table/sql/handler YES YES 0 NULL
select TIMER_NAME from performance_schema.performance_timers;
TIMER_NAME
CYCLE
NANOSECOND
MICROSECOND
MILLISECOND
THREAD_CPU
select * from performance_schema.setup_consumers;
NAME ENABLED
events_stages_current YES
events_stages_history YES
events_stages_history_long YES
events_statements_cpu YES
events_statements_current YES
events_statements_history YES
events_statements_history_long YES
events_transactions_current YES
events_transactions_history YES
events_transactions_history_long YES
events_waits_current YES
events_waits_history YES
events_waits_history_long YES
global_instrumentation YES
thread_instrumentation YES
statements_digest YES
select * from performance_schema.accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS MAX_SESSION_CONTROLLED_MEMORY MAX_SESSION_TOTAL_MEMORY
select * from performance_schema.cond_instances;
NAME OBJECT_INSTANCE_BEGIN
select * from performance_schema.events_stages_current;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT WORK_COMPLETED WORK_ESTIMATED NESTING_EVENT_ID NESTING_EVENT_TYPE
select * from performance_schema.events_stages_history;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT WORK_COMPLETED WORK_ESTIMATED NESTING_EVENT_ID NESTING_EVENT_TYPE
select * from performance_schema.events_stages_history_long;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT WORK_COMPLETED WORK_ESTIMATED NESTING_EVENT_ID NESTING_EVENT_TYPE
select * from performance_schema.events_stages_summary_by_account_by_event_name;
USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_stages_summary_by_host_by_event_name;
HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_stages_summary_by_thread_by_event_name;
THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_stages_summary_by_user_by_event_name;
USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_stages_summary_global_by_event_name;
EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_statements_current;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL STATEMENT_ID CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY EXECUTION_ENGINE
select * from performance_schema.events_statements_history;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL STATEMENT_ID CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY EXECUTION_ENGINE
select * from performance_schema.events_statements_history_long;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL STATEMENT_ID CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY EXECUTION_ENGINE
select * from performance_schema.events_statements_summary_by_account_by_event_name;
USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED SUM_CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY COUNT_SECONDARY
select * from performance_schema.events_statements_summary_by_host_by_event_name;
HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED SUM_CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY COUNT_SECONDARY
select * from performance_schema.events_statements_summary_by_thread_by_event_name;
THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED SUM_CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY COUNT_SECONDARY
select * from performance_schema.events_statements_summary_by_user_by_event_name;
USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED SUM_CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY COUNT_SECONDARY
select * from performance_schema.events_statements_summary_global_by_event_name;
EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED SUM_CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY COUNT_SECONDARY
select * from performance_schema.events_waits_current;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
select * from performance_schema.events_waits_history;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
select * from performance_schema.events_waits_history_long;
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
select * from performance_schema.events_waits_summary_by_account_by_event_name;
USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_waits_summary_by_host_by_event_name;
HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_waits_summary_by_instance;
EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_waits_summary_by_thread_by_event_name;
THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_waits_summary_by_user_by_event_name;
USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.events_waits_summary_global_by_event_name;
EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
wait/io/table/sql/handler 0 0 0 0 0
wait/lock/table/sql/handler 0 0 0 0 0
idle 0 0 0 0 0
wait/lock/metadata/sql/mdl 0 0 0 0 0
select * from performance_schema.file_instances;
FILE_NAME EVENT_NAME OPEN_COUNT
select * from performance_schema.file_summary_by_event_name;
EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
select * from performance_schema.file_summary_by_instance;
FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
select * from performance_schema.hosts;
HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS MAX_SESSION_CONTROLLED_MEMORY MAX_SESSION_TOTAL_MEMORY
select * from performance_schema.metadata_locks;
OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COLUMN_NAME OBJECT_INSTANCE_BEGIN LOCK_TYPE LOCK_DURATION LOCK_STATUS SOURCE OWNER_THREAD_ID OWNER_EVENT_ID
select * from performance_schema.mutex_instances;
NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
select * from performance_schema.objects_summary_global_by_type;
OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
select * from performance_schema.rwlock_instances;
NAME OBJECT_INSTANCE_BEGIN WRITE_LOCKED_BY_THREAD_ID READ_LOCKED_BY_COUNT
select * from performance_schema.session_account_connect_attrs;
PROCESSLIST_ID ATTR_NAME ATTR_VALUE ORDINAL_POSITION
select * from performance_schema.session_connect_attrs;
PROCESSLIST_ID ATTR_NAME ATTR_VALUE ORDINAL_POSITION
select * from performance_schema.setup_actors;
HOST USER ROLE ENABLED HISTORY
select * from performance_schema.setup_objects;
OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
select * from performance_schema.socket_instances;
EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
select * from performance_schema.socket_summary_by_event_name;
EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
select * from performance_schema.socket_summary_by_instance;
EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
select * from performance_schema.table_handles;
OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN OWNER_THREAD_ID OWNER_EVENT_ID INTERNAL_LOCK EXTERNAL_LOCK
select * from performance_schema.threads;
THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID RESOURCE_GROUP EXECUTION_ENGINE CONTROLLED_MEMORY MAX_CONTROLLED_MEMORY TOTAL_MEMORY MAX_TOTAL_MEMORY TELEMETRY_ACTIVE
select * from performance_schema.users;
USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS MAX_SESSION_CONTROLLED_MEMORY MAX_SESSION_TOTAL_MEMORY
|
