Debian Codegraph @

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

raw
1 show databases like 'performance_schema';
2 Database (performance_schema)
3 performance_schema
4 show create database performance_schema;
5 Database Create Database
6 performance_schema CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
7 use performance_schema;
8 show tables;
9 Tables_in_performance_schema
10 accounts
11 binary_log_transaction_compression_stats
12 cond_instances
13 data_lock_waits
14 data_locks
15 error_log
16 events_errors_summary_by_account_by_error
17 events_errors_summary_by_host_by_error
18 events_errors_summary_by_thread_by_error
19 events_errors_summary_by_user_by_error
20 events_errors_summary_global_by_error
21 events_stages_current
22 events_stages_history
23 events_stages_history_long
24 events_stages_summary_by_account_by_event_name
25 events_stages_summary_by_host_by_event_name
26 events_stages_summary_by_thread_by_event_name
27 events_stages_summary_by_user_by_event_name
28 events_stages_summary_global_by_event_name
29 events_statements_current
30 events_statements_histogram_by_digest
31 events_statements_histogram_global
32 events_statements_history
33 events_statements_history_long
34 events_statements_summary_by_account_by_event_name
35 events_statements_summary_by_digest
36 events_statements_summary_by_host_by_event_name
37 events_statements_summary_by_program
38 events_statements_summary_by_thread_by_event_name
39 events_statements_summary_by_user_by_event_name
40 events_statements_summary_global_by_event_name
41 events_transactions_current
42 events_transactions_history
43 events_transactions_history_long
44 events_transactions_summary_by_account_by_event_name
45 events_transactions_summary_by_host_by_event_name
46 events_transactions_summary_by_thread_by_event_name
47 events_transactions_summary_by_user_by_event_name
48 events_transactions_summary_global_by_event_name
49 events_waits_current
50 events_waits_history
51 events_waits_history_long
52 events_waits_summary_by_account_by_event_name
53 events_waits_summary_by_host_by_event_name
54 events_waits_summary_by_instance
55 events_waits_summary_by_thread_by_event_name
56 events_waits_summary_by_user_by_event_name
57 events_waits_summary_global_by_event_name
58 file_instances
59 file_summary_by_event_name
60 file_summary_by_instance
61 global_status
62 global_variables
63 host_cache
64 hosts
65 innodb_redo_log_files
66 keyring_component_status
67 keyring_keys
68 log_status
69 memory_summary_by_account_by_event_name
70 memory_summary_by_host_by_event_name
71 memory_summary_by_thread_by_event_name
72 memory_summary_by_user_by_event_name
73 memory_summary_global_by_event_name
74 metadata_locks
75 mutex_instances
76 objects_summary_global_by_type
77 performance_timers
78 persisted_variables
79 prepared_statements_instances
80 processlist
81 replication_applier_configuration
82 replication_applier_filters
83 replication_applier_global_filters
84 replication_applier_status
85 replication_applier_status_by_coordinator
86 replication_applier_status_by_worker
87 replication_asynchronous_connection_failover
88 replication_asynchronous_connection_failover_managed
89 replication_connection_configuration
90 replication_connection_status
91 replication_group_member_stats
92 replication_group_members
93 rwlock_instances
94 session_account_connect_attrs
95 session_connect_attrs
96 session_status
97 session_variables
98 setup_actors
99 setup_consumers
100 setup_instruments
101 setup_objects
102 setup_threads
103 socket_instances
104 socket_summary_by_event_name
105 socket_summary_by_instance
106 status_by_account
107 status_by_host
108 status_by_thread
109 status_by_user
110 table_handles
111 table_io_waits_summary_by_index_usage
112 table_io_waits_summary_by_table
113 table_lock_waits_summary_by_table
114 threads
115 tls_channel_status
116 user_defined_functions
117 user_variables_by_thread
118 users
119 variables_by_thread
120 variables_info
121 show create table accounts;
122 Table Create Table
123 accounts CREATE TABLE `accounts` (
124 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
125 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
126 `CURRENT_CONNECTIONS` bigint NOT NULL,
127 `TOTAL_CONNECTIONS` bigint NOT NULL,
128 `MAX_SESSION_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
129 `MAX_SESSION_TOTAL_MEMORY` bigint unsigned NOT NULL,
130 UNIQUE KEY `ACCOUNT` (`USER`,`HOST`)
131 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
132 show create table cond_instances;
133 Table Create Table
134 cond_instances CREATE TABLE `cond_instances` (
135 `NAME` varchar(128) NOT NULL,
136 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
137 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
138 KEY `NAME` (`NAME`)
139 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
140 show create table events_stages_current;
141 Table Create Table
142 events_stages_current CREATE TABLE `events_stages_current` (
143 `THREAD_ID` bigint unsigned NOT NULL,
144 `EVENT_ID` bigint unsigned NOT NULL,
145 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
146 `EVENT_NAME` varchar(128) NOT NULL,
147 `SOURCE` varchar(64) DEFAULT NULL,
148 `TIMER_START` bigint unsigned DEFAULT NULL,
149 `TIMER_END` bigint unsigned DEFAULT NULL,
150 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
151 `WORK_COMPLETED` bigint unsigned DEFAULT NULL,
152 `WORK_ESTIMATED` bigint unsigned DEFAULT NULL,
153 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
154 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
155 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
156 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
157 show create table events_stages_history;
158 Table Create Table
159 events_stages_history CREATE TABLE `events_stages_history` (
160 `THREAD_ID` bigint unsigned NOT NULL,
161 `EVENT_ID` bigint unsigned NOT NULL,
162 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
163 `EVENT_NAME` varchar(128) NOT NULL,
164 `SOURCE` varchar(64) DEFAULT NULL,
165 `TIMER_START` bigint unsigned DEFAULT NULL,
166 `TIMER_END` bigint unsigned DEFAULT NULL,
167 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
168 `WORK_COMPLETED` bigint unsigned DEFAULT NULL,
169 `WORK_ESTIMATED` bigint unsigned DEFAULT NULL,
170 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
171 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
172 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
173 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
174 show create table events_stages_history_long;
175 Table Create Table
176 events_stages_history_long CREATE TABLE `events_stages_history_long` (
177 `THREAD_ID` bigint unsigned NOT NULL,
178 `EVENT_ID` bigint unsigned NOT NULL,
179 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
180 `EVENT_NAME` varchar(128) NOT NULL,
181 `SOURCE` varchar(64) DEFAULT NULL,
182 `TIMER_START` bigint unsigned DEFAULT NULL,
183 `TIMER_END` bigint unsigned DEFAULT NULL,
184 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
185 `WORK_COMPLETED` bigint unsigned DEFAULT NULL,
186 `WORK_ESTIMATED` bigint unsigned DEFAULT NULL,
187 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
188 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL
189 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
190 show create table events_stages_summary_by_host_by_event_name;
191 Table Create Table
192 events_stages_summary_by_host_by_event_name CREATE TABLE `events_stages_summary_by_host_by_event_name` (
193 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
194 `EVENT_NAME` varchar(128) NOT NULL,
195 `COUNT_STAR` bigint unsigned NOT NULL,
196 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
197 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
198 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
199 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
200 UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
201 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
202 show create table events_stages_summary_by_thread_by_event_name;
203 Table Create Table
204 events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_summary_by_thread_by_event_name` (
205 `THREAD_ID` bigint unsigned NOT NULL,
206 `EVENT_NAME` varchar(128) NOT NULL,
207 `COUNT_STAR` bigint unsigned NOT NULL,
208 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
209 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
210 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
211 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
212 PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
213 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
214 show create table events_stages_summary_by_user_by_event_name;
215 Table Create Table
216 events_stages_summary_by_user_by_event_name CREATE TABLE `events_stages_summary_by_user_by_event_name` (
217 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
218 `EVENT_NAME` varchar(128) NOT NULL,
219 `COUNT_STAR` bigint unsigned NOT NULL,
220 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
221 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
222 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
223 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
224 UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
225 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
226 show create table events_stages_summary_by_account_by_event_name;
227 Table Create Table
228 events_stages_summary_by_account_by_event_name CREATE TABLE `events_stages_summary_by_account_by_event_name` (
229 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
230 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
231 `EVENT_NAME` varchar(128) NOT NULL,
232 `COUNT_STAR` bigint unsigned NOT NULL,
233 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
234 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
235 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
236 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
237 UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
238 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
239 show create table events_stages_summary_global_by_event_name;
240 Table Create Table
241 events_stages_summary_global_by_event_name CREATE TABLE `events_stages_summary_global_by_event_name` (
242 `EVENT_NAME` varchar(128) NOT NULL,
243 `COUNT_STAR` bigint unsigned NOT NULL,
244 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
245 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
246 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
247 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
248 PRIMARY KEY (`EVENT_NAME`)
249 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
250 show create table events_statements_current;
251 Table Create Table
252 events_statements_current CREATE TABLE `events_statements_current` (
253 `THREAD_ID` bigint unsigned NOT NULL,
254 `EVENT_ID` bigint unsigned NOT NULL,
255 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
256 `EVENT_NAME` varchar(128) NOT NULL,
257 `SOURCE` varchar(64) DEFAULT NULL,
258 `TIMER_START` bigint unsigned DEFAULT NULL,
259 `TIMER_END` bigint unsigned DEFAULT NULL,
260 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
261 `LOCK_TIME` bigint unsigned NOT NULL,
262 `SQL_TEXT` longtext,
263 `DIGEST` varchar(64) DEFAULT NULL,
264 `DIGEST_TEXT` longtext,
265 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
266 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
267 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
268 `OBJECT_NAME` varchar(64) DEFAULT NULL,
269 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
270 `MYSQL_ERRNO` int DEFAULT NULL,
271 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
272 `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
273 `ERRORS` bigint unsigned NOT NULL,
274 `WARNINGS` bigint unsigned NOT NULL,
275 `ROWS_AFFECTED` bigint unsigned NOT NULL,
276 `ROWS_SENT` bigint unsigned NOT NULL,
277 `ROWS_EXAMINED` bigint unsigned NOT NULL,
278 `CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
279 `CREATED_TMP_TABLES` bigint unsigned NOT NULL,
280 `SELECT_FULL_JOIN` bigint unsigned NOT NULL,
281 `SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
282 `SELECT_RANGE` bigint unsigned NOT NULL,
283 `SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
284 `SELECT_SCAN` bigint unsigned NOT NULL,
285 `SORT_MERGE_PASSES` bigint unsigned NOT NULL,
286 `SORT_RANGE` bigint unsigned NOT NULL,
287 `SORT_ROWS` bigint unsigned NOT NULL,
288 `SORT_SCAN` bigint unsigned NOT NULL,
289 `NO_INDEX_USED` bigint unsigned NOT NULL,
290 `NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
291 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
292 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
293 `NESTING_EVENT_LEVEL` int DEFAULT NULL,
294 `STATEMENT_ID` bigint unsigned DEFAULT NULL,
295 `CPU_TIME` bigint unsigned NOT NULL,
296 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
297 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
298 `EXECUTION_ENGINE` enum('PRIMARY','SECONDARY') DEFAULT NULL,
299 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
300 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
301 show create table events_statements_history;
302 Table Create Table
303 events_statements_history CREATE TABLE `events_statements_history` (
304 `THREAD_ID` bigint unsigned NOT NULL,
305 `EVENT_ID` bigint unsigned NOT NULL,
306 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
307 `EVENT_NAME` varchar(128) NOT NULL,
308 `SOURCE` varchar(64) DEFAULT NULL,
309 `TIMER_START` bigint unsigned DEFAULT NULL,
310 `TIMER_END` bigint unsigned DEFAULT NULL,
311 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
312 `LOCK_TIME` bigint unsigned NOT NULL,
313 `SQL_TEXT` longtext,
314 `DIGEST` varchar(64) DEFAULT NULL,
315 `DIGEST_TEXT` longtext,
316 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
317 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
318 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
319 `OBJECT_NAME` varchar(64) DEFAULT NULL,
320 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
321 `MYSQL_ERRNO` int DEFAULT NULL,
322 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
323 `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
324 `ERRORS` bigint unsigned NOT NULL,
325 `WARNINGS` bigint unsigned NOT NULL,
326 `ROWS_AFFECTED` bigint unsigned NOT NULL,
327 `ROWS_SENT` bigint unsigned NOT NULL,
328 `ROWS_EXAMINED` bigint unsigned NOT NULL,
329 `CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
330 `CREATED_TMP_TABLES` bigint unsigned NOT NULL,
331 `SELECT_FULL_JOIN` bigint unsigned NOT NULL,
332 `SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
333 `SELECT_RANGE` bigint unsigned NOT NULL,
334 `SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
335 `SELECT_SCAN` bigint unsigned NOT NULL,
336 `SORT_MERGE_PASSES` bigint unsigned NOT NULL,
337 `SORT_RANGE` bigint unsigned NOT NULL,
338 `SORT_ROWS` bigint unsigned NOT NULL,
339 `SORT_SCAN` bigint unsigned NOT NULL,
340 `NO_INDEX_USED` bigint unsigned NOT NULL,
341 `NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
342 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
343 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
344 `NESTING_EVENT_LEVEL` int DEFAULT NULL,
345 `STATEMENT_ID` bigint unsigned DEFAULT NULL,
346 `CPU_TIME` bigint unsigned NOT NULL,
347 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
348 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
349 `EXECUTION_ENGINE` enum('PRIMARY','SECONDARY') DEFAULT NULL,
350 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
351 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
352 show create table events_statements_history_long;
353 Table Create Table
354 events_statements_history_long CREATE TABLE `events_statements_history_long` (
355 `THREAD_ID` bigint unsigned NOT NULL,
356 `EVENT_ID` bigint unsigned NOT NULL,
357 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
358 `EVENT_NAME` varchar(128) NOT NULL,
359 `SOURCE` varchar(64) DEFAULT NULL,
360 `TIMER_START` bigint unsigned DEFAULT NULL,
361 `TIMER_END` bigint unsigned DEFAULT NULL,
362 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
363 `LOCK_TIME` bigint unsigned NOT NULL,
364 `SQL_TEXT` longtext,
365 `DIGEST` varchar(64) DEFAULT NULL,
366 `DIGEST_TEXT` longtext,
367 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
368 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
369 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
370 `OBJECT_NAME` varchar(64) DEFAULT NULL,
371 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
372 `MYSQL_ERRNO` int DEFAULT NULL,
373 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
374 `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
375 `ERRORS` bigint unsigned NOT NULL,
376 `WARNINGS` bigint unsigned NOT NULL,
377 `ROWS_AFFECTED` bigint unsigned NOT NULL,
378 `ROWS_SENT` bigint unsigned NOT NULL,
379 `ROWS_EXAMINED` bigint unsigned NOT NULL,
380 `CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
381 `CREATED_TMP_TABLES` bigint unsigned NOT NULL,
382 `SELECT_FULL_JOIN` bigint unsigned NOT NULL,
383 `SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
384 `SELECT_RANGE` bigint unsigned NOT NULL,
385 `SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
386 `SELECT_SCAN` bigint unsigned NOT NULL,
387 `SORT_MERGE_PASSES` bigint unsigned NOT NULL,
388 `SORT_RANGE` bigint unsigned NOT NULL,
389 `SORT_ROWS` bigint unsigned NOT NULL,
390 `SORT_SCAN` bigint unsigned NOT NULL,
391 `NO_INDEX_USED` bigint unsigned NOT NULL,
392 `NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
393 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
394 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
395 `NESTING_EVENT_LEVEL` int DEFAULT NULL,
396 `STATEMENT_ID` bigint unsigned DEFAULT NULL,
397 `CPU_TIME` bigint unsigned NOT NULL,
398 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
399 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
400 `EXECUTION_ENGINE` enum('PRIMARY','SECONDARY') DEFAULT NULL
401 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
402 show create table events_statements_summary_by_digest;
403 Table Create Table
404 events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_digest` (
405 `SCHEMA_NAME` varchar(64) DEFAULT NULL,
406 `DIGEST` varchar(64) DEFAULT NULL,
407 `DIGEST_TEXT` longtext,
408 `COUNT_STAR` bigint unsigned NOT NULL,
409 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
410 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
411 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
412 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
413 `SUM_LOCK_TIME` bigint unsigned NOT NULL,
414 `SUM_ERRORS` bigint unsigned NOT NULL,
415 `SUM_WARNINGS` bigint unsigned NOT NULL,
416 `SUM_ROWS_AFFECTED` bigint unsigned NOT NULL,
417 `SUM_ROWS_SENT` bigint unsigned NOT NULL,
418 `SUM_ROWS_EXAMINED` bigint unsigned NOT NULL,
419 `SUM_CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
420 `SUM_CREATED_TMP_TABLES` bigint unsigned NOT NULL,
421 `SUM_SELECT_FULL_JOIN` bigint unsigned NOT NULL,
422 `SUM_SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
423 `SUM_SELECT_RANGE` bigint unsigned NOT NULL,
424 `SUM_SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
425 `SUM_SELECT_SCAN` bigint unsigned NOT NULL,
426 `SUM_SORT_MERGE_PASSES` bigint unsigned NOT NULL,
427 `SUM_SORT_RANGE` bigint unsigned NOT NULL,
428 `SUM_SORT_ROWS` bigint unsigned NOT NULL,
429 `SUM_SORT_SCAN` bigint unsigned NOT NULL,
430 `SUM_NO_INDEX_USED` bigint unsigned NOT NULL,
431 `SUM_NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
432 `SUM_CPU_TIME` bigint unsigned NOT NULL,
433 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
434 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
435 `COUNT_SECONDARY` bigint unsigned NOT NULL,
436 `FIRST_SEEN` timestamp(6) NOT NULL,
437 `LAST_SEEN` timestamp(6) NOT NULL,
438 `QUANTILE_95` bigint unsigned NOT NULL,
439 `QUANTILE_99` bigint unsigned NOT NULL,
440 `QUANTILE_999` bigint unsigned NOT NULL,
441 `QUERY_SAMPLE_TEXT` longtext,
442 `QUERY_SAMPLE_SEEN` timestamp(6) NOT NULL,
443 `QUERY_SAMPLE_TIMER_WAIT` bigint unsigned NOT NULL,
444 UNIQUE KEY `SCHEMA_NAME` (`SCHEMA_NAME`,`DIGEST`)
445 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
446 show create table events_statements_summary_by_host_by_event_name;
447 Table Create Table
448 events_statements_summary_by_host_by_event_name CREATE TABLE `events_statements_summary_by_host_by_event_name` (
449 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
450 `EVENT_NAME` varchar(128) NOT NULL,
451 `COUNT_STAR` bigint unsigned NOT NULL,
452 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
453 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
454 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
455 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
456 `SUM_LOCK_TIME` bigint unsigned NOT NULL,
457 `SUM_ERRORS` bigint unsigned NOT NULL,
458 `SUM_WARNINGS` bigint unsigned NOT NULL,
459 `SUM_ROWS_AFFECTED` bigint unsigned NOT NULL,
460 `SUM_ROWS_SENT` bigint unsigned NOT NULL,
461 `SUM_ROWS_EXAMINED` bigint unsigned NOT NULL,
462 `SUM_CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
463 `SUM_CREATED_TMP_TABLES` bigint unsigned NOT NULL,
464 `SUM_SELECT_FULL_JOIN` bigint unsigned NOT NULL,
465 `SUM_SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
466 `SUM_SELECT_RANGE` bigint unsigned NOT NULL,
467 `SUM_SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
468 `SUM_SELECT_SCAN` bigint unsigned NOT NULL,
469 `SUM_SORT_MERGE_PASSES` bigint unsigned NOT NULL,
470 `SUM_SORT_RANGE` bigint unsigned NOT NULL,
471 `SUM_SORT_ROWS` bigint unsigned NOT NULL,
472 `SUM_SORT_SCAN` bigint unsigned NOT NULL,
473 `SUM_NO_INDEX_USED` bigint unsigned NOT NULL,
474 `SUM_NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
475 `SUM_CPU_TIME` bigint unsigned NOT NULL,
476 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
477 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
478 `COUNT_SECONDARY` bigint unsigned NOT NULL,
479 UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
480 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
481 show create table events_statements_summary_by_thread_by_event_name;
482 Table Create Table
483 events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statements_summary_by_thread_by_event_name` (
484 `THREAD_ID` bigint unsigned NOT NULL,
485 `EVENT_NAME` varchar(128) NOT NULL,
486 `COUNT_STAR` bigint unsigned NOT NULL,
487 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
488 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
489 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
490 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
491 `SUM_LOCK_TIME` bigint unsigned NOT NULL,
492 `SUM_ERRORS` bigint unsigned NOT NULL,
493 `SUM_WARNINGS` bigint unsigned NOT NULL,
494 `SUM_ROWS_AFFECTED` bigint unsigned NOT NULL,
495 `SUM_ROWS_SENT` bigint unsigned NOT NULL,
496 `SUM_ROWS_EXAMINED` bigint unsigned NOT NULL,
497 `SUM_CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
498 `SUM_CREATED_TMP_TABLES` bigint unsigned NOT NULL,
499 `SUM_SELECT_FULL_JOIN` bigint unsigned NOT NULL,
500 `SUM_SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
501 `SUM_SELECT_RANGE` bigint unsigned NOT NULL,
502 `SUM_SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
503 `SUM_SELECT_SCAN` bigint unsigned NOT NULL,
504 `SUM_SORT_MERGE_PASSES` bigint unsigned NOT NULL,
505 `SUM_SORT_RANGE` bigint unsigned NOT NULL,
506 `SUM_SORT_ROWS` bigint unsigned NOT NULL,
507 `SUM_SORT_SCAN` bigint unsigned NOT NULL,
508 `SUM_NO_INDEX_USED` bigint unsigned NOT NULL,
509 `SUM_NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
510 `SUM_CPU_TIME` bigint unsigned NOT NULL,
511 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
512 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
513 `COUNT_SECONDARY` bigint unsigned NOT NULL,
514 PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
515 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
516 show create table events_statements_summary_by_user_by_event_name;
517 Table Create Table
518 events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_summary_by_user_by_event_name` (
519 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
520 `EVENT_NAME` varchar(128) NOT NULL,
521 `COUNT_STAR` bigint unsigned NOT NULL,
522 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
523 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
524 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
525 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
526 `SUM_LOCK_TIME` bigint unsigned NOT NULL,
527 `SUM_ERRORS` bigint unsigned NOT NULL,
528 `SUM_WARNINGS` bigint unsigned NOT NULL,
529 `SUM_ROWS_AFFECTED` bigint unsigned NOT NULL,
530 `SUM_ROWS_SENT` bigint unsigned NOT NULL,
531 `SUM_ROWS_EXAMINED` bigint unsigned NOT NULL,
532 `SUM_CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
533 `SUM_CREATED_TMP_TABLES` bigint unsigned NOT NULL,
534 `SUM_SELECT_FULL_JOIN` bigint unsigned NOT NULL,
535 `SUM_SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
536 `SUM_SELECT_RANGE` bigint unsigned NOT NULL,
537 `SUM_SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
538 `SUM_SELECT_SCAN` bigint unsigned NOT NULL,
539 `SUM_SORT_MERGE_PASSES` bigint unsigned NOT NULL,
540 `SUM_SORT_RANGE` bigint unsigned NOT NULL,
541 `SUM_SORT_ROWS` bigint unsigned NOT NULL,
542 `SUM_SORT_SCAN` bigint unsigned NOT NULL,
543 `SUM_NO_INDEX_USED` bigint unsigned NOT NULL,
544 `SUM_NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
545 `SUM_CPU_TIME` bigint unsigned NOT NULL,
546 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
547 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
548 `COUNT_SECONDARY` bigint unsigned NOT NULL,
549 UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
550 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
551 show create table events_statements_summary_by_account_by_event_name;
552 Table Create Table
553 events_statements_summary_by_account_by_event_name CREATE TABLE `events_statements_summary_by_account_by_event_name` (
554 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
555 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
556 `EVENT_NAME` varchar(128) NOT NULL,
557 `COUNT_STAR` bigint unsigned NOT NULL,
558 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
559 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
560 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
561 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
562 `SUM_LOCK_TIME` bigint unsigned NOT NULL,
563 `SUM_ERRORS` bigint unsigned NOT NULL,
564 `SUM_WARNINGS` bigint unsigned NOT NULL,
565 `SUM_ROWS_AFFECTED` bigint unsigned NOT NULL,
566 `SUM_ROWS_SENT` bigint unsigned NOT NULL,
567 `SUM_ROWS_EXAMINED` bigint unsigned NOT NULL,
568 `SUM_CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
569 `SUM_CREATED_TMP_TABLES` bigint unsigned NOT NULL,
570 `SUM_SELECT_FULL_JOIN` bigint unsigned NOT NULL,
571 `SUM_SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
572 `SUM_SELECT_RANGE` bigint unsigned NOT NULL,
573 `SUM_SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
574 `SUM_SELECT_SCAN` bigint unsigned NOT NULL,
575 `SUM_SORT_MERGE_PASSES` bigint unsigned NOT NULL,
576 `SUM_SORT_RANGE` bigint unsigned NOT NULL,
577 `SUM_SORT_ROWS` bigint unsigned NOT NULL,
578 `SUM_SORT_SCAN` bigint unsigned NOT NULL,
579 `SUM_NO_INDEX_USED` bigint unsigned NOT NULL,
580 `SUM_NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
581 `SUM_CPU_TIME` bigint unsigned NOT NULL,
582 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
583 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
584 `COUNT_SECONDARY` bigint unsigned NOT NULL,
585 UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
586 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
587 show create table events_statements_summary_global_by_event_name;
588 Table Create Table
589 events_statements_summary_global_by_event_name CREATE TABLE `events_statements_summary_global_by_event_name` (
590 `EVENT_NAME` varchar(128) NOT NULL,
591 `COUNT_STAR` bigint unsigned NOT NULL,
592 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
593 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
594 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
595 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
596 `SUM_LOCK_TIME` bigint unsigned NOT NULL,
597 `SUM_ERRORS` bigint unsigned NOT NULL,
598 `SUM_WARNINGS` bigint unsigned NOT NULL,
599 `SUM_ROWS_AFFECTED` bigint unsigned NOT NULL,
600 `SUM_ROWS_SENT` bigint unsigned NOT NULL,
601 `SUM_ROWS_EXAMINED` bigint unsigned NOT NULL,
602 `SUM_CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
603 `SUM_CREATED_TMP_TABLES` bigint unsigned NOT NULL,
604 `SUM_SELECT_FULL_JOIN` bigint unsigned NOT NULL,
605 `SUM_SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
606 `SUM_SELECT_RANGE` bigint unsigned NOT NULL,
607 `SUM_SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
608 `SUM_SELECT_SCAN` bigint unsigned NOT NULL,
609 `SUM_SORT_MERGE_PASSES` bigint unsigned NOT NULL,
610 `SUM_SORT_RANGE` bigint unsigned NOT NULL,
611 `SUM_SORT_ROWS` bigint unsigned NOT NULL,
612 `SUM_SORT_SCAN` bigint unsigned NOT NULL,
613 `SUM_NO_INDEX_USED` bigint unsigned NOT NULL,
614 `SUM_NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
615 `SUM_CPU_TIME` bigint unsigned NOT NULL,
616 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
617 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
618 `COUNT_SECONDARY` bigint unsigned NOT NULL,
619 PRIMARY KEY (`EVENT_NAME`)
620 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
621 show create table events_transactions_current;
622 Table Create Table
623 events_transactions_current CREATE TABLE `events_transactions_current` (
624 `THREAD_ID` bigint unsigned NOT NULL,
625 `EVENT_ID` bigint unsigned NOT NULL,
626 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
627 `EVENT_NAME` varchar(128) NOT NULL,
628 `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL,
629 `TRX_ID` bigint unsigned DEFAULT NULL,
630 `GTID` varchar(64) DEFAULT NULL,
631 `XID_FORMAT_ID` int DEFAULT NULL,
632 `XID_GTRID` varchar(130) DEFAULT NULL,
633 `XID_BQUAL` varchar(130) DEFAULT NULL,
634 `XA_STATE` varchar(64) DEFAULT NULL,
635 `SOURCE` varchar(64) DEFAULT NULL,
636 `TIMER_START` bigint unsigned DEFAULT NULL,
637 `TIMER_END` bigint unsigned DEFAULT NULL,
638 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
639 `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL,
640 `ISOLATION_LEVEL` varchar(64) DEFAULT NULL,
641 `AUTOCOMMIT` enum('YES','NO') NOT NULL,
642 `NUMBER_OF_SAVEPOINTS` bigint unsigned DEFAULT NULL,
643 `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint unsigned DEFAULT NULL,
644 `NUMBER_OF_RELEASE_SAVEPOINT` bigint unsigned DEFAULT NULL,
645 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
646 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
647 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
648 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
649 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
650 show create table events_transactions_history;
651 Table Create Table
652 events_transactions_history CREATE TABLE `events_transactions_history` (
653 `THREAD_ID` bigint unsigned NOT NULL,
654 `EVENT_ID` bigint unsigned NOT NULL,
655 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
656 `EVENT_NAME` varchar(128) NOT NULL,
657 `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL,
658 `TRX_ID` bigint unsigned DEFAULT NULL,
659 `GTID` varchar(64) DEFAULT NULL,
660 `XID_FORMAT_ID` int DEFAULT NULL,
661 `XID_GTRID` varchar(130) DEFAULT NULL,
662 `XID_BQUAL` varchar(130) DEFAULT NULL,
663 `XA_STATE` varchar(64) DEFAULT NULL,
664 `SOURCE` varchar(64) DEFAULT NULL,
665 `TIMER_START` bigint unsigned DEFAULT NULL,
666 `TIMER_END` bigint unsigned DEFAULT NULL,
667 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
668 `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL,
669 `ISOLATION_LEVEL` varchar(64) DEFAULT NULL,
670 `AUTOCOMMIT` enum('YES','NO') NOT NULL,
671 `NUMBER_OF_SAVEPOINTS` bigint unsigned DEFAULT NULL,
672 `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint unsigned DEFAULT NULL,
673 `NUMBER_OF_RELEASE_SAVEPOINT` bigint unsigned DEFAULT NULL,
674 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
675 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
676 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
677 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
678 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
679 show create table events_transactions_history_long;
680 Table Create Table
681 events_transactions_history_long CREATE TABLE `events_transactions_history_long` (
682 `THREAD_ID` bigint unsigned NOT NULL,
683 `EVENT_ID` bigint unsigned NOT NULL,
684 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
685 `EVENT_NAME` varchar(128) NOT NULL,
686 `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL,
687 `TRX_ID` bigint unsigned DEFAULT NULL,
688 `GTID` varchar(64) DEFAULT NULL,
689 `XID_FORMAT_ID` int DEFAULT NULL,
690 `XID_GTRID` varchar(130) DEFAULT NULL,
691 `XID_BQUAL` varchar(130) DEFAULT NULL,
692 `XA_STATE` varchar(64) DEFAULT NULL,
693 `SOURCE` varchar(64) DEFAULT NULL,
694 `TIMER_START` bigint unsigned DEFAULT NULL,
695 `TIMER_END` bigint unsigned DEFAULT NULL,
696 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
697 `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL,
698 `ISOLATION_LEVEL` varchar(64) DEFAULT NULL,
699 `AUTOCOMMIT` enum('YES','NO') NOT NULL,
700 `NUMBER_OF_SAVEPOINTS` bigint unsigned DEFAULT NULL,
701 `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint unsigned DEFAULT NULL,
702 `NUMBER_OF_RELEASE_SAVEPOINT` bigint unsigned DEFAULT NULL,
703 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
704 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
705 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL
706 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
707 show create table events_transactions_summary_by_host_by_event_name;
708 Table Create Table
709 events_transactions_summary_by_host_by_event_name CREATE TABLE `events_transactions_summary_by_host_by_event_name` (
710 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
711 `EVENT_NAME` varchar(128) NOT NULL,
712 `COUNT_STAR` bigint unsigned NOT NULL,
713 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
714 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
715 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
716 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
717 `COUNT_READ_WRITE` bigint unsigned NOT NULL,
718 `SUM_TIMER_READ_WRITE` bigint unsigned NOT NULL,
719 `MIN_TIMER_READ_WRITE` bigint unsigned NOT NULL,
720 `AVG_TIMER_READ_WRITE` bigint unsigned NOT NULL,
721 `MAX_TIMER_READ_WRITE` bigint unsigned NOT NULL,
722 `COUNT_READ_ONLY` bigint unsigned NOT NULL,
723 `SUM_TIMER_READ_ONLY` bigint unsigned NOT NULL,
724 `MIN_TIMER_READ_ONLY` bigint unsigned NOT NULL,
725 `AVG_TIMER_READ_ONLY` bigint unsigned NOT NULL,
726 `MAX_TIMER_READ_ONLY` bigint unsigned NOT NULL,
727 UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
728 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
729 show create table events_transactions_summary_by_thread_by_event_name;
730 Table Create Table
731 events_transactions_summary_by_thread_by_event_name CREATE TABLE `events_transactions_summary_by_thread_by_event_name` (
732 `THREAD_ID` bigint unsigned NOT NULL,
733 `EVENT_NAME` varchar(128) NOT NULL,
734 `COUNT_STAR` bigint unsigned NOT NULL,
735 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
736 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
737 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
738 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
739 `COUNT_READ_WRITE` bigint unsigned NOT NULL,
740 `SUM_TIMER_READ_WRITE` bigint unsigned NOT NULL,
741 `MIN_TIMER_READ_WRITE` bigint unsigned NOT NULL,
742 `AVG_TIMER_READ_WRITE` bigint unsigned NOT NULL,
743 `MAX_TIMER_READ_WRITE` bigint unsigned NOT NULL,
744 `COUNT_READ_ONLY` bigint unsigned NOT NULL,
745 `SUM_TIMER_READ_ONLY` bigint unsigned NOT NULL,
746 `MIN_TIMER_READ_ONLY` bigint unsigned NOT NULL,
747 `AVG_TIMER_READ_ONLY` bigint unsigned NOT NULL,
748 `MAX_TIMER_READ_ONLY` bigint unsigned NOT NULL,
749 PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
750 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
751 show create table events_transactions_summary_by_user_by_event_name;
752 Table Create Table
753 events_transactions_summary_by_user_by_event_name CREATE TABLE `events_transactions_summary_by_user_by_event_name` (
754 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
755 `EVENT_NAME` varchar(128) NOT NULL,
756 `COUNT_STAR` bigint unsigned NOT NULL,
757 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
758 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
759 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
760 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
761 `COUNT_READ_WRITE` bigint unsigned NOT NULL,
762 `SUM_TIMER_READ_WRITE` bigint unsigned NOT NULL,
763 `MIN_TIMER_READ_WRITE` bigint unsigned NOT NULL,
764 `AVG_TIMER_READ_WRITE` bigint unsigned NOT NULL,
765 `MAX_TIMER_READ_WRITE` bigint unsigned NOT NULL,
766 `COUNT_READ_ONLY` bigint unsigned NOT NULL,
767 `SUM_TIMER_READ_ONLY` bigint unsigned NOT NULL,
768 `MIN_TIMER_READ_ONLY` bigint unsigned NOT NULL,
769 `AVG_TIMER_READ_ONLY` bigint unsigned NOT NULL,
770 `MAX_TIMER_READ_ONLY` bigint unsigned NOT NULL,
771 UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
772 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
773 show create table events_transactions_summary_by_account_by_event_name;
774 Table Create Table
775 events_transactions_summary_by_account_by_event_name CREATE TABLE `events_transactions_summary_by_account_by_event_name` (
776 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
777 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
778 `EVENT_NAME` varchar(128) NOT NULL,
779 `COUNT_STAR` bigint unsigned NOT NULL,
780 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
781 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
782 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
783 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
784 `COUNT_READ_WRITE` bigint unsigned NOT NULL,
785 `SUM_TIMER_READ_WRITE` bigint unsigned NOT NULL,
786 `MIN_TIMER_READ_WRITE` bigint unsigned NOT NULL,
787 `AVG_TIMER_READ_WRITE` bigint unsigned NOT NULL,
788 `MAX_TIMER_READ_WRITE` bigint unsigned NOT NULL,
789 `COUNT_READ_ONLY` bigint unsigned NOT NULL,
790 `SUM_TIMER_READ_ONLY` bigint unsigned NOT NULL,
791 `MIN_TIMER_READ_ONLY` bigint unsigned NOT NULL,
792 `AVG_TIMER_READ_ONLY` bigint unsigned NOT NULL,
793 `MAX_TIMER_READ_ONLY` bigint unsigned NOT NULL,
794 UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
795 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
796 show create table events_transactions_summary_global_by_event_name;
797 Table Create Table
798 events_transactions_summary_global_by_event_name CREATE TABLE `events_transactions_summary_global_by_event_name` (
799 `EVENT_NAME` varchar(128) NOT NULL,
800 `COUNT_STAR` bigint unsigned NOT NULL,
801 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
802 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
803 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
804 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
805 `COUNT_READ_WRITE` bigint unsigned NOT NULL,
806 `SUM_TIMER_READ_WRITE` bigint unsigned NOT NULL,
807 `MIN_TIMER_READ_WRITE` bigint unsigned NOT NULL,
808 `AVG_TIMER_READ_WRITE` bigint unsigned NOT NULL,
809 `MAX_TIMER_READ_WRITE` bigint unsigned NOT NULL,
810 `COUNT_READ_ONLY` bigint unsigned NOT NULL,
811 `SUM_TIMER_READ_ONLY` bigint unsigned NOT NULL,
812 `MIN_TIMER_READ_ONLY` bigint unsigned NOT NULL,
813 `AVG_TIMER_READ_ONLY` bigint unsigned NOT NULL,
814 `MAX_TIMER_READ_ONLY` bigint unsigned NOT NULL,
815 PRIMARY KEY (`EVENT_NAME`)
816 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
817 show create table events_waits_current;
818 Table Create Table
819 events_waits_current CREATE TABLE `events_waits_current` (
820 `THREAD_ID` bigint unsigned NOT NULL,
821 `EVENT_ID` bigint unsigned NOT NULL,
822 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
823 `EVENT_NAME` varchar(128) NOT NULL,
824 `SOURCE` varchar(64) DEFAULT NULL,
825 `TIMER_START` bigint unsigned DEFAULT NULL,
826 `TIMER_END` bigint unsigned DEFAULT NULL,
827 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
828 `SPINS` int unsigned DEFAULT NULL,
829 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
830 `OBJECT_NAME` varchar(512) DEFAULT NULL,
831 `INDEX_NAME` varchar(64) DEFAULT NULL,
832 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
833 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
834 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
835 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
836 `OPERATION` varchar(32) NOT NULL,
837 `NUMBER_OF_BYTES` bigint DEFAULT NULL,
838 `FLAGS` int unsigned DEFAULT NULL,
839 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
840 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
841 show create table events_waits_history;
842 Table Create Table
843 events_waits_history CREATE TABLE `events_waits_history` (
844 `THREAD_ID` bigint unsigned NOT NULL,
845 `EVENT_ID` bigint unsigned NOT NULL,
846 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
847 `EVENT_NAME` varchar(128) NOT NULL,
848 `SOURCE` varchar(64) DEFAULT NULL,
849 `TIMER_START` bigint unsigned DEFAULT NULL,
850 `TIMER_END` bigint unsigned DEFAULT NULL,
851 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
852 `SPINS` int unsigned DEFAULT NULL,
853 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
854 `OBJECT_NAME` varchar(512) DEFAULT NULL,
855 `INDEX_NAME` varchar(64) DEFAULT NULL,
856 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
857 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
858 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
859 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
860 `OPERATION` varchar(32) NOT NULL,
861 `NUMBER_OF_BYTES` bigint DEFAULT NULL,
862 `FLAGS` int unsigned DEFAULT NULL,
863 PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
864 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
865 show create table events_waits_history_long;
866 Table Create Table
867 events_waits_history_long CREATE TABLE `events_waits_history_long` (
868 `THREAD_ID` bigint unsigned NOT NULL,
869 `EVENT_ID` bigint unsigned NOT NULL,
870 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
871 `EVENT_NAME` varchar(128) NOT NULL,
872 `SOURCE` varchar(64) DEFAULT NULL,
873 `TIMER_START` bigint unsigned DEFAULT NULL,
874 `TIMER_END` bigint unsigned DEFAULT NULL,
875 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
876 `SPINS` int unsigned DEFAULT NULL,
877 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
878 `OBJECT_NAME` varchar(512) DEFAULT NULL,
879 `INDEX_NAME` varchar(64) DEFAULT NULL,
880 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
881 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
882 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
883 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
884 `OPERATION` varchar(32) NOT NULL,
885 `NUMBER_OF_BYTES` bigint DEFAULT NULL,
886 `FLAGS` int unsigned DEFAULT NULL
887 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
888 show create table events_waits_summary_by_host_by_event_name;
889 Table Create Table
890 events_waits_summary_by_host_by_event_name CREATE TABLE `events_waits_summary_by_host_by_event_name` (
891 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
892 `EVENT_NAME` varchar(128) NOT NULL,
893 `COUNT_STAR` bigint unsigned NOT NULL,
894 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
895 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
896 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
897 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
898 UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
899 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
900 show create table events_waits_summary_by_instance;
901 Table Create Table
902 events_waits_summary_by_instance CREATE TABLE `events_waits_summary_by_instance` (
903 `EVENT_NAME` varchar(128) NOT NULL,
904 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
905 `COUNT_STAR` bigint unsigned NOT NULL,
906 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
907 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
908 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
909 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
910 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
911 KEY `EVENT_NAME` (`EVENT_NAME`)
912 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
913 show create table events_waits_summary_by_thread_by_event_name;
914 Table Create Table
915 events_waits_summary_by_thread_by_event_name CREATE TABLE `events_waits_summary_by_thread_by_event_name` (
916 `THREAD_ID` bigint unsigned NOT NULL,
917 `EVENT_NAME` varchar(128) NOT NULL,
918 `COUNT_STAR` bigint unsigned NOT NULL,
919 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
920 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
921 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
922 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
923 PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
924 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
925 show create table events_waits_summary_by_user_by_event_name;
926 Table Create Table
927 events_waits_summary_by_user_by_event_name CREATE TABLE `events_waits_summary_by_user_by_event_name` (
928 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
929 `EVENT_NAME` varchar(128) NOT NULL,
930 `COUNT_STAR` bigint unsigned NOT NULL,
931 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
932 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
933 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
934 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
935 UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
936 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
937 show create table events_waits_summary_by_account_by_event_name;
938 Table Create Table
939 events_waits_summary_by_account_by_event_name CREATE TABLE `events_waits_summary_by_account_by_event_name` (
940 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
941 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
942 `EVENT_NAME` varchar(128) NOT NULL,
943 `COUNT_STAR` bigint unsigned NOT NULL,
944 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
945 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
946 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
947 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
948 UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
949 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
950 show create table events_waits_summary_global_by_event_name;
951 Table Create Table
952 events_waits_summary_global_by_event_name CREATE TABLE `events_waits_summary_global_by_event_name` (
953 `EVENT_NAME` varchar(128) NOT NULL,
954 `COUNT_STAR` bigint unsigned NOT NULL,
955 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
956 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
957 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
958 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
959 PRIMARY KEY (`EVENT_NAME`)
960 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
961 show create table memory_summary_by_host_by_event_name;
962 Table Create Table
963 memory_summary_by_host_by_event_name CREATE TABLE `memory_summary_by_host_by_event_name` (
964 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
965 `EVENT_NAME` varchar(128) NOT NULL,
966 `COUNT_ALLOC` bigint unsigned NOT NULL,
967 `COUNT_FREE` bigint unsigned NOT NULL,
968 `SUM_NUMBER_OF_BYTES_ALLOC` bigint unsigned NOT NULL,
969 `SUM_NUMBER_OF_BYTES_FREE` bigint unsigned NOT NULL,
970 `LOW_COUNT_USED` bigint NOT NULL,
971 `CURRENT_COUNT_USED` bigint NOT NULL,
972 `HIGH_COUNT_USED` bigint NOT NULL,
973 `LOW_NUMBER_OF_BYTES_USED` bigint NOT NULL,
974 `CURRENT_NUMBER_OF_BYTES_USED` bigint NOT NULL,
975 `HIGH_NUMBER_OF_BYTES_USED` bigint NOT NULL,
976 UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
977 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
978 show create table memory_summary_by_thread_by_event_name;
979 Table Create Table
980 memory_summary_by_thread_by_event_name CREATE TABLE `memory_summary_by_thread_by_event_name` (
981 `THREAD_ID` bigint unsigned NOT NULL,
982 `EVENT_NAME` varchar(128) NOT NULL,
983 `COUNT_ALLOC` bigint unsigned NOT NULL,
984 `COUNT_FREE` bigint unsigned NOT NULL,
985 `SUM_NUMBER_OF_BYTES_ALLOC` bigint unsigned NOT NULL,
986 `SUM_NUMBER_OF_BYTES_FREE` bigint unsigned NOT NULL,
987 `LOW_COUNT_USED` bigint NOT NULL,
988 `CURRENT_COUNT_USED` bigint NOT NULL,
989 `HIGH_COUNT_USED` bigint NOT NULL,
990 `LOW_NUMBER_OF_BYTES_USED` bigint NOT NULL,
991 `CURRENT_NUMBER_OF_BYTES_USED` bigint NOT NULL,
992 `HIGH_NUMBER_OF_BYTES_USED` bigint NOT NULL,
993 PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
994 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
995 show create table memory_summary_by_user_by_event_name;
996 Table Create Table
997 memory_summary_by_user_by_event_name CREATE TABLE `memory_summary_by_user_by_event_name` (
998 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
999 `EVENT_NAME` varchar(128) NOT NULL,
1000 `COUNT_ALLOC` bigint unsigned NOT NULL,
1001 `COUNT_FREE` bigint unsigned NOT NULL,
1002 `SUM_NUMBER_OF_BYTES_ALLOC` bigint unsigned NOT NULL,
1003 `SUM_NUMBER_OF_BYTES_FREE` bigint unsigned NOT NULL,
1004 `LOW_COUNT_USED` bigint NOT NULL,
1005 `CURRENT_COUNT_USED` bigint NOT NULL,
1006 `HIGH_COUNT_USED` bigint NOT NULL,
1007 `LOW_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1008 `CURRENT_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1009 `HIGH_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1010 UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
1011 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1012 show create table memory_summary_by_account_by_event_name;
1013 Table Create Table
1014 memory_summary_by_account_by_event_name CREATE TABLE `memory_summary_by_account_by_event_name` (
1015 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
1016 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
1017 `EVENT_NAME` varchar(128) NOT NULL,
1018 `COUNT_ALLOC` bigint unsigned NOT NULL,
1019 `COUNT_FREE` bigint unsigned NOT NULL,
1020 `SUM_NUMBER_OF_BYTES_ALLOC` bigint unsigned NOT NULL,
1021 `SUM_NUMBER_OF_BYTES_FREE` bigint unsigned NOT NULL,
1022 `LOW_COUNT_USED` bigint NOT NULL,
1023 `CURRENT_COUNT_USED` bigint NOT NULL,
1024 `HIGH_COUNT_USED` bigint NOT NULL,
1025 `LOW_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1026 `CURRENT_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1027 `HIGH_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1028 UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
1029 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1030 show create table memory_summary_global_by_event_name;
1031 Table Create Table
1032 memory_summary_global_by_event_name CREATE TABLE `memory_summary_global_by_event_name` (
1033 `EVENT_NAME` varchar(128) NOT NULL,
1034 `COUNT_ALLOC` bigint unsigned NOT NULL,
1035 `COUNT_FREE` bigint unsigned NOT NULL,
1036 `SUM_NUMBER_OF_BYTES_ALLOC` bigint unsigned NOT NULL,
1037 `SUM_NUMBER_OF_BYTES_FREE` bigint unsigned NOT NULL,
1038 `LOW_COUNT_USED` bigint NOT NULL,
1039 `CURRENT_COUNT_USED` bigint NOT NULL,
1040 `HIGH_COUNT_USED` bigint NOT NULL,
1041 `LOW_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1042 `CURRENT_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1043 `HIGH_NUMBER_OF_BYTES_USED` bigint NOT NULL,
1044 PRIMARY KEY (`EVENT_NAME`)
1045 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1046 show create table metadata_locks;
1047 Table Create Table
1048 metadata_locks CREATE TABLE `metadata_locks` (
1049 `OBJECT_TYPE` varchar(64) NOT NULL,
1050 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
1051 `OBJECT_NAME` varchar(64) DEFAULT NULL,
1052 `COLUMN_NAME` varchar(64) DEFAULT NULL,
1053 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1054 `LOCK_TYPE` varchar(32) NOT NULL,
1055 `LOCK_DURATION` varchar(32) NOT NULL,
1056 `LOCK_STATUS` varchar(32) NOT NULL,
1057 `SOURCE` varchar(64) DEFAULT NULL,
1058 `OWNER_THREAD_ID` bigint unsigned DEFAULT NULL,
1059 `OWNER_EVENT_ID` bigint unsigned DEFAULT NULL,
1060 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1061 KEY `OBJECT_TYPE` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`,`COLUMN_NAME`),
1062 KEY `OWNER_THREAD_ID` (`OWNER_THREAD_ID`,`OWNER_EVENT_ID`)
1063 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1064 show create table file_instances;
1065 Table Create Table
1066 file_instances CREATE TABLE `file_instances` (
1067 `FILE_NAME` varchar(512) NOT NULL,
1068 `EVENT_NAME` varchar(128) NOT NULL,
1069 `OPEN_COUNT` int unsigned NOT NULL,
1070 PRIMARY KEY (`FILE_NAME`),
1071 KEY `EVENT_NAME` (`EVENT_NAME`)
1072 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1073 show create table file_summary_by_event_name;
1074 Table Create Table
1075 file_summary_by_event_name CREATE TABLE `file_summary_by_event_name` (
1076 `EVENT_NAME` varchar(128) NOT NULL,
1077 `COUNT_STAR` bigint unsigned NOT NULL,
1078 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1079 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1080 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1081 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1082 `COUNT_READ` bigint unsigned NOT NULL,
1083 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1084 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1085 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1086 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1087 `SUM_NUMBER_OF_BYTES_READ` bigint NOT NULL,
1088 `COUNT_WRITE` bigint unsigned NOT NULL,
1089 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1090 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1091 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1092 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1093 `SUM_NUMBER_OF_BYTES_WRITE` bigint NOT NULL,
1094 `COUNT_MISC` bigint unsigned NOT NULL,
1095 `SUM_TIMER_MISC` bigint unsigned NOT NULL,
1096 `MIN_TIMER_MISC` bigint unsigned NOT NULL,
1097 `AVG_TIMER_MISC` bigint unsigned NOT NULL,
1098 `MAX_TIMER_MISC` bigint unsigned NOT NULL,
1099 PRIMARY KEY (`EVENT_NAME`)
1100 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1101 show create table file_summary_by_instance;
1102 Table Create Table
1103 file_summary_by_instance CREATE TABLE `file_summary_by_instance` (
1104 `FILE_NAME` varchar(512) NOT NULL,
1105 `EVENT_NAME` varchar(128) NOT NULL,
1106 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1107 `COUNT_STAR` bigint unsigned NOT NULL,
1108 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1109 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1110 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1111 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1112 `COUNT_READ` bigint unsigned NOT NULL,
1113 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1114 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1115 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1116 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1117 `SUM_NUMBER_OF_BYTES_READ` bigint NOT NULL,
1118 `COUNT_WRITE` bigint unsigned NOT NULL,
1119 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1120 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1121 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1122 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1123 `SUM_NUMBER_OF_BYTES_WRITE` bigint NOT NULL,
1124 `COUNT_MISC` bigint unsigned NOT NULL,
1125 `SUM_TIMER_MISC` bigint unsigned NOT NULL,
1126 `MIN_TIMER_MISC` bigint unsigned NOT NULL,
1127 `AVG_TIMER_MISC` bigint unsigned NOT NULL,
1128 `MAX_TIMER_MISC` bigint unsigned NOT NULL,
1129 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1130 KEY `FILE_NAME` (`FILE_NAME`),
1131 KEY `EVENT_NAME` (`EVENT_NAME`)
1132 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1133 show create table host_cache;
1134 Table Create Table
1135 host_cache CREATE TABLE `host_cache` (
1136 `IP` varchar(64) NOT NULL,
1137 `HOST` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
1138 `HOST_VALIDATED` enum('YES','NO') NOT NULL,
1139 `SUM_CONNECT_ERRORS` bigint NOT NULL,
1140 `COUNT_HOST_BLOCKED_ERRORS` bigint NOT NULL,
1141 `COUNT_NAMEINFO_TRANSIENT_ERRORS` bigint NOT NULL,
1142 `COUNT_NAMEINFO_PERMANENT_ERRORS` bigint NOT NULL,
1143 `COUNT_FORMAT_ERRORS` bigint NOT NULL,
1144 `COUNT_ADDRINFO_TRANSIENT_ERRORS` bigint NOT NULL,
1145 `COUNT_ADDRINFO_PERMANENT_ERRORS` bigint NOT NULL,
1146 `COUNT_FCRDNS_ERRORS` bigint NOT NULL,
1147 `COUNT_HOST_ACL_ERRORS` bigint NOT NULL,
1148 `COUNT_NO_AUTH_PLUGIN_ERRORS` bigint NOT NULL,
1149 `COUNT_AUTH_PLUGIN_ERRORS` bigint NOT NULL,
1150 `COUNT_HANDSHAKE_ERRORS` bigint NOT NULL,
1151 `COUNT_PROXY_USER_ERRORS` bigint NOT NULL,
1152 `COUNT_PROXY_USER_ACL_ERRORS` bigint NOT NULL,
1153 `COUNT_AUTHENTICATION_ERRORS` bigint NOT NULL,
1154 `COUNT_SSL_ERRORS` bigint NOT NULL,
1155 `COUNT_MAX_USER_CONNECTIONS_ERRORS` bigint NOT NULL,
1156 `COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS` bigint NOT NULL,
1157 `COUNT_DEFAULT_DATABASE_ERRORS` bigint NOT NULL,
1158 `COUNT_INIT_CONNECT_ERRORS` bigint NOT NULL,
1159 `COUNT_LOCAL_ERRORS` bigint NOT NULL,
1160 `COUNT_UNKNOWN_ERRORS` bigint NOT NULL,
1161 `FIRST_SEEN` timestamp NOT NULL,
1162 `LAST_SEEN` timestamp NOT NULL,
1163 `FIRST_ERROR_SEEN` timestamp NULL DEFAULT NULL,
1164 `LAST_ERROR_SEEN` timestamp NULL DEFAULT NULL,
1165 PRIMARY KEY (`IP`),
1166 KEY `HOST` (`HOST`)
1167 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1168 show create table hosts;
1169 Table Create Table
1170 hosts CREATE TABLE `hosts` (
1171 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
1172 `CURRENT_CONNECTIONS` bigint NOT NULL,
1173 `TOTAL_CONNECTIONS` bigint NOT NULL,
1174 `MAX_SESSION_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
1175 `MAX_SESSION_TOTAL_MEMORY` bigint unsigned NOT NULL,
1176 UNIQUE KEY `HOST` (`HOST`)
1177 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1178 show create table mutex_instances;
1179 Table Create Table
1180 mutex_instances CREATE TABLE `mutex_instances` (
1181 `NAME` varchar(128) NOT NULL,
1182 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1183 `LOCKED_BY_THREAD_ID` bigint unsigned DEFAULT NULL,
1184 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1185 KEY `NAME` (`NAME`),
1186 KEY `LOCKED_BY_THREAD_ID` (`LOCKED_BY_THREAD_ID`)
1187 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1188 show create table objects_summary_global_by_type;
1189 Table Create Table
1190 objects_summary_global_by_type CREATE TABLE `objects_summary_global_by_type` (
1191 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
1192 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
1193 `OBJECT_NAME` varchar(64) DEFAULT NULL,
1194 `COUNT_STAR` bigint unsigned NOT NULL,
1195 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1196 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1197 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1198 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1199 UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
1200 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1201 show create table performance_timers;
1202 Table Create Table
1203 performance_timers CREATE TABLE `performance_timers` (
1204 `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','THREAD_CPU') NOT NULL,
1205 `TIMER_FREQUENCY` bigint DEFAULT NULL,
1206 `TIMER_RESOLUTION` bigint DEFAULT NULL,
1207 `TIMER_OVERHEAD` bigint DEFAULT NULL
1208 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1209 show create table data_locks;
1210 Table Create Table
1211 data_locks CREATE TABLE `data_locks` (
1212 `ENGINE` varchar(32) NOT NULL,
1213 `ENGINE_LOCK_ID` varchar(128) NOT NULL,
1214 `ENGINE_TRANSACTION_ID` bigint unsigned DEFAULT NULL,
1215 `THREAD_ID` bigint unsigned DEFAULT NULL,
1216 `EVENT_ID` bigint unsigned DEFAULT NULL,
1217 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
1218 `OBJECT_NAME` varchar(64) DEFAULT NULL,
1219 `PARTITION_NAME` varchar(64) DEFAULT NULL,
1220 `SUBPARTITION_NAME` varchar(64) DEFAULT NULL,
1221 `INDEX_NAME` varchar(64) DEFAULT NULL,
1222 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1223 `LOCK_TYPE` varchar(32) NOT NULL,
1224 `LOCK_MODE` varchar(32) NOT NULL,
1225 `LOCK_STATUS` varchar(32) NOT NULL,
1226 `LOCK_DATA` varchar(8192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
1227 PRIMARY KEY (`ENGINE_LOCK_ID`,`ENGINE`),
1228 KEY `ENGINE_TRANSACTION_ID` (`ENGINE_TRANSACTION_ID`,`ENGINE`),
1229 KEY `THREAD_ID` (`THREAD_ID`,`EVENT_ID`),
1230 KEY `OBJECT_SCHEMA` (`OBJECT_SCHEMA`,`OBJECT_NAME`,`PARTITION_NAME`,`SUBPARTITION_NAME`)
1231 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1232 show create table data_lock_waits;
1233 Table Create Table
1234 data_lock_waits CREATE TABLE `data_lock_waits` (
1235 `ENGINE` varchar(32) NOT NULL,
1236 `REQUESTING_ENGINE_LOCK_ID` varchar(128) NOT NULL,
1237 `REQUESTING_ENGINE_TRANSACTION_ID` bigint unsigned DEFAULT NULL,
1238 `REQUESTING_THREAD_ID` bigint unsigned DEFAULT NULL,
1239 `REQUESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
1240 `REQUESTING_OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1241 `BLOCKING_ENGINE_LOCK_ID` varchar(128) NOT NULL,
1242 `BLOCKING_ENGINE_TRANSACTION_ID` bigint unsigned DEFAULT NULL,
1243 `BLOCKING_THREAD_ID` bigint unsigned DEFAULT NULL,
1244 `BLOCKING_EVENT_ID` bigint unsigned DEFAULT NULL,
1245 `BLOCKING_OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1246 PRIMARY KEY (`REQUESTING_ENGINE_LOCK_ID`,`BLOCKING_ENGINE_LOCK_ID`,`ENGINE`),
1247 KEY `REQUESTING_ENGINE_LOCK_ID` (`REQUESTING_ENGINE_LOCK_ID`,`ENGINE`),
1248 KEY `BLOCKING_ENGINE_LOCK_ID` (`BLOCKING_ENGINE_LOCK_ID`,`ENGINE`),
1249 KEY `REQUESTING_ENGINE_TRANSACTION_ID` (`REQUESTING_ENGINE_TRANSACTION_ID`,`ENGINE`),
1250 KEY `BLOCKING_ENGINE_TRANSACTION_ID` (`BLOCKING_ENGINE_TRANSACTION_ID`,`ENGINE`),
1251 KEY `REQUESTING_THREAD_ID` (`REQUESTING_THREAD_ID`,`REQUESTING_EVENT_ID`),
1252 KEY `BLOCKING_THREAD_ID` (`BLOCKING_THREAD_ID`,`BLOCKING_EVENT_ID`)
1253 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1254 show create table rwlock_instances;
1255 Table Create Table
1256 rwlock_instances CREATE TABLE `rwlock_instances` (
1257 `NAME` varchar(128) NOT NULL,
1258 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1259 `WRITE_LOCKED_BY_THREAD_ID` bigint unsigned DEFAULT NULL,
1260 `READ_LOCKED_BY_COUNT` int unsigned NOT NULL,
1261 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1262 KEY `NAME` (`NAME`),
1263 KEY `WRITE_LOCKED_BY_THREAD_ID` (`WRITE_LOCKED_BY_THREAD_ID`)
1264 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1265 show create table setup_actors;
1266 Table Create Table
1267 setup_actors CREATE TABLE `setup_actors` (
1268 `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '%',
1269 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '%',
1270 `ROLE` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '%',
1271 `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES',
1272 `HISTORY` enum('YES','NO') NOT NULL DEFAULT 'YES',
1273 PRIMARY KEY (`HOST`,`USER`,`ROLE`)
1274 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1275 show create table setup_consumers;
1276 Table Create Table
1277 setup_consumers CREATE TABLE `setup_consumers` (
1278 `NAME` varchar(64) NOT NULL,
1279 `ENABLED` enum('YES','NO') NOT NULL,
1280 PRIMARY KEY (`NAME`)
1281 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1282 show create table setup_instruments;
1283 Table Create Table
1284 setup_instruments CREATE TABLE `setup_instruments` (
1285 `NAME` varchar(128) NOT NULL,
1286 `ENABLED` enum('YES','NO') NOT NULL,
1287 `TIMED` enum('YES','NO') DEFAULT NULL,
1288 `PROPERTIES` set('singleton','progress','user','global_statistics','mutable','controlled_by_default') NOT NULL,
1289 `FLAGS` set('controlled') DEFAULT NULL,
1290 `VOLATILITY` int NOT NULL,
1291 `DOCUMENTATION` longtext,
1292 PRIMARY KEY (`NAME`)
1293 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1294 show create table setup_objects;
1295 Table Create Table
1296 setup_objects CREATE TABLE `setup_objects` (
1297 `OBJECT_TYPE` enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER') NOT NULL DEFAULT 'TABLE',
1298 `OBJECT_SCHEMA` varchar(64) DEFAULT '%',
1299 `OBJECT_NAME` varchar(64) NOT NULL DEFAULT '%',
1300 `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES',
1301 `TIMED` enum('YES','NO') NOT NULL DEFAULT 'YES',
1302 UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
1303 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1304 show create table socket_instances;
1305 Table Create Table
1306 socket_instances CREATE TABLE `socket_instances` (
1307 `EVENT_NAME` varchar(128) NOT NULL,
1308 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1309 `THREAD_ID` bigint unsigned DEFAULT NULL,
1310 `SOCKET_ID` int NOT NULL,
1311 `IP` varchar(64) NOT NULL,
1312 `PORT` int NOT NULL,
1313 `STATE` enum('IDLE','ACTIVE') NOT NULL,
1314 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1315 KEY `THREAD_ID` (`THREAD_ID`),
1316 KEY `SOCKET_ID` (`SOCKET_ID`),
1317 KEY `IP` (`IP`,`PORT`)
1318 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1319 show create table socket_summary_by_instance;
1320 Table Create Table
1321 socket_summary_by_instance CREATE TABLE `socket_summary_by_instance` (
1322 `EVENT_NAME` varchar(128) NOT NULL,
1323 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1324 `COUNT_STAR` bigint unsigned NOT NULL,
1325 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1326 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1327 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1328 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1329 `COUNT_READ` bigint unsigned NOT NULL,
1330 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1331 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1332 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1333 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1334 `SUM_NUMBER_OF_BYTES_READ` bigint unsigned NOT NULL,
1335 `COUNT_WRITE` bigint unsigned NOT NULL,
1336 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1337 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1338 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1339 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1340 `SUM_NUMBER_OF_BYTES_WRITE` bigint unsigned NOT NULL,
1341 `COUNT_MISC` bigint unsigned NOT NULL,
1342 `SUM_TIMER_MISC` bigint unsigned NOT NULL,
1343 `MIN_TIMER_MISC` bigint unsigned NOT NULL,
1344 `AVG_TIMER_MISC` bigint unsigned NOT NULL,
1345 `MAX_TIMER_MISC` bigint unsigned NOT NULL,
1346 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1347 KEY `EVENT_NAME` (`EVENT_NAME`)
1348 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1349 show create table socket_summary_by_event_name;
1350 Table Create Table
1351 socket_summary_by_event_name CREATE TABLE `socket_summary_by_event_name` (
1352 `EVENT_NAME` varchar(128) NOT NULL,
1353 `COUNT_STAR` bigint unsigned NOT NULL,
1354 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1355 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1356 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1357 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1358 `COUNT_READ` bigint unsigned NOT NULL,
1359 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1360 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1361 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1362 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1363 `SUM_NUMBER_OF_BYTES_READ` bigint unsigned NOT NULL,
1364 `COUNT_WRITE` bigint unsigned NOT NULL,
1365 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1366 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1367 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1368 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1369 `SUM_NUMBER_OF_BYTES_WRITE` bigint unsigned NOT NULL,
1370 `COUNT_MISC` bigint unsigned NOT NULL,
1371 `SUM_TIMER_MISC` bigint unsigned NOT NULL,
1372 `MIN_TIMER_MISC` bigint unsigned NOT NULL,
1373 `AVG_TIMER_MISC` bigint unsigned NOT NULL,
1374 `MAX_TIMER_MISC` bigint unsigned NOT NULL,
1375 PRIMARY KEY (`EVENT_NAME`)
1376 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1377 show create table table_handles;
1378 Table Create Table
1379 table_handles CREATE TABLE `table_handles` (
1380 `OBJECT_TYPE` varchar(64) NOT NULL,
1381 `OBJECT_SCHEMA` varchar(64) NOT NULL,
1382 `OBJECT_NAME` varchar(64) NOT NULL,
1383 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
1384 `OWNER_THREAD_ID` bigint unsigned DEFAULT NULL,
1385 `OWNER_EVENT_ID` bigint unsigned DEFAULT NULL,
1386 `INTERNAL_LOCK` varchar(64) DEFAULT NULL,
1387 `EXTERNAL_LOCK` varchar(64) DEFAULT NULL,
1388 PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
1389 KEY `OBJECT_TYPE` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`),
1390 KEY `OWNER_THREAD_ID` (`OWNER_THREAD_ID`,`OWNER_EVENT_ID`)
1391 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1392 show create table table_io_waits_summary_by_index_usage;
1393 Table Create Table
1394 table_io_waits_summary_by_index_usage CREATE TABLE `table_io_waits_summary_by_index_usage` (
1395 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
1396 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
1397 `OBJECT_NAME` varchar(64) DEFAULT NULL,
1398 `INDEX_NAME` varchar(64) DEFAULT NULL,
1399 `COUNT_STAR` bigint unsigned NOT NULL,
1400 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1401 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1402 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1403 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1404 `COUNT_READ` bigint unsigned NOT NULL,
1405 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1406 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1407 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1408 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1409 `COUNT_WRITE` bigint unsigned NOT NULL,
1410 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1411 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1412 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1413 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1414 `COUNT_FETCH` bigint unsigned NOT NULL,
1415 `SUM_TIMER_FETCH` bigint unsigned NOT NULL,
1416 `MIN_TIMER_FETCH` bigint unsigned NOT NULL,
1417 `AVG_TIMER_FETCH` bigint unsigned NOT NULL,
1418 `MAX_TIMER_FETCH` bigint unsigned NOT NULL,
1419 `COUNT_INSERT` bigint unsigned NOT NULL,
1420 `SUM_TIMER_INSERT` bigint unsigned NOT NULL,
1421 `MIN_TIMER_INSERT` bigint unsigned NOT NULL,
1422 `AVG_TIMER_INSERT` bigint unsigned NOT NULL,
1423 `MAX_TIMER_INSERT` bigint unsigned NOT NULL,
1424 `COUNT_UPDATE` bigint unsigned NOT NULL,
1425 `SUM_TIMER_UPDATE` bigint unsigned NOT NULL,
1426 `MIN_TIMER_UPDATE` bigint unsigned NOT NULL,
1427 `AVG_TIMER_UPDATE` bigint unsigned NOT NULL,
1428 `MAX_TIMER_UPDATE` bigint unsigned NOT NULL,
1429 `COUNT_DELETE` bigint unsigned NOT NULL,
1430 `SUM_TIMER_DELETE` bigint unsigned NOT NULL,
1431 `MIN_TIMER_DELETE` bigint unsigned NOT NULL,
1432 `AVG_TIMER_DELETE` bigint unsigned NOT NULL,
1433 `MAX_TIMER_DELETE` bigint unsigned NOT NULL,
1434 UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`,`INDEX_NAME`)
1435 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1436 show create table table_io_waits_summary_by_table;
1437 Table Create Table
1438 table_io_waits_summary_by_table CREATE TABLE `table_io_waits_summary_by_table` (
1439 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
1440 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
1441 `OBJECT_NAME` varchar(64) DEFAULT NULL,
1442 `COUNT_STAR` bigint unsigned NOT NULL,
1443 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1444 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1445 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1446 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1447 `COUNT_READ` bigint unsigned NOT NULL,
1448 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1449 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1450 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1451 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1452 `COUNT_WRITE` bigint unsigned NOT NULL,
1453 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1454 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1455 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1456 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1457 `COUNT_FETCH` bigint unsigned NOT NULL,
1458 `SUM_TIMER_FETCH` bigint unsigned NOT NULL,
1459 `MIN_TIMER_FETCH` bigint unsigned NOT NULL,
1460 `AVG_TIMER_FETCH` bigint unsigned NOT NULL,
1461 `MAX_TIMER_FETCH` bigint unsigned NOT NULL,
1462 `COUNT_INSERT` bigint unsigned NOT NULL,
1463 `SUM_TIMER_INSERT` bigint unsigned NOT NULL,
1464 `MIN_TIMER_INSERT` bigint unsigned NOT NULL,
1465 `AVG_TIMER_INSERT` bigint unsigned NOT NULL,
1466 `MAX_TIMER_INSERT` bigint unsigned NOT NULL,
1467 `COUNT_UPDATE` bigint unsigned NOT NULL,
1468 `SUM_TIMER_UPDATE` bigint unsigned NOT NULL,
1469 `MIN_TIMER_UPDATE` bigint unsigned NOT NULL,
1470 `AVG_TIMER_UPDATE` bigint unsigned NOT NULL,
1471 `MAX_TIMER_UPDATE` bigint unsigned NOT NULL,
1472 `COUNT_DELETE` bigint unsigned NOT NULL,
1473 `SUM_TIMER_DELETE` bigint unsigned NOT NULL,
1474 `MIN_TIMER_DELETE` bigint unsigned NOT NULL,
1475 `AVG_TIMER_DELETE` bigint unsigned NOT NULL,
1476 `MAX_TIMER_DELETE` bigint unsigned NOT NULL,
1477 UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
1478 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1479 show create table table_lock_waits_summary_by_table;
1480 Table Create Table
1481 table_lock_waits_summary_by_table CREATE TABLE `table_lock_waits_summary_by_table` (
1482 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
1483 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
1484 `OBJECT_NAME` varchar(64) DEFAULT NULL,
1485 `COUNT_STAR` bigint unsigned NOT NULL,
1486 `SUM_TIMER_WAIT` bigint unsigned NOT NULL,
1487 `MIN_TIMER_WAIT` bigint unsigned NOT NULL,
1488 `AVG_TIMER_WAIT` bigint unsigned NOT NULL,
1489 `MAX_TIMER_WAIT` bigint unsigned NOT NULL,
1490 `COUNT_READ` bigint unsigned NOT NULL,
1491 `SUM_TIMER_READ` bigint unsigned NOT NULL,
1492 `MIN_TIMER_READ` bigint unsigned NOT NULL,
1493 `AVG_TIMER_READ` bigint unsigned NOT NULL,
1494 `MAX_TIMER_READ` bigint unsigned NOT NULL,
1495 `COUNT_WRITE` bigint unsigned NOT NULL,
1496 `SUM_TIMER_WRITE` bigint unsigned NOT NULL,
1497 `MIN_TIMER_WRITE` bigint unsigned NOT NULL,
1498 `AVG_TIMER_WRITE` bigint unsigned NOT NULL,
1499 `MAX_TIMER_WRITE` bigint unsigned NOT NULL,
1500 `COUNT_READ_NORMAL` bigint unsigned NOT NULL,
1501 `SUM_TIMER_READ_NORMAL` bigint unsigned NOT NULL,
1502 `MIN_TIMER_READ_NORMAL` bigint unsigned NOT NULL,
1503 `AVG_TIMER_READ_NORMAL` bigint unsigned NOT NULL,
1504 `MAX_TIMER_READ_NORMAL` bigint unsigned NOT NULL,
1505 `COUNT_READ_WITH_SHARED_LOCKS` bigint unsigned NOT NULL,
1506 `SUM_TIMER_READ_WITH_SHARED_LOCKS` bigint unsigned NOT NULL,
1507 `MIN_TIMER_READ_WITH_SHARED_LOCKS` bigint unsigned NOT NULL,
1508 `AVG_TIMER_READ_WITH_SHARED_LOCKS` bigint unsigned NOT NULL,
1509 `MAX_TIMER_READ_WITH_SHARED_LOCKS` bigint unsigned NOT NULL,
1510 `COUNT_READ_HIGH_PRIORITY` bigint unsigned NOT NULL,
1511 `SUM_TIMER_READ_HIGH_PRIORITY` bigint unsigned NOT NULL,
1512 `MIN_TIMER_READ_HIGH_PRIORITY` bigint unsigned NOT NULL,
1513 `AVG_TIMER_READ_HIGH_PRIORITY` bigint unsigned NOT NULL,
1514 `MAX_TIMER_READ_HIGH_PRIORITY` bigint unsigned NOT NULL,
1515 `COUNT_READ_NO_INSERT` bigint unsigned NOT NULL,
1516 `SUM_TIMER_READ_NO_INSERT` bigint unsigned NOT NULL,
1517 `MIN_TIMER_READ_NO_INSERT` bigint unsigned NOT NULL,
1518 `AVG_TIMER_READ_NO_INSERT` bigint unsigned NOT NULL,
1519 `MAX_TIMER_READ_NO_INSERT` bigint unsigned NOT NULL,
1520 `COUNT_READ_EXTERNAL` bigint unsigned NOT NULL,
1521 `SUM_TIMER_READ_EXTERNAL` bigint unsigned NOT NULL,
1522 `MIN_TIMER_READ_EXTERNAL` bigint unsigned NOT NULL,
1523 `AVG_TIMER_READ_EXTERNAL` bigint unsigned NOT NULL,
1524 `MAX_TIMER_READ_EXTERNAL` bigint unsigned NOT NULL,
1525 `COUNT_WRITE_ALLOW_WRITE` bigint unsigned NOT NULL,
1526 `SUM_TIMER_WRITE_ALLOW_WRITE` bigint unsigned NOT NULL,
1527 `MIN_TIMER_WRITE_ALLOW_WRITE` bigint unsigned NOT NULL,
1528 `AVG_TIMER_WRITE_ALLOW_WRITE` bigint unsigned NOT NULL,
1529 `MAX_TIMER_WRITE_ALLOW_WRITE` bigint unsigned NOT NULL,
1530 `COUNT_WRITE_CONCURRENT_INSERT` bigint unsigned NOT NULL,
1531 `SUM_TIMER_WRITE_CONCURRENT_INSERT` bigint unsigned NOT NULL,
1532 `MIN_TIMER_WRITE_CONCURRENT_INSERT` bigint unsigned NOT NULL,
1533 `AVG_TIMER_WRITE_CONCURRENT_INSERT` bigint unsigned NOT NULL,
1534 `MAX_TIMER_WRITE_CONCURRENT_INSERT` bigint unsigned NOT NULL,
1535 `COUNT_WRITE_LOW_PRIORITY` bigint unsigned NOT NULL,
1536 `SUM_TIMER_WRITE_LOW_PRIORITY` bigint unsigned NOT NULL,
1537 `MIN_TIMER_WRITE_LOW_PRIORITY` bigint unsigned NOT NULL,
1538 `AVG_TIMER_WRITE_LOW_PRIORITY` bigint unsigned NOT NULL,
1539 `MAX_TIMER_WRITE_LOW_PRIORITY` bigint unsigned NOT NULL,
1540 `COUNT_WRITE_NORMAL` bigint unsigned NOT NULL,
1541 `SUM_TIMER_WRITE_NORMAL` bigint unsigned NOT NULL,
1542 `MIN_TIMER_WRITE_NORMAL` bigint unsigned NOT NULL,
1543 `AVG_TIMER_WRITE_NORMAL` bigint unsigned NOT NULL,
1544 `MAX_TIMER_WRITE_NORMAL` bigint unsigned NOT NULL,
1545 `COUNT_WRITE_EXTERNAL` bigint unsigned NOT NULL,
1546 `SUM_TIMER_WRITE_EXTERNAL` bigint unsigned NOT NULL,
1547 `MIN_TIMER_WRITE_EXTERNAL` bigint unsigned NOT NULL,
1548 `AVG_TIMER_WRITE_EXTERNAL` bigint unsigned NOT NULL,
1549 `MAX_TIMER_WRITE_EXTERNAL` bigint unsigned NOT NULL,
1550 UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
1551 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1552 show create table threads;
1553 Table Create Table
1554 threads CREATE TABLE `threads` (
1555 `THREAD_ID` bigint unsigned NOT NULL,
1556 `NAME` varchar(128) NOT NULL,
1557 `TYPE` varchar(10) NOT NULL,
1558 `PROCESSLIST_ID` bigint unsigned DEFAULT NULL,
1559 `PROCESSLIST_USER` varchar(32) DEFAULT NULL,
1560 `PROCESSLIST_HOST` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
1561 `PROCESSLIST_DB` varchar(64) DEFAULT NULL,
1562 `PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL,
1563 `PROCESSLIST_TIME` bigint DEFAULT NULL,
1564 `PROCESSLIST_STATE` varchar(64) DEFAULT NULL,
1565 `PROCESSLIST_INFO` longtext,
1566 `PARENT_THREAD_ID` bigint unsigned DEFAULT NULL,
1567 `ROLE` varchar(64) DEFAULT NULL,
1568 `INSTRUMENTED` enum('YES','NO') NOT NULL,
1569 `HISTORY` enum('YES','NO') NOT NULL,
1570 `CONNECTION_TYPE` varchar(16) DEFAULT NULL,
1571 `THREAD_OS_ID` bigint unsigned DEFAULT NULL,
1572 `RESOURCE_GROUP` varchar(64) DEFAULT NULL,
1573 `EXECUTION_ENGINE` enum('PRIMARY','SECONDARY') DEFAULT NULL,
1574 `CONTROLLED_MEMORY` bigint unsigned NOT NULL,
1575 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
1576 `TOTAL_MEMORY` bigint unsigned NOT NULL,
1577 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
1578 `TELEMETRY_ACTIVE` enum('YES','NO') NOT NULL,
1579 PRIMARY KEY (`THREAD_ID`),
1580 KEY `PROCESSLIST_ID` (`PROCESSLIST_ID`),
1581 KEY `THREAD_OS_ID` (`THREAD_OS_ID`),
1582 KEY `NAME` (`NAME`),
1583 KEY `PROCESSLIST_ACCOUNT` (`PROCESSLIST_USER`,`PROCESSLIST_HOST`),
1584 KEY `PROCESSLIST_HOST` (`PROCESSLIST_HOST`),
1585 KEY `RESOURCE_GROUP` (`RESOURCE_GROUP`)
1586 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1587 show create table users;
1588 Table Create Table
1589 users CREATE TABLE `users` (
1590 `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
1591 `CURRENT_CONNECTIONS` bigint NOT NULL,
1592 `TOTAL_CONNECTIONS` bigint NOT NULL,
1593 `MAX_SESSION_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
1594 `MAX_SESSION_TOTAL_MEMORY` bigint unsigned NOT NULL,
1595 UNIQUE KEY `USER` (`USER`)
1596 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci