Debian Codegraph @

mysql-test/suite/perfschema/r/start_server_nothing.result

raw
1 show databases;
2 Database
3 information_schema
4 mtr
5 mysql
6 performance_schema
7 sys
8 test
9 select count(*) from performance_schema.performance_timers;
10 count(*)
11 5
12 select count(*) from performance_schema.setup_consumers;
13 count(*)
14 16
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 1
18 select * from performance_schema.accounts;
19 select * from performance_schema.cond_instances;
20 select * from performance_schema.events_stages_current;
21 select * from performance_schema.events_stages_history;
22 select * from performance_schema.events_stages_history_long;
23 select * from performance_schema.events_stages_summary_by_account_by_event_name;
24 select * from performance_schema.events_stages_summary_by_host_by_event_name;
25 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
26 select * from performance_schema.events_stages_summary_by_user_by_event_name;
27 select * from performance_schema.events_stages_summary_global_by_event_name;
28 select * from performance_schema.events_statements_current;
29 select * from performance_schema.events_statements_histogram_by_digest;
30 select * from performance_schema.events_statements_histogram_global;
31 select * from performance_schema.events_statements_history;
32 select * from performance_schema.events_statements_history_long;
33 select * from performance_schema.events_statements_summary_by_account_by_event_name;
34 select * from performance_schema.events_statements_summary_by_digest;
35 select * from performance_schema.events_statements_summary_by_host_by_event_name;
36 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
37 select * from performance_schema.events_statements_summary_by_user_by_event_name;
38 select * from performance_schema.events_statements_summary_global_by_event_name;
39 select * from performance_schema.events_transactions_current;
40 select * from performance_schema.events_transactions_history;
41 select * from performance_schema.events_transactions_history_long;
42 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
43 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
44 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
45 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
46 select * from performance_schema.events_transactions_summary_global_by_event_name;
47 select * from performance_schema.events_waits_current;
48 select * from performance_schema.events_waits_history;
49 select * from performance_schema.events_waits_history_long;
50 select * from performance_schema.events_waits_summary_by_account_by_event_name;
51 select * from performance_schema.events_waits_summary_by_host_by_event_name;
52 select * from performance_schema.events_waits_summary_by_instance;
53 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
54 select * from performance_schema.events_waits_summary_by_user_by_event_name;
55 select * from performance_schema.events_waits_summary_global_by_event_name;
56 select * from performance_schema.memory_summary_by_account_by_event_name;
57 select * from performance_schema.memory_summary_by_host_by_event_name;
58 select * from performance_schema.memory_summary_by_thread_by_event_name;
59 select * from performance_schema.memory_summary_by_user_by_event_name;
60 select * from performance_schema.memory_summary_global_by_event_name;
61 select * from performance_schema.events_errors_summary_by_account_by_error;
62 select * from performance_schema.events_errors_summary_by_host_by_error;
63 select * from performance_schema.events_errors_summary_by_thread_by_error;
64 select * from performance_schema.events_errors_summary_by_user_by_error;
65 select * from performance_schema.events_errors_summary_global_by_error;
66 select * from performance_schema.file_instances;
67 select * from performance_schema.file_summary_by_event_name;
68 select * from performance_schema.file_summary_by_instance;
69 select * from performance_schema.host_cache;
70 select * from performance_schema.hosts;
71 select * from performance_schema.memory_summary_by_account_by_event_name;
72 select * from performance_schema.memory_summary_by_host_by_event_name;
73 select * from performance_schema.memory_summary_by_thread_by_event_name;
74 select * from performance_schema.memory_summary_by_user_by_event_name;
75 select * from performance_schema.memory_summary_global_by_event_name;
76 select * from performance_schema.metadata_locks;
77 select * from performance_schema.mutex_instances;
78 select * from performance_schema.objects_summary_global_by_type;
79 select * from performance_schema.performance_timers;
80 select * from performance_schema.rwlock_instances;
81 select * from performance_schema.data_locks;
82 select * from performance_schema.data_lock_waits;
83 select * from performance_schema.session_account_connect_attrs;
84 select * from performance_schema.session_connect_attrs;
85 select * from performance_schema.setup_actors;
86 select * from performance_schema.setup_consumers;
87 select * from performance_schema.setup_instruments;
88 select * from performance_schema.setup_objects;
89 select * from performance_schema.setup_threads;
90 select * from performance_schema.socket_instances;
91 select * from performance_schema.socket_summary_by_instance;
92 select * from performance_schema.socket_summary_by_event_name;
93 select * from performance_schema.table_handles;
94 select * from performance_schema.table_io_waits_summary_by_index_usage;
95 select * from performance_schema.table_io_waits_summary_by_table;
96 select * from performance_schema.table_lock_waits_summary_by_table;
97 select * from performance_schema.threads;
98 select * from performance_schema.users;
99 select * from performance_schema.replication_connection_configuration;
100 select * from performance_schema.replication_connection_status;
101 select * from performance_schema.replication_applier_configuration;
102 select * from performance_schema.replication_applier_status;
103 select * from performance_schema.replication_applier_status_by_coordinator;
104 select * from performance_schema.replication_applier_status_by_worker;
105 select * from performance_schema.global_status;
106 select * from performance_schema.status_by_thread;
107 select * from performance_schema.status_by_user;
108 select * from performance_schema.status_by_host;
109 select * from performance_schema.status_by_account;
110 select * from performance_schema.session_status;
111 select * from performance_schema.global_variables;
112 select * from performance_schema.variables_by_thread;
113 select * from performance_schema.session_variables;
114 show engine PERFORMANCE_SCHEMA status;
115 show global status like "performance_schema%";
116 show global variables like "performance_schema%";
117 Variable_name Value
118 performance_schema ON
119 performance_schema_accounts_size 0
120 performance_schema_digests_size 0
121 performance_schema_error_size 0
122 performance_schema_events_stages_history_long_size 0
123 performance_schema_events_stages_history_size 0
124 performance_schema_events_statements_history_long_size 0
125 performance_schema_events_statements_history_size 0
126 performance_schema_events_transactions_history_long_size 1000
127 performance_schema_events_transactions_history_size 10
128 performance_schema_events_waits_history_long_size 0
129 performance_schema_events_waits_history_size 0
130 performance_schema_hosts_size 0
131 performance_schema_max_cond_classes 0
132 performance_schema_max_cond_instances 0
133 performance_schema_max_digest_length 1024
134 performance_schema_max_digest_sample_age 60
135 performance_schema_max_file_classes 0
136 performance_schema_max_file_handles 0
137 performance_schema_max_file_instances 0
138 performance_schema_max_index_stat 0
139 performance_schema_max_memory_classes 0
140 performance_schema_max_metadata_locks 0
141 performance_schema_max_mutex_classes 0
142 performance_schema_max_mutex_instances 0
143 performance_schema_max_prepared_statements_instances -1
144 performance_schema_max_program_instances 0
145 performance_schema_max_rwlock_classes 0
146 performance_schema_max_rwlock_instances 0
147 performance_schema_max_socket_classes 0
148 performance_schema_max_socket_instances 0
149 performance_schema_max_sql_text_length 1024
150 performance_schema_max_stage_classes 0
151 performance_schema_max_statement_classes 0
152 performance_schema_max_statement_stack 1
153 performance_schema_max_table_handles 0
154 performance_schema_max_table_instances 0
155 performance_schema_max_table_lock_stat 0
156 performance_schema_max_thread_classes 0
157 performance_schema_max_thread_instances 0
158 performance_schema_session_connect_attrs_size 0
159 performance_schema_setup_actors_size 0
160 performance_schema_setup_objects_size 0
161 performance_schema_show_processlist OFF
162 performance_schema_users_size 0
163 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
164 from performance_schema.setup_instruments
165 order by name;
166 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
167 error YES NULL 0 NULL
168 idle YES YES user 0 NULL
169 memory/performance_schema/accounts YES NULL global_statistics 1 Memory used for table performance_schema.accounts
170 memory/performance_schema/cond_class YES NULL global_statistics 1 Memory used for cond instrument classes
171 memory/performance_schema/cond_instances YES NULL global_statistics 1 Memory used for table performance_schema.cond_instances
172 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
173 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
174 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
175 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
176 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
177 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
178 memory/performance_schema/events_stages_history YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_history
179 memory/performance_schema/events_stages_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_stages_history_long
180 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
181 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
182 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
183 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
184 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
185 memory/performance_schema/events_statements_current YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_current
186 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
187 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
188 memory/performance_schema/events_statements_history YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history
189 memory/performance_schema/events_statements_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_history_long
190 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
191 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
192 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
193 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
194 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
195 memory/performance_schema/events_statements_summary_by_digest YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_digest
196 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
197 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
198 memory/performance_schema/events_statements_summary_by_program YES NULL global_statistics 1 Memory used for table performance_schema.events_statements_summary_by_program
199 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
200 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
201 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
202 memory/performance_schema/events_transactions_history YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_history
203 memory/performance_schema/events_transactions_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_transactions_history_long
204 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
205 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
206 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
207 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
208 memory/performance_schema/events_waits_history YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_history
209 memory/performance_schema/events_waits_history_long YES NULL global_statistics 1 Memory used for table performance_schema.events_waits_history_long
210 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
211 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
212 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
213 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
214 memory/performance_schema/file_class YES NULL global_statistics 1 Memory used for file instrument classes
215 memory/performance_schema/file_handle YES NULL global_statistics 1 Memory used for table performance_schema.file_handle
216 memory/performance_schema/file_instances YES NULL global_statistics 1 Memory used for table performance_schema.file_instances
217 memory/performance_schema/hosts YES NULL global_statistics 1 Memory used for table performance_schema.hosts
218 memory/performance_schema/memory_class YES NULL global_statistics 1 Memory used for memory instrument classes
219 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
220 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
221 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
222 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
223 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
224 memory/performance_schema/metadata_locks YES NULL global_statistics 1 Memory used for table performance_schema.metadata_locks
225 memory/performance_schema/mutex_class YES NULL global_statistics 1 Memory used for mutex instrument classes
226 memory/performance_schema/mutex_instances YES NULL global_statistics 1 Memory used for table performance_schema.mutex_instances
227 memory/performance_schema/prepared_statements_instances YES NULL global_statistics 1 Memory used for table performance_schema.prepared_statements_instances
228 memory/performance_schema/rwlock_class YES NULL global_statistics 1 Memory used for rwlock instrument classes
229 memory/performance_schema/rwlock_instances YES NULL global_statistics 1 Memory used for table performance_schema.rwlock_instances
230 memory/performance_schema/scalable_buffer YES NULL global_statistics 1 Memory used for scalable buffers
231 memory/performance_schema/session_connect_attrs YES NULL global_statistics 1 Memory used for table performance_schema.session_connect_attrs
232 memory/performance_schema/setup_actors YES NULL global_statistics 1 Memory used for table performance_schema.setup_actors
233 memory/performance_schema/setup_objects YES NULL global_statistics 1 Memory used for table performance_schema.setup_objects
234 memory/performance_schema/socket_class YES NULL global_statistics 1 Memory used for socket instrument classes
235 memory/performance_schema/socket_instances YES NULL global_statistics 1 Memory used for table performance_schema.socket_instances
236 memory/performance_schema/stage_class YES NULL global_statistics 1 Memory used for stage instrument classes
237 memory/performance_schema/statement_class YES NULL global_statistics 1 Memory used for statement instrument classes
238 memory/performance_schema/table_handles YES NULL global_statistics 1 Memory used for table performance_schema.table_handles
239 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
240 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
241 memory/performance_schema/table_shares YES NULL global_statistics 1 Memory used for table performance_schema.table_shares
242 memory/performance_schema/thread_class YES NULL global_statistics 1 Memory used for thread instrument classes
243 memory/performance_schema/threads YES NULL global_statistics 1 Memory used for table performance_schema.threads
244 memory/performance_schema/users YES NULL global_statistics 1 Memory used for table performance_schema.users
245 transaction YES YES 0 NULL
246 wait/io/table/sql/handler YES YES 0 NULL
247 wait/lock/metadata/sql/mdl YES YES 0 NULL
248 wait/lock/table/sql/handler YES YES 0 NULL
249 select TIMER_NAME from performance_schema.performance_timers;
250 TIMER_NAME
251 CYCLE
252 NANOSECOND
253 MICROSECOND
254 MILLISECOND
255 THREAD_CPU
256 select * from performance_schema.setup_consumers;
257 NAME ENABLED
258 events_stages_current YES
259 events_stages_history YES
260 events_stages_history_long YES
261 events_statements_cpu YES
262 events_statements_current YES
263 events_statements_history YES
264 events_statements_history_long YES
265 events_transactions_current YES
266 events_transactions_history YES
267 events_transactions_history_long YES
268 events_waits_current YES
269 events_waits_history YES
270 events_waits_history_long YES
271 global_instrumentation YES
272 thread_instrumentation YES
273 statements_digest YES
274 select * from performance_schema.accounts;
275 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS MAX_SESSION_CONTROLLED_MEMORY MAX_SESSION_TOTAL_MEMORY
276 select * from performance_schema.cond_instances;
277 NAME OBJECT_INSTANCE_BEGIN
278 select * from performance_schema.events_stages_current;
279 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
280 select * from performance_schema.events_stages_history;
281 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
282 select * from performance_schema.events_stages_history_long;
283 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
284 select * from performance_schema.events_stages_summary_by_account_by_event_name;
285 USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
286 select * from performance_schema.events_stages_summary_by_host_by_event_name;
287 HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
288 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
289 THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
290 select * from performance_schema.events_stages_summary_by_user_by_event_name;
291 USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
292 select * from performance_schema.events_stages_summary_global_by_event_name;
293 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
294 select * from performance_schema.events_statements_current;
295 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
296 select * from performance_schema.events_statements_history;
297 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
298 select * from performance_schema.events_statements_history_long;
299 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
300 select * from performance_schema.events_statements_summary_by_account_by_event_name;
301 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
302 select * from performance_schema.events_statements_summary_by_host_by_event_name;
303 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
304 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
305 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
306 select * from performance_schema.events_statements_summary_by_user_by_event_name;
307 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
308 select * from performance_schema.events_statements_summary_global_by_event_name;
309 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
310 select * from performance_schema.events_waits_current;
311 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
312 select * from performance_schema.events_waits_history;
313 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
314 select * from performance_schema.events_waits_history_long;
315 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
316 select * from performance_schema.events_waits_summary_by_account_by_event_name;
317 USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
318 select * from performance_schema.events_waits_summary_by_host_by_event_name;
319 HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
320 select * from performance_schema.events_waits_summary_by_instance;
321 EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
322 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
323 THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
324 select * from performance_schema.events_waits_summary_by_user_by_event_name;
325 USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
326 select * from performance_schema.events_waits_summary_global_by_event_name;
327 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
328 wait/io/table/sql/handler 0 0 0 0 0
329 wait/lock/table/sql/handler 0 0 0 0 0
330 idle 0 0 0 0 0
331 wait/lock/metadata/sql/mdl 0 0 0 0 0
332 select * from performance_schema.file_instances;
333 FILE_NAME EVENT_NAME OPEN_COUNT
334 select * from performance_schema.file_summary_by_event_name;
335 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
336 select * from performance_schema.file_summary_by_instance;
337 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
338 select * from performance_schema.hosts;
339 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS MAX_SESSION_CONTROLLED_MEMORY MAX_SESSION_TOTAL_MEMORY
340 select * from performance_schema.metadata_locks;
341 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COLUMN_NAME OBJECT_INSTANCE_BEGIN LOCK_TYPE LOCK_DURATION LOCK_STATUS SOURCE OWNER_THREAD_ID OWNER_EVENT_ID
342 select * from performance_schema.mutex_instances;
343 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
344 select * from performance_schema.objects_summary_global_by_type;
345 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
346 select * from performance_schema.rwlock_instances;
347 NAME OBJECT_INSTANCE_BEGIN WRITE_LOCKED_BY_THREAD_ID READ_LOCKED_BY_COUNT
348 select * from performance_schema.session_account_connect_attrs;
349 PROCESSLIST_ID ATTR_NAME ATTR_VALUE ORDINAL_POSITION
350 select * from performance_schema.session_connect_attrs;
351 PROCESSLIST_ID ATTR_NAME ATTR_VALUE ORDINAL_POSITION
352 select * from performance_schema.setup_actors;
353 HOST USER ROLE ENABLED HISTORY
354 select * from performance_schema.setup_objects;
355 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
356 select * from performance_schema.socket_instances;
357 EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
358 select * from performance_schema.socket_summary_by_event_name;
359 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
360 select * from performance_schema.socket_summary_by_instance;
361 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
362 select * from performance_schema.table_handles;
363 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN OWNER_THREAD_ID OWNER_EVENT_ID INTERNAL_LOCK EXTERNAL_LOCK
364 select * from performance_schema.threads;
365 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
366 select * from performance_schema.users;
367 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS MAX_SESSION_CONTROLLED_MEMORY MAX_SESSION_TOTAL_MEMORY