1show databases like 'performance_schema';
2Database (performance_schema)
3performance_schema
4show create database performance_schema;
5Database	Create Database
6performance_schema	CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8 */
7use performance_schema;
8show tables;
9Tables_in_performance_schema
10accounts
11cond_instances
12events_stages_current
13events_stages_history
14events_stages_history_long
15events_stages_summary_by_account_by_event_name
16events_stages_summary_by_host_by_event_name
17events_stages_summary_by_thread_by_event_name
18events_stages_summary_by_user_by_event_name
19events_stages_summary_global_by_event_name
20events_statements_current
21events_statements_history
22events_statements_history_long
23events_statements_summary_by_account_by_event_name
24events_statements_summary_by_digest
25events_statements_summary_by_host_by_event_name
26events_statements_summary_by_thread_by_event_name
27events_statements_summary_by_user_by_event_name
28events_statements_summary_global_by_event_name
29events_waits_current
30events_waits_history
31events_waits_history_long
32events_waits_summary_by_account_by_event_name
33events_waits_summary_by_host_by_event_name
34events_waits_summary_by_instance
35events_waits_summary_by_thread_by_event_name
36events_waits_summary_by_user_by_event_name
37events_waits_summary_global_by_event_name
38file_instances
39file_summary_by_event_name
40file_summary_by_instance
41host_cache
42hosts
43mutex_instances
44objects_summary_global_by_type
45performance_timers
46rwlock_instances
47session_account_connect_attrs
48session_connect_attrs
49setup_actors
50setup_consumers
51setup_instruments
52setup_objects
53setup_timers
54socket_instances
55socket_summary_by_event_name
56socket_summary_by_instance
57table_io_waits_summary_by_index_usage
58table_io_waits_summary_by_table
59table_lock_waits_summary_by_table
60threads
61users
62show create table accounts;
63Table	Create Table
64accounts	CREATE TABLE `accounts` (
65  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
66  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
67  `CURRENT_CONNECTIONS` bigint(20) NOT NULL,
68  `TOTAL_CONNECTIONS` bigint(20) NOT NULL
69) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
70show create table cond_instances;
71Table	Create Table
72cond_instances	CREATE TABLE `cond_instances` (
73  `NAME` varchar(128) NOT NULL,
74  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL
75) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
76show create table events_stages_current;
77Table	Create Table
78events_stages_current	CREATE TABLE `events_stages_current` (
79  `THREAD_ID` bigint(20) unsigned NOT NULL,
80  `EVENT_ID` bigint(20) unsigned NOT NULL,
81  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
82  `EVENT_NAME` varchar(128) NOT NULL,
83  `SOURCE` varchar(64) DEFAULT NULL,
84  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
85  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
86  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
87  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
88  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
89) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
90show create table events_stages_history;
91Table	Create Table
92events_stages_history	CREATE TABLE `events_stages_history` (
93  `THREAD_ID` bigint(20) unsigned NOT NULL,
94  `EVENT_ID` bigint(20) unsigned NOT NULL,
95  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
96  `EVENT_NAME` varchar(128) NOT NULL,
97  `SOURCE` varchar(64) DEFAULT NULL,
98  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
99  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
100  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
101  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
102  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
103) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
104show create table events_stages_history_long;
105Table	Create Table
106events_stages_history_long	CREATE TABLE `events_stages_history_long` (
107  `THREAD_ID` bigint(20) unsigned NOT NULL,
108  `EVENT_ID` bigint(20) unsigned NOT NULL,
109  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
110  `EVENT_NAME` varchar(128) NOT NULL,
111  `SOURCE` varchar(64) DEFAULT NULL,
112  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
113  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
114  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
115  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
116  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
117) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
118show create table events_stages_summary_by_host_by_event_name;
119Table	Create Table
120events_stages_summary_by_host_by_event_name	CREATE TABLE `events_stages_summary_by_host_by_event_name` (
121  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
122  `EVENT_NAME` varchar(128) NOT NULL,
123  `COUNT_STAR` bigint(20) unsigned NOT NULL,
124  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
125  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
126  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
127  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
128) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
129show create table events_stages_summary_by_thread_by_event_name;
130Table	Create Table
131events_stages_summary_by_thread_by_event_name	CREATE TABLE `events_stages_summary_by_thread_by_event_name` (
132  `THREAD_ID` bigint(20) unsigned NOT NULL,
133  `EVENT_NAME` varchar(128) NOT NULL,
134  `COUNT_STAR` bigint(20) unsigned NOT NULL,
135  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
136  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
137  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
138  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
139) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
140show create table events_stages_summary_by_user_by_event_name;
141Table	Create Table
142events_stages_summary_by_user_by_event_name	CREATE TABLE `events_stages_summary_by_user_by_event_name` (
143  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
144  `EVENT_NAME` varchar(128) NOT NULL,
145  `COUNT_STAR` bigint(20) unsigned NOT NULL,
146  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
147  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
148  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
149  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
150) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
151show create table events_stages_summary_by_account_by_event_name;
152Table	Create Table
153events_stages_summary_by_account_by_event_name	CREATE TABLE `events_stages_summary_by_account_by_event_name` (
154  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
155  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
156  `EVENT_NAME` varchar(128) NOT NULL,
157  `COUNT_STAR` bigint(20) unsigned NOT NULL,
158  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
159  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
160  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
161  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
162) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
163show create table events_stages_summary_global_by_event_name;
164Table	Create Table
165events_stages_summary_global_by_event_name	CREATE TABLE `events_stages_summary_global_by_event_name` (
166  `EVENT_NAME` varchar(128) NOT NULL,
167  `COUNT_STAR` bigint(20) unsigned NOT NULL,
168  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
169  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
170  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
171  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
172) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
173show create table events_statements_current;
174Table	Create Table
175events_statements_current	CREATE TABLE `events_statements_current` (
176  `THREAD_ID` bigint(20) unsigned NOT NULL,
177  `EVENT_ID` bigint(20) unsigned NOT NULL,
178  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
179  `EVENT_NAME` varchar(128) NOT NULL,
180  `SOURCE` varchar(64) DEFAULT NULL,
181  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
182  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
183  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
184  `LOCK_TIME` bigint(20) unsigned NOT NULL,
185  `SQL_TEXT` longtext,
186  `DIGEST` varchar(32) DEFAULT NULL,
187  `DIGEST_TEXT` longtext,
188  `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
189  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
190  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
191  `OBJECT_NAME` varchar(64) DEFAULT NULL,
192  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL,
193  `MYSQL_ERRNO` int(11) DEFAULT NULL,
194  `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
195  `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
196  `ERRORS` bigint(20) unsigned NOT NULL,
197  `WARNINGS` bigint(20) unsigned NOT NULL,
198  `ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
199  `ROWS_SENT` bigint(20) unsigned NOT NULL,
200  `ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
201  `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
202  `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
203  `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
204  `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
205  `SELECT_RANGE` bigint(20) unsigned NOT NULL,
206  `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
207  `SELECT_SCAN` bigint(20) unsigned NOT NULL,
208  `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
209  `SORT_RANGE` bigint(20) unsigned NOT NULL,
210  `SORT_ROWS` bigint(20) unsigned NOT NULL,
211  `SORT_SCAN` bigint(20) unsigned NOT NULL,
212  `NO_INDEX_USED` bigint(20) unsigned NOT NULL,
213  `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
214  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
215  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
216) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
217show create table events_statements_history;
218Table	Create Table
219events_statements_history	CREATE TABLE `events_statements_history` (
220  `THREAD_ID` bigint(20) unsigned NOT NULL,
221  `EVENT_ID` bigint(20) unsigned NOT NULL,
222  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
223  `EVENT_NAME` varchar(128) NOT NULL,
224  `SOURCE` varchar(64) DEFAULT NULL,
225  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
226  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
227  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
228  `LOCK_TIME` bigint(20) unsigned NOT NULL,
229  `SQL_TEXT` longtext,
230  `DIGEST` varchar(32) DEFAULT NULL,
231  `DIGEST_TEXT` longtext,
232  `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
233  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
234  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
235  `OBJECT_NAME` varchar(64) DEFAULT NULL,
236  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL,
237  `MYSQL_ERRNO` int(11) DEFAULT NULL,
238  `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
239  `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
240  `ERRORS` bigint(20) unsigned NOT NULL,
241  `WARNINGS` bigint(20) unsigned NOT NULL,
242  `ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
243  `ROWS_SENT` bigint(20) unsigned NOT NULL,
244  `ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
245  `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
246  `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
247  `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
248  `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
249  `SELECT_RANGE` bigint(20) unsigned NOT NULL,
250  `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
251  `SELECT_SCAN` bigint(20) unsigned NOT NULL,
252  `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
253  `SORT_RANGE` bigint(20) unsigned NOT NULL,
254  `SORT_ROWS` bigint(20) unsigned NOT NULL,
255  `SORT_SCAN` bigint(20) unsigned NOT NULL,
256  `NO_INDEX_USED` bigint(20) unsigned NOT NULL,
257  `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
258  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
259  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
260) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
261show create table events_statements_history_long;
262Table	Create Table
263events_statements_history_long	CREATE TABLE `events_statements_history_long` (
264  `THREAD_ID` bigint(20) unsigned NOT NULL,
265  `EVENT_ID` bigint(20) unsigned NOT NULL,
266  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
267  `EVENT_NAME` varchar(128) NOT NULL,
268  `SOURCE` varchar(64) DEFAULT NULL,
269  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
270  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
271  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
272  `LOCK_TIME` bigint(20) unsigned NOT NULL,
273  `SQL_TEXT` longtext,
274  `DIGEST` varchar(32) DEFAULT NULL,
275  `DIGEST_TEXT` longtext,
276  `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
277  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
278  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
279  `OBJECT_NAME` varchar(64) DEFAULT NULL,
280  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL,
281  `MYSQL_ERRNO` int(11) DEFAULT NULL,
282  `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
283  `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
284  `ERRORS` bigint(20) unsigned NOT NULL,
285  `WARNINGS` bigint(20) unsigned NOT NULL,
286  `ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
287  `ROWS_SENT` bigint(20) unsigned NOT NULL,
288  `ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
289  `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
290  `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
291  `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
292  `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
293  `SELECT_RANGE` bigint(20) unsigned NOT NULL,
294  `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
295  `SELECT_SCAN` bigint(20) unsigned NOT NULL,
296  `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
297  `SORT_RANGE` bigint(20) unsigned NOT NULL,
298  `SORT_ROWS` bigint(20) unsigned NOT NULL,
299  `SORT_SCAN` bigint(20) unsigned NOT NULL,
300  `NO_INDEX_USED` bigint(20) unsigned NOT NULL,
301  `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
302  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
303  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
304) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
305show create table events_statements_summary_by_digest;
306Table	Create Table
307events_statements_summary_by_digest	CREATE TABLE `events_statements_summary_by_digest` (
308  `SCHEMA_NAME` varchar(64) DEFAULT NULL,
309  `DIGEST` varchar(32) DEFAULT NULL,
310  `DIGEST_TEXT` longtext,
311  `COUNT_STAR` bigint(20) unsigned NOT NULL,
312  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
313  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
314  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
315  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
316  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
317  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
318  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
319  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
320  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
321  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
322  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
323  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
324  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
325  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
326  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
327  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
328  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
329  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
330  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
331  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
332  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
333  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
334  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
335  `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
336  `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
337) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
338show create table events_statements_summary_by_host_by_event_name;
339Table	Create Table
340events_statements_summary_by_host_by_event_name	CREATE TABLE `events_statements_summary_by_host_by_event_name` (
341  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
342  `EVENT_NAME` varchar(128) NOT NULL,
343  `COUNT_STAR` bigint(20) unsigned NOT NULL,
344  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
345  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
346  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
347  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
348  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
349  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
350  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
351  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
352  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
353  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
354  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
355  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
356  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
357  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
358  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
359  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
360  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
361  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
362  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
363  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
364  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
365  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
366  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
367) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
368show create table events_statements_summary_by_thread_by_event_name;
369Table	Create Table
370events_statements_summary_by_thread_by_event_name	CREATE TABLE `events_statements_summary_by_thread_by_event_name` (
371  `THREAD_ID` bigint(20) unsigned NOT NULL,
372  `EVENT_NAME` varchar(128) NOT NULL,
373  `COUNT_STAR` bigint(20) unsigned NOT NULL,
374  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
375  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
376  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
377  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
378  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
379  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
380  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
381  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
382  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
383  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
384  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
385  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
386  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
387  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
388  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
389  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
390  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
391  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
392  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
393  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
394  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
395  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
396  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
397) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
398show create table events_statements_summary_by_user_by_event_name;
399Table	Create Table
400events_statements_summary_by_user_by_event_name	CREATE TABLE `events_statements_summary_by_user_by_event_name` (
401  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
402  `EVENT_NAME` varchar(128) NOT NULL,
403  `COUNT_STAR` bigint(20) unsigned NOT NULL,
404  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
405  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
406  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
407  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
408  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
409  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
410  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
411  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
412  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
413  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
414  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
415  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
416  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
417  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
418  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
419  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
420  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
421  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
422  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
423  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
424  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
425  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
426  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
427) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
428show create table events_statements_summary_by_account_by_event_name;
429Table	Create Table
430events_statements_summary_by_account_by_event_name	CREATE TABLE `events_statements_summary_by_account_by_event_name` (
431  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
432  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
433  `EVENT_NAME` varchar(128) NOT NULL,
434  `COUNT_STAR` bigint(20) unsigned NOT NULL,
435  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
436  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
437  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
438  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
439  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
440  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
441  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
442  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
443  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
444  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
445  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
446  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
447  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
448  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
449  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
450  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
451  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
452  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
453  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
454  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
455  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
456  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
457  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
458) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
459show create table events_statements_summary_global_by_event_name;
460Table	Create Table
461events_statements_summary_global_by_event_name	CREATE TABLE `events_statements_summary_global_by_event_name` (
462  `EVENT_NAME` varchar(128) NOT NULL,
463  `COUNT_STAR` bigint(20) unsigned NOT NULL,
464  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
465  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
466  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
467  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
468  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
469  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
470  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
471  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
472  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
473  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
474  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
475  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
476  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
477  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
478  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
479  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
480  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
481  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
482  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
483  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
484  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
485  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
486  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
487) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
488show create table events_waits_current;
489Table	Create Table
490events_waits_current	CREATE TABLE `events_waits_current` (
491  `THREAD_ID` bigint(20) unsigned NOT NULL,
492  `EVENT_ID` bigint(20) unsigned NOT NULL,
493  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
494  `EVENT_NAME` varchar(128) NOT NULL,
495  `SOURCE` varchar(64) DEFAULT NULL,
496  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
497  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
498  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
499  `SPINS` int(10) unsigned DEFAULT NULL,
500  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
501  `OBJECT_NAME` varchar(512) DEFAULT NULL,
502  `INDEX_NAME` varchar(64) DEFAULT NULL,
503  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
504  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
505  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
506  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL,
507  `OPERATION` varchar(32) NOT NULL,
508  `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL,
509  `FLAGS` int(10) unsigned DEFAULT NULL
510) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
511show create table events_waits_history;
512Table	Create Table
513events_waits_history	CREATE TABLE `events_waits_history` (
514  `THREAD_ID` bigint(20) unsigned NOT NULL,
515  `EVENT_ID` bigint(20) unsigned NOT NULL,
516  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
517  `EVENT_NAME` varchar(128) NOT NULL,
518  `SOURCE` varchar(64) DEFAULT NULL,
519  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
520  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
521  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
522  `SPINS` int(10) unsigned DEFAULT NULL,
523  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
524  `OBJECT_NAME` varchar(512) DEFAULT NULL,
525  `INDEX_NAME` varchar(64) DEFAULT NULL,
526  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
527  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
528  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
529  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL,
530  `OPERATION` varchar(32) NOT NULL,
531  `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL,
532  `FLAGS` int(10) unsigned DEFAULT NULL
533) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
534show create table events_waits_history_long;
535Table	Create Table
536events_waits_history_long	CREATE TABLE `events_waits_history_long` (
537  `THREAD_ID` bigint(20) unsigned NOT NULL,
538  `EVENT_ID` bigint(20) unsigned NOT NULL,
539  `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
540  `EVENT_NAME` varchar(128) NOT NULL,
541  `SOURCE` varchar(64) DEFAULT NULL,
542  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
543  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
544  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
545  `SPINS` int(10) unsigned DEFAULT NULL,
546  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
547  `OBJECT_NAME` varchar(512) DEFAULT NULL,
548  `INDEX_NAME` varchar(64) DEFAULT NULL,
549  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
550  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
551  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
552  `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL,
553  `OPERATION` varchar(32) NOT NULL,
554  `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL,
555  `FLAGS` int(10) unsigned DEFAULT NULL
556) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
557show create table events_waits_summary_by_host_by_event_name;
558Table	Create Table
559events_waits_summary_by_host_by_event_name	CREATE TABLE `events_waits_summary_by_host_by_event_name` (
560  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
561  `EVENT_NAME` varchar(128) NOT NULL,
562  `COUNT_STAR` bigint(20) unsigned NOT NULL,
563  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
564  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
565  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
566  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
567) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
568show create table events_waits_summary_by_instance;
569Table	Create Table
570events_waits_summary_by_instance	CREATE TABLE `events_waits_summary_by_instance` (
571  `EVENT_NAME` varchar(128) NOT NULL,
572  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
573  `COUNT_STAR` bigint(20) unsigned NOT NULL,
574  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
575  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
576  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
577  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
578) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
579show create table events_waits_summary_by_thread_by_event_name;
580Table	Create Table
581events_waits_summary_by_thread_by_event_name	CREATE TABLE `events_waits_summary_by_thread_by_event_name` (
582  `THREAD_ID` bigint(20) unsigned NOT NULL,
583  `EVENT_NAME` varchar(128) NOT NULL,
584  `COUNT_STAR` bigint(20) unsigned NOT NULL,
585  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
586  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
587  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
588  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
589) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
590show create table events_waits_summary_by_user_by_event_name;
591Table	Create Table
592events_waits_summary_by_user_by_event_name	CREATE TABLE `events_waits_summary_by_user_by_event_name` (
593  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
594  `EVENT_NAME` varchar(128) NOT NULL,
595  `COUNT_STAR` bigint(20) unsigned NOT NULL,
596  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
597  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
598  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
599  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
600) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
601show create table events_waits_summary_by_account_by_event_name;
602Table	Create Table
603events_waits_summary_by_account_by_event_name	CREATE TABLE `events_waits_summary_by_account_by_event_name` (
604  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
605  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
606  `EVENT_NAME` varchar(128) NOT NULL,
607  `COUNT_STAR` bigint(20) unsigned NOT NULL,
608  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
609  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
610  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
611  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
612) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
613show create table events_waits_summary_global_by_event_name;
614Table	Create Table
615events_waits_summary_global_by_event_name	CREATE TABLE `events_waits_summary_global_by_event_name` (
616  `EVENT_NAME` varchar(128) NOT NULL,
617  `COUNT_STAR` bigint(20) unsigned NOT NULL,
618  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
619  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
620  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
621  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
622) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
623show create table file_instances;
624Table	Create Table
625file_instances	CREATE TABLE `file_instances` (
626  `FILE_NAME` varchar(512) NOT NULL,
627  `EVENT_NAME` varchar(128) NOT NULL,
628  `OPEN_COUNT` int(10) unsigned NOT NULL
629) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
630show create table file_summary_by_event_name;
631Table	Create Table
632file_summary_by_event_name	CREATE TABLE `file_summary_by_event_name` (
633  `EVENT_NAME` varchar(128) NOT NULL,
634  `COUNT_STAR` bigint(20) unsigned NOT NULL,
635  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
636  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
637  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
638  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
639  `COUNT_READ` bigint(20) unsigned NOT NULL,
640  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
641  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
642  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
643  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
644  `SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL,
645  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
646  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
647  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
648  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
649  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
650  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL,
651  `COUNT_MISC` bigint(20) unsigned NOT NULL,
652  `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL,
653  `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL,
654  `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL,
655  `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL
656) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
657show create table file_summary_by_instance;
658Table	Create Table
659file_summary_by_instance	CREATE TABLE `file_summary_by_instance` (
660  `FILE_NAME` varchar(512) NOT NULL,
661  `EVENT_NAME` varchar(128) NOT NULL,
662  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
663  `COUNT_STAR` bigint(20) unsigned NOT NULL,
664  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
665  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
666  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
667  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
668  `COUNT_READ` bigint(20) unsigned NOT NULL,
669  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
670  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
671  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
672  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
673  `SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL,
674  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
675  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
676  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
677  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
678  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
679  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL,
680  `COUNT_MISC` bigint(20) unsigned NOT NULL,
681  `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL,
682  `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL,
683  `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL,
684  `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL
685) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
686show create table host_cache;
687Table	Create Table
688host_cache	CREATE TABLE `host_cache` (
689  `IP` varchar(64) NOT NULL,
690  `HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
691  `HOST_VALIDATED` enum('YES','NO') NOT NULL,
692  `SUM_CONNECT_ERRORS` bigint(20) NOT NULL,
693  `COUNT_HOST_BLOCKED_ERRORS` bigint(20) NOT NULL,
694  `COUNT_NAMEINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL,
695  `COUNT_NAMEINFO_PERMANENT_ERRORS` bigint(20) NOT NULL,
696  `COUNT_FORMAT_ERRORS` bigint(20) NOT NULL,
697  `COUNT_ADDRINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL,
698  `COUNT_ADDRINFO_PERMANENT_ERRORS` bigint(20) NOT NULL,
699  `COUNT_FCRDNS_ERRORS` bigint(20) NOT NULL,
700  `COUNT_HOST_ACL_ERRORS` bigint(20) NOT NULL,
701  `COUNT_NO_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL,
702  `COUNT_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL,
703  `COUNT_HANDSHAKE_ERRORS` bigint(20) NOT NULL,
704  `COUNT_PROXY_USER_ERRORS` bigint(20) NOT NULL,
705  `COUNT_PROXY_USER_ACL_ERRORS` bigint(20) NOT NULL,
706  `COUNT_AUTHENTICATION_ERRORS` bigint(20) NOT NULL,
707  `COUNT_SSL_ERRORS` bigint(20) NOT NULL,
708  `COUNT_MAX_USER_CONNECTIONS_ERRORS` bigint(20) NOT NULL,
709  `COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS` bigint(20) NOT NULL,
710  `COUNT_DEFAULT_DATABASE_ERRORS` bigint(20) NOT NULL,
711  `COUNT_INIT_CONNECT_ERRORS` bigint(20) NOT NULL,
712  `COUNT_LOCAL_ERRORS` bigint(20) NOT NULL,
713  `COUNT_UNKNOWN_ERRORS` bigint(20) NOT NULL,
714  `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
715  `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
716  `FIRST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00',
717  `LAST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00'
718) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
719show create table hosts;
720Table	Create Table
721hosts	CREATE TABLE `hosts` (
722  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
723  `CURRENT_CONNECTIONS` bigint(20) NOT NULL,
724  `TOTAL_CONNECTIONS` bigint(20) NOT NULL
725) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
726show create table mutex_instances;
727Table	Create Table
728mutex_instances	CREATE TABLE `mutex_instances` (
729  `NAME` varchar(128) NOT NULL,
730  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
731  `LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL
732) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
733show create table objects_summary_global_by_type;
734Table	Create Table
735objects_summary_global_by_type	CREATE TABLE `objects_summary_global_by_type` (
736  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
737  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
738  `OBJECT_NAME` varchar(64) DEFAULT NULL,
739  `COUNT_STAR` bigint(20) unsigned NOT NULL,
740  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
741  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
742  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
743  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
744) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
745show create table performance_timers;
746Table	Create Table
747performance_timers	CREATE TABLE `performance_timers` (
748  `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL,
749  `TIMER_FREQUENCY` bigint(20) DEFAULT NULL,
750  `TIMER_RESOLUTION` bigint(20) DEFAULT NULL,
751  `TIMER_OVERHEAD` bigint(20) DEFAULT NULL
752) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
753show create table rwlock_instances;
754Table	Create Table
755rwlock_instances	CREATE TABLE `rwlock_instances` (
756  `NAME` varchar(128) NOT NULL,
757  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
758  `WRITE_LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
759  `READ_LOCKED_BY_COUNT` int(10) unsigned NOT NULL
760) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
761show create table setup_actors;
762Table	Create Table
763setup_actors	CREATE TABLE `setup_actors` (
764  `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%',
765  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%',
766  `ROLE` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%'
767) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
768show create table setup_consumers;
769Table	Create Table
770setup_consumers	CREATE TABLE `setup_consumers` (
771  `NAME` varchar(64) NOT NULL,
772  `ENABLED` enum('YES','NO') NOT NULL
773) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
774show create table setup_instruments;
775Table	Create Table
776setup_instruments	CREATE TABLE `setup_instruments` (
777  `NAME` varchar(128) NOT NULL,
778  `ENABLED` enum('YES','NO') NOT NULL,
779  `TIMED` enum('YES','NO') NOT NULL
780) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
781show create table setup_objects;
782Table	Create Table
783setup_objects	CREATE TABLE `setup_objects` (
784  `OBJECT_TYPE` enum('TABLE') NOT NULL DEFAULT 'TABLE',
785  `OBJECT_SCHEMA` varchar(64) DEFAULT '%',
786  `OBJECT_NAME` varchar(64) NOT NULL DEFAULT '%',
787  `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES',
788  `TIMED` enum('YES','NO') NOT NULL DEFAULT 'YES'
789) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
790show create table setup_timers;
791Table	Create Table
792setup_timers	CREATE TABLE `setup_timers` (
793  `NAME` varchar(64) NOT NULL,
794  `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL
795) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
796show create table socket_instances;
797Table	Create Table
798socket_instances	CREATE TABLE `socket_instances` (
799  `EVENT_NAME` varchar(128) NOT NULL,
800  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
801  `THREAD_ID` bigint(20) unsigned DEFAULT NULL,
802  `SOCKET_ID` int(11) NOT NULL,
803  `IP` varchar(64) NOT NULL,
804  `PORT` int(11) NOT NULL,
805  `STATE` enum('IDLE','ACTIVE') NOT NULL
806) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
807show create table socket_summary_by_instance;
808Table	Create Table
809socket_summary_by_instance	CREATE TABLE `socket_summary_by_instance` (
810  `EVENT_NAME` varchar(128) NOT NULL,
811  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
812  `COUNT_STAR` bigint(20) unsigned NOT NULL,
813  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
814  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
815  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
816  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
817  `COUNT_READ` bigint(20) unsigned NOT NULL,
818  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
819  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
820  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
821  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
822  `SUM_NUMBER_OF_BYTES_READ` bigint(20) unsigned NOT NULL,
823  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
824  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
825  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
826  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
827  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
828  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL,
829  `COUNT_MISC` bigint(20) unsigned NOT NULL,
830  `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL,
831  `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL,
832  `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL,
833  `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL
834) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
835show create table socket_summary_by_event_name;
836Table	Create Table
837socket_summary_by_event_name	CREATE TABLE `socket_summary_by_event_name` (
838  `EVENT_NAME` varchar(128) NOT NULL,
839  `COUNT_STAR` bigint(20) unsigned NOT NULL,
840  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
841  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
842  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
843  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
844  `COUNT_READ` bigint(20) unsigned NOT NULL,
845  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
846  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
847  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
848  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
849  `SUM_NUMBER_OF_BYTES_READ` bigint(20) unsigned NOT NULL,
850  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
851  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
852  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
853  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
854  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
855  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL,
856  `COUNT_MISC` bigint(20) unsigned NOT NULL,
857  `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL,
858  `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL,
859  `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL,
860  `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL
861) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
862show create table table_io_waits_summary_by_index_usage;
863Table	Create Table
864table_io_waits_summary_by_index_usage	CREATE TABLE `table_io_waits_summary_by_index_usage` (
865  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
866  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
867  `OBJECT_NAME` varchar(64) DEFAULT NULL,
868  `INDEX_NAME` varchar(64) DEFAULT NULL,
869  `COUNT_STAR` bigint(20) unsigned NOT NULL,
870  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
871  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
872  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
873  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
874  `COUNT_READ` bigint(20) unsigned NOT NULL,
875  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
876  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
877  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
878  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
879  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
880  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
881  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
882  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
883  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
884  `COUNT_FETCH` bigint(20) unsigned NOT NULL,
885  `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL,
886  `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL,
887  `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL,
888  `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL,
889  `COUNT_INSERT` bigint(20) unsigned NOT NULL,
890  `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL,
891  `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL,
892  `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL,
893  `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL,
894  `COUNT_UPDATE` bigint(20) unsigned NOT NULL,
895  `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
896  `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
897  `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
898  `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
899  `COUNT_DELETE` bigint(20) unsigned NOT NULL,
900  `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL,
901  `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL,
902  `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL,
903  `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL
904) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
905show create table table_io_waits_summary_by_table;
906Table	Create Table
907table_io_waits_summary_by_table	CREATE TABLE `table_io_waits_summary_by_table` (
908  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
909  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
910  `OBJECT_NAME` varchar(64) DEFAULT NULL,
911  `COUNT_STAR` bigint(20) unsigned NOT NULL,
912  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
913  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
914  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
915  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
916  `COUNT_READ` bigint(20) unsigned NOT NULL,
917  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
918  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
919  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
920  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
921  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
922  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
923  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
924  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
925  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
926  `COUNT_FETCH` bigint(20) unsigned NOT NULL,
927  `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL,
928  `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL,
929  `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL,
930  `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL,
931  `COUNT_INSERT` bigint(20) unsigned NOT NULL,
932  `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL,
933  `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL,
934  `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL,
935  `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL,
936  `COUNT_UPDATE` bigint(20) unsigned NOT NULL,
937  `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
938  `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
939  `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
940  `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
941  `COUNT_DELETE` bigint(20) unsigned NOT NULL,
942  `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL,
943  `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL,
944  `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL,
945  `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL
946) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
947show create table table_lock_waits_summary_by_table;
948Table	Create Table
949table_lock_waits_summary_by_table	CREATE TABLE `table_lock_waits_summary_by_table` (
950  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
951  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
952  `OBJECT_NAME` varchar(64) DEFAULT NULL,
953  `COUNT_STAR` bigint(20) unsigned NOT NULL,
954  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
955  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
956  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
957  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
958  `COUNT_READ` bigint(20) unsigned NOT NULL,
959  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
960  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
961  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
962  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
963  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
964  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
965  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
966  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
967  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
968  `COUNT_READ_NORMAL` bigint(20) unsigned NOT NULL,
969  `SUM_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
970  `MIN_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
971  `AVG_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
972  `MAX_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
973  `COUNT_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
974  `SUM_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
975  `MIN_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
976  `AVG_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
977  `MAX_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
978  `COUNT_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
979  `SUM_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
980  `MIN_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
981  `AVG_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
982  `MAX_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
983  `COUNT_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
984  `SUM_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
985  `MIN_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
986  `AVG_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
987  `MAX_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
988  `COUNT_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
989  `SUM_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
990  `MIN_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
991  `AVG_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
992  `MAX_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
993  `COUNT_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
994  `SUM_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
995  `MIN_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
996  `AVG_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
997  `MAX_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
998  `COUNT_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
999  `SUM_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
1000  `MIN_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
1001  `AVG_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
1002  `MAX_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
1003  `COUNT_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
1004  `SUM_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
1005  `MIN_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
1006  `AVG_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
1007  `MAX_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
1008  `COUNT_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
1009  `SUM_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
1010  `MIN_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
1011  `AVG_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
1012  `MAX_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
1013  `COUNT_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
1014  `SUM_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
1015  `MIN_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
1016  `AVG_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
1017  `MAX_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
1018  `COUNT_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
1019  `SUM_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
1020  `MIN_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
1021  `AVG_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
1022  `MAX_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL
1023) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
1024show create table threads;
1025Table	Create Table
1026threads	CREATE TABLE `threads` (
1027  `THREAD_ID` bigint(20) unsigned NOT NULL,
1028  `NAME` varchar(128) NOT NULL,
1029  `TYPE` varchar(10) NOT NULL,
1030  `PROCESSLIST_ID` bigint(20) unsigned DEFAULT NULL,
1031  `PROCESSLIST_USER` varchar(16) DEFAULT NULL,
1032  `PROCESSLIST_HOST` varchar(60) DEFAULT NULL,
1033  `PROCESSLIST_DB` varchar(64) DEFAULT NULL,
1034  `PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL,
1035  `PROCESSLIST_TIME` bigint(20) DEFAULT NULL,
1036  `PROCESSLIST_STATE` varchar(64) DEFAULT NULL,
1037  `PROCESSLIST_INFO` longtext,
1038  `PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
1039  `ROLE` varchar(64) DEFAULT NULL,
1040  `INSTRUMENTED` enum('YES','NO') NOT NULL
1041) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
1042show create table users;
1043Table	Create Table
1044users	CREATE TABLE `users` (
1045  `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
1046  `CURRENT_CONNECTIONS` bigint(20) NOT NULL,
1047  `TOTAL_CONNECTIONS` bigint(20) NOT NULL
1048) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
1049