#At file:///home/cpowers/work/dev/mysql-trunk/ based on revid:anitha.gopi@stripped
3107 Christopher Powers 2011-05-24
BUG#11766504 "59631: BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA"
- Change all unsigned BIGINT columns to signed.
- Added test case to detect changes to the PERFORMANCE_SCHEMA tables and
to check for unsigned BIGINT columns.
added:
mysql-test/suite/perfschema/r/table_schema.result
mysql-test/suite/perfschema/t/table_schema.test
modified:
scripts/mysql_system_tables.sql
=== added file 'mysql-test/suite/perfschema/r/table_schema.result'
--- a/mysql-test/suite/perfschema/r/table_schema.result 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/r/table_schema.result 2011-05-24 20:31:16 +0000
@@ -0,0 +1,844 @@
+select * from information_schema.columns where table_schema="performance_schema" order by table_name, ordinal_position;
+TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT
+def performance_schema cond_instances NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema cond_instances OBJECT_INSTANCE_BEGIN 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_current THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_stages_current EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_current EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_stages_current SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_stages_current TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_current TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_current TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_current NESTING_EVENT_ID 8 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_current NESTING_EVENT_TYPE 9 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_stages_history THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_stages_history EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_stages_history SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_stages_history TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history NESTING_EVENT_ID 8 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history NESTING_EVENT_TYPE 9 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_stages_history_long THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_stages_history_long EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history_long EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_stages_history_long SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_stages_history_long TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history_long TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history_long TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history_long NESTING_EVENT_ID 8 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_history_long NESTING_EVENT_TYPE 9 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name EVENT_NAME 2 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name COUNT_STAR 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name SUM_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name MIN_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name AVG_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_by_thread_by_event_name MAX_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_global_by_event_name EVENT_NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_stages_summary_global_by_event_name COUNT_STAR 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_global_by_event_name SUM_TIMER_WAIT 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_global_by_event_name MIN_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_global_by_event_name AVG_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_stages_summary_global_by_event_name MAX_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_current EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_current SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_current TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current LOCK_TIME 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SQL_TEXT 9 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select,insert,update,references
+def performance_schema events_statements_current CURRENT_SCHEMA 10 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_current OBJECT_TYPE 11 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_current OBJECT_SCHEMA 12 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_current OBJECT_NAME 13 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_current OBJECT_INSTANCE_BEGIN 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current MYSQL_ERRNO 15 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_current RETURNED_SQLSTATE 16 NULL YES varchar 5 15 NULL NULL utf8 utf8_general_ci varchar(5) select,insert,update,references
+def performance_schema events_statements_current MESSAGE_TEXT 17 NULL YES varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_current ERRORS 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current WARNINGS 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current ROWS_AFFECTED 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current ROWS_SENT 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current ROWS_EXAMINED 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current CREATED_TMP_DISK_TABLES 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current CREATED_TMP_TABLES 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SELECT_FULL_JOIN 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SELECT_FULL_RANGE_JOIN 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SELECT_RANGE 27 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SELECT_RANGE_CHECK 28 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SELECT_SCAN 29 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SORT_MERGE_PASSES 30 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SORT_RANGE 31 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SORT_ROWS 32 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current SORT_SCAN 33 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current NO_INDEX_USED 34 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current NO_GOOD_INDEX_USED 35 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current NESTING_EVENT_ID 36 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_current NESTING_EVENT_TYPE 37 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_statements_history THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_history EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_history SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history LOCK_TIME 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SQL_TEXT 9 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select,insert,update,references
+def performance_schema events_statements_history CURRENT_SCHEMA 10 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history OBJECT_TYPE 11 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history OBJECT_SCHEMA 12 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history OBJECT_NAME 13 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history OBJECT_INSTANCE_BEGIN 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history MYSQL_ERRNO 15 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_history RETURNED_SQLSTATE 16 NULL YES varchar 5 15 NULL NULL utf8 utf8_general_ci varchar(5) select,insert,update,references
+def performance_schema events_statements_history MESSAGE_TEXT 17 NULL YES varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_history ERRORS 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history WARNINGS 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history ROWS_AFFECTED 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history ROWS_SENT 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history ROWS_EXAMINED 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history CREATED_TMP_DISK_TABLES 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history CREATED_TMP_TABLES 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SELECT_FULL_JOIN 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SELECT_FULL_RANGE_JOIN 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SELECT_RANGE 27 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SELECT_RANGE_CHECK 28 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SELECT_SCAN 29 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SORT_MERGE_PASSES 30 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SORT_RANGE 31 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SORT_ROWS 32 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history SORT_SCAN 33 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history NO_INDEX_USED 34 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history NO_GOOD_INDEX_USED 35 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history NESTING_EVENT_ID 36 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history NESTING_EVENT_TYPE 37 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_statements_history_long THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_history_long EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_history_long SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history_long TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long LOCK_TIME 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SQL_TEXT 9 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select,insert,update,references
+def performance_schema events_statements_history_long CURRENT_SCHEMA 10 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history_long OBJECT_TYPE 11 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history_long OBJECT_SCHEMA 12 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history_long OBJECT_NAME 13 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_statements_history_long OBJECT_INSTANCE_BEGIN 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long MYSQL_ERRNO 15 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_history_long RETURNED_SQLSTATE 16 NULL YES varchar 5 15 NULL NULL utf8 utf8_general_ci varchar(5) select,insert,update,references
+def performance_schema events_statements_history_long MESSAGE_TEXT 17 NULL YES varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_history_long ERRORS 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long WARNINGS 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long ROWS_AFFECTED 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long ROWS_SENT 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long ROWS_EXAMINED 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long CREATED_TMP_DISK_TABLES 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long CREATED_TMP_TABLES 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SELECT_FULL_JOIN 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SELECT_FULL_RANGE_JOIN 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SELECT_RANGE 27 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SELECT_RANGE_CHECK 28 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SELECT_SCAN 29 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SORT_MERGE_PASSES 30 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SORT_RANGE 31 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SORT_ROWS 32 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long SORT_SCAN 33 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long NO_INDEX_USED 34 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long NO_GOOD_INDEX_USED 35 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long NESTING_EVENT_ID 36 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_history_long NESTING_EVENT_TYPE 37 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name EVENT_NAME 2 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name COUNT_STAR 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name MIN_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name AVG_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name MAX_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_LOCK_TIME 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_ERRORS 9 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_WARNINGS 10 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_ROWS_AFFECTED 11 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_ROWS_SENT 12 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_ROWS_EXAMINED 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_DISK_TABLES 14 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_TABLES 15 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_JOIN 16 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_RANGE_JOIN 17 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE_CHECK 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SELECT_SCAN 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SORT_MERGE_PASSES 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SORT_RANGE 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SORT_ROWS 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_SORT_SCAN 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_NO_INDEX_USED 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_by_thread_by_event_name SUM_NO_GOOD_INDEX_USED 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name EVENT_NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name COUNT_STAR 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_TIMER_WAIT 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name MIN_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name AVG_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name MAX_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_LOCK_TIME 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_ERRORS 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_WARNINGS 9 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_ROWS_AFFECTED 10 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_ROWS_SENT 11 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_ROWS_EXAMINED 12 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_CREATED_TMP_DISK_TABLES 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_CREATED_TMP_TABLES 14 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SELECT_FULL_JOIN 15 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SELECT_FULL_RANGE_JOIN 16 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SELECT_RANGE 17 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SELECT_RANGE_CHECK 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SELECT_SCAN 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SORT_MERGE_PASSES 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SORT_RANGE 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SORT_ROWS 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_SORT_SCAN 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_NO_INDEX_USED 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_statements_summary_global_by_event_name SUM_NO_GOOD_INDEX_USED 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_waits_current EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_waits_current SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_current TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current SPINS 8 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema events_waits_current OBJECT_SCHEMA 9 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_current OBJECT_NAME 10 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select,insert,update,references
+def performance_schema events_waits_current INDEX_NAME 11 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_current OBJECT_TYPE 12 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_current OBJECT_INSTANCE_BEGIN 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current NESTING_EVENT_ID 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current NESTING_EVENT_TYPE 15 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_waits_current OPERATION 16 NULL NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select,insert,update,references
+def performance_schema events_waits_current NUMBER_OF_BYTES 17 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_current FLAGS 18 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema events_waits_history THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_waits_history EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_waits_history SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history SPINS 8 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema events_waits_history OBJECT_SCHEMA 9 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history OBJECT_NAME 10 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select,insert,update,references
+def performance_schema events_waits_history INDEX_NAME 11 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history OBJECT_TYPE 12 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history OBJECT_INSTANCE_BEGIN 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history NESTING_EVENT_ID 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history NESTING_EVENT_TYPE 15 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_waits_history OPERATION 16 NULL NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select,insert,update,references
+def performance_schema events_waits_history NUMBER_OF_BYTES 17 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history FLAGS 18 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema events_waits_history_long THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_waits_history_long EVENT_ID 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long EVENT_NAME 3 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_waits_history_long SOURCE 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history_long TIMER_START 5 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long TIMER_END 6 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long TIMER_WAIT 7 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long SPINS 8 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema events_waits_history_long OBJECT_SCHEMA 9 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history_long OBJECT_NAME 10 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select,insert,update,references
+def performance_schema events_waits_history_long INDEX_NAME 11 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history_long OBJECT_TYPE 12 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema events_waits_history_long OBJECT_INSTANCE_BEGIN 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long NESTING_EVENT_ID 14 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long NESTING_EVENT_TYPE 15 NULL YES enum 9 27 NULL NULL utf8 utf8_general_ci enum('STATEMENT','STAGE','WAIT') select,insert,update,references
+def performance_schema events_waits_history_long OPERATION 16 NULL NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select,insert,update,references
+def performance_schema events_waits_history_long NUMBER_OF_BYTES 17 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_history_long FLAGS 18 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema events_waits_summary_by_instance EVENT_NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_waits_summary_by_instance OBJECT_INSTANCE_BEGIN 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_instance COUNT_STAR 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_instance SUM_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_instance MIN_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_instance AVG_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_instance MAX_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name EVENT_NAME 2 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name COUNT_STAR 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name SUM_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name MIN_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name AVG_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_by_thread_by_event_name MAX_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_global_by_event_name EVENT_NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema events_waits_summary_global_by_event_name COUNT_STAR 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_global_by_event_name SUM_TIMER_WAIT 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_global_by_event_name MIN_TIMER_WAIT 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_global_by_event_name AVG_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema events_waits_summary_global_by_event_name MAX_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_instances FILE_NAME 1 NULL NO varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select,insert,update,references
+def performance_schema file_instances EVENT_NAME 2 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema file_instances OPEN_COUNT 3 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema file_summary_by_event_name EVENT_NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema file_summary_by_event_name COUNT_READ 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_event_name COUNT_WRITE 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_event_name SUM_NUMBER_OF_BYTES_READ 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_event_name SUM_NUMBER_OF_BYTES_WRITE 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_instance FILE_NAME 1 NULL NO varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select,insert,update,references
+def performance_schema file_summary_by_instance EVENT_NAME 2 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema file_summary_by_instance COUNT_READ 3 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_instance COUNT_WRITE 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_instance SUM_NUMBER_OF_BYTES_READ 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema file_summary_by_instance SUM_NUMBER_OF_BYTES_WRITE 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema mutex_instances NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema mutex_instances OBJECT_INSTANCE_BEGIN 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema mutex_instances LOCKED_BY_THREAD_ID 3 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema objects_summary_global_by_type OBJECT_TYPE 1 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema objects_summary_global_by_type OBJECT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema objects_summary_global_by_type OBJECT_NAME 3 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema objects_summary_global_by_type COUNT_STAR 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema objects_summary_global_by_type SUM_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema objects_summary_global_by_type MIN_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema objects_summary_global_by_type AVG_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema objects_summary_global_by_type MAX_TIMER_WAIT 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema performance_timers TIMER_NAME 1 NULL NO enum 11 33 NULL NULL utf8 utf8_general_ci enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') select,insert,update,references
+def performance_schema performance_timers TIMER_FREQUENCY 2 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema performance_timers TIMER_RESOLUTION 3 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema performance_timers TIMER_OVERHEAD 4 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema rwlock_instances NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema rwlock_instances OBJECT_INSTANCE_BEGIN 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema rwlock_instances WRITE_LOCKED_BY_THREAD_ID 3 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema rwlock_instances READ_LOCKED_BY_COUNT 4 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references
+def performance_schema setup_actors HOST 1 % NO char 60 180 NULL NULL utf8 utf8_bin char(60) select,insert,update,references
+def performance_schema setup_actors USER 2 % NO char 16 48 NULL NULL utf8 utf8_bin char(16) select,insert,update,references
+def performance_schema setup_actors ROLE 3 % NO char 16 48 NULL NULL utf8 utf8_bin char(16) select,insert,update,references
+def performance_schema setup_consumers NAME 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema setup_consumers ENABLED 2 NULL NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('YES','NO') select,insert,update,references
+def performance_schema setup_instruments NAME 1 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema setup_instruments ENABLED 2 NULL NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('YES','NO') select,insert,update,references
+def performance_schema setup_instruments TIMED 3 NULL NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('YES','NO') select,insert,update,references
+def performance_schema setup_objects OBJECT_TYPE 1 TABLE NO enum 5 15 NULL NULL utf8 utf8_general_ci enum('TABLE') select,insert,update,references
+def performance_schema setup_objects OBJECT_SCHEMA 2 % YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema setup_objects OBJECT_NAME 3 % NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema setup_objects TIMED 4 YES NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('YES','NO') select,insert,update,references
+def performance_schema setup_timers NAME 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema setup_timers TIMER_NAME 2 NULL NO enum 11 33 NULL NULL utf8 utf8_general_ci enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage OBJECT_TYPE 1 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage OBJECT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage OBJECT_NAME 3 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage INDEX_NAME 4 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_STAR 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_WAIT 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_WAIT 9 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_READ 10 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_READ 11 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_READ 12 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_READ 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_READ 14 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_WRITE 15 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_WRITE 16 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_WRITE 17 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_WRITE 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_WRITE 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_FETCH 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_FETCH 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_FETCH 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_FETCH 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_FETCH 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_INSERT 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_INSERT 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_INSERT 27 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_INSERT 28 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_INSERT 29 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_UPDATE 30 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_UPDATE 31 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_UPDATE 32 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_UPDATE 33 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_UPDATE 34 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage COUNT_DELETE 35 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage SUM_TIMER_DELETE 36 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MIN_TIMER_DELETE 37 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage AVG_TIMER_DELETE 38 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_index_usage MAX_TIMER_DELETE 39 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table OBJECT_TYPE 1 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table OBJECT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table OBJECT_NAME 3 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_STAR 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_WAIT 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_READ 9 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_READ 10 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_READ 11 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_READ 12 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_READ 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_WRITE 14 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_WRITE 15 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_WRITE 16 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_WRITE 17 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_WRITE 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_FETCH 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_FETCH 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_FETCH 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_FETCH 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_FETCH 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_INSERT 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_INSERT 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_INSERT 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_INSERT 27 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_INSERT 28 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_UPDATE 29 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_UPDATE 30 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_UPDATE 31 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_UPDATE 32 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_UPDATE 33 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table COUNT_DELETE 34 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table SUM_TIMER_DELETE 35 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MIN_TIMER_DELETE 36 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table AVG_TIMER_DELETE 37 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_io_waits_summary_by_table MAX_TIMER_DELETE 38 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table OBJECT_TYPE 1 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table OBJECT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table OBJECT_NAME 3 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_STAR 4 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WAIT 5 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WAIT 6 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WAIT 7 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WAIT 8 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_READ 9 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_READ 10 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_READ 11 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_READ 12 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_READ 13 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE 14 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE 15 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE 16 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE 17 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE 18 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_READ_NORMAL 19 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_READ_NORMAL 20 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_READ_NORMAL 21 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_READ_NORMAL 22 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_READ_NORMAL 23 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_READ_WITH_SHARED_LOCKS 24 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_READ_WITH_SHARED_LOCKS 25 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_READ_WITH_SHARED_LOCKS 26 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_READ_WITH_SHARED_LOCKS 27 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_READ_WITH_SHARED_LOCKS 28 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_READ_HIGH_PRIORITY 29 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_READ_HIGH_PRIORITY 30 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_READ_HIGH_PRIORITY 31 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_READ_HIGH_PRIORITY 32 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_READ_HIGH_PRIORITY 33 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_READ_NO_INSERT 34 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_READ_NO_INSERT 35 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_READ_NO_INSERT 36 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_READ_NO_INSERT 37 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_READ_NO_INSERT 38 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_READ_EXTERNAL 39 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_READ_EXTERNAL 40 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_READ_EXTERNAL 41 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_READ_EXTERNAL 42 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_READ_EXTERNAL 43 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE_ALLOW_WRITE 44 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE_ALLOW_WRITE 45 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE_ALLOW_WRITE 46 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE_ALLOW_WRITE 47 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE_ALLOW_WRITE 48 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE_CONCURRENT_INSERT 49 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE_CONCURRENT_INSERT 50 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE_CONCURRENT_INSERT 51 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE_CONCURRENT_INSERT 52 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE_CONCURRENT_INSERT 53 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE_DELAYED 54 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE_DELAYED 55 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE_DELAYED 56 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE_DELAYED 57 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE_DELAYED 58 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE_LOW_PRIORITY 59 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE_LOW_PRIORITY 60 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE_LOW_PRIORITY 61 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE_LOW_PRIORITY 62 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE_LOW_PRIORITY 63 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE_NORMAL 64 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE_NORMAL 65 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE_NORMAL 66 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE_NORMAL 67 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE_NORMAL 68 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table COUNT_WRITE_EXTERNAL 69 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table SUM_TIMER_WRITE_EXTERNAL 70 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MIN_TIMER_WRITE_EXTERNAL 71 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table AVG_TIMER_WRITE_EXTERNAL 72 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema table_lock_waits_summary_by_table MAX_TIMER_WRITE_EXTERNAL 73 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema threads THREAD_ID 1 NULL NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema threads NAME 2 NULL NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) select,insert,update,references
+def performance_schema threads TYPE 3 NULL NO varchar 10 30 NULL NULL utf8 utf8_general_ci varchar(10) select,insert,update,references
+def performance_schema threads PROCESSLIST_ID 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema threads PROCESSLIST_USER 5 NULL YES varchar 16 48 NULL NULL utf8 utf8_general_ci varchar(16) select,insert,update,references
+def performance_schema threads PROCESSLIST_HOST 6 NULL YES varchar 60 180 NULL NULL utf8 utf8_general_ci varchar(60) select,insert,update,references
+def performance_schema threads PROCESSLIST_DB 7 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema threads PROCESSLIST_COMMAND 8 NULL YES varchar 16 48 NULL NULL utf8 utf8_general_ci varchar(16) select,insert,update,references
+def performance_schema threads PROCESSLIST_TIME 9 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references
+def performance_schema threads PROCESSLIST_STATE 10 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema threads PROCESSLIST_INFO 11 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select,insert,update,references
+def performance_schema threads PARENT_THREAD_ID 12 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references
+def performance_schema threads ROLE 13 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select,insert,update,references
+def performance_schema threads INSTRUMENTED 14 NULL NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('YES','NO') select,insert,update,references
+select table_name, column_name, data_type, column_type from information_schema.columns
+where table_schema="performance_schema" and data_type = "bigint"
+ order by table_name, column_name;
+table_name column_name data_type column_type
+cond_instances OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_stages_current EVENT_ID bigint bigint(20)
+events_stages_current NESTING_EVENT_ID bigint bigint(20)
+events_stages_current TIMER_END bigint bigint(20)
+events_stages_current TIMER_START bigint bigint(20)
+events_stages_current TIMER_WAIT bigint bigint(20)
+events_stages_history EVENT_ID bigint bigint(20)
+events_stages_history NESTING_EVENT_ID bigint bigint(20)
+events_stages_history TIMER_END bigint bigint(20)
+events_stages_history TIMER_START bigint bigint(20)
+events_stages_history TIMER_WAIT bigint bigint(20)
+events_stages_history_long EVENT_ID bigint bigint(20)
+events_stages_history_long NESTING_EVENT_ID bigint bigint(20)
+events_stages_history_long TIMER_END bigint bigint(20)
+events_stages_history_long TIMER_START bigint bigint(20)
+events_stages_history_long TIMER_WAIT bigint bigint(20)
+events_stages_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20)
+events_stages_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20)
+events_stages_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20)
+events_stages_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20)
+events_stages_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20)
+events_stages_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20)
+events_stages_summary_global_by_event_name COUNT_STAR bigint bigint(20)
+events_stages_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20)
+events_stages_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20)
+events_stages_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20)
+events_statements_current CREATED_TMP_DISK_TABLES bigint bigint(20)
+events_statements_current CREATED_TMP_TABLES bigint bigint(20)
+events_statements_current ERRORS bigint bigint(20)
+events_statements_current EVENT_ID bigint bigint(20)
+events_statements_current LOCK_TIME bigint bigint(20)
+events_statements_current NESTING_EVENT_ID bigint bigint(20)
+events_statements_current NO_GOOD_INDEX_USED bigint bigint(20)
+events_statements_current NO_INDEX_USED bigint bigint(20)
+events_statements_current OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_statements_current ROWS_AFFECTED bigint bigint(20)
+events_statements_current ROWS_EXAMINED bigint bigint(20)
+events_statements_current ROWS_SENT bigint bigint(20)
+events_statements_current SELECT_FULL_JOIN bigint bigint(20)
+events_statements_current SELECT_FULL_RANGE_JOIN bigint bigint(20)
+events_statements_current SELECT_RANGE bigint bigint(20)
+events_statements_current SELECT_RANGE_CHECK bigint bigint(20)
+events_statements_current SELECT_SCAN bigint bigint(20)
+events_statements_current SORT_MERGE_PASSES bigint bigint(20)
+events_statements_current SORT_RANGE bigint bigint(20)
+events_statements_current SORT_ROWS bigint bigint(20)
+events_statements_current SORT_SCAN bigint bigint(20)
+events_statements_current TIMER_END bigint bigint(20)
+events_statements_current TIMER_START bigint bigint(20)
+events_statements_current TIMER_WAIT bigint bigint(20)
+events_statements_current WARNINGS bigint bigint(20)
+events_statements_history CREATED_TMP_DISK_TABLES bigint bigint(20)
+events_statements_history CREATED_TMP_TABLES bigint bigint(20)
+events_statements_history ERRORS bigint bigint(20)
+events_statements_history EVENT_ID bigint bigint(20)
+events_statements_history LOCK_TIME bigint bigint(20)
+events_statements_history NESTING_EVENT_ID bigint bigint(20)
+events_statements_history NO_GOOD_INDEX_USED bigint bigint(20)
+events_statements_history NO_INDEX_USED bigint bigint(20)
+events_statements_history OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_statements_history ROWS_AFFECTED bigint bigint(20)
+events_statements_history ROWS_EXAMINED bigint bigint(20)
+events_statements_history ROWS_SENT bigint bigint(20)
+events_statements_history SELECT_FULL_JOIN bigint bigint(20)
+events_statements_history SELECT_FULL_RANGE_JOIN bigint bigint(20)
+events_statements_history SELECT_RANGE bigint bigint(20)
+events_statements_history SELECT_RANGE_CHECK bigint bigint(20)
+events_statements_history SELECT_SCAN bigint bigint(20)
+events_statements_history SORT_MERGE_PASSES bigint bigint(20)
+events_statements_history SORT_RANGE bigint bigint(20)
+events_statements_history SORT_ROWS bigint bigint(20)
+events_statements_history SORT_SCAN bigint bigint(20)
+events_statements_history TIMER_END bigint bigint(20)
+events_statements_history TIMER_START bigint bigint(20)
+events_statements_history TIMER_WAIT bigint bigint(20)
+events_statements_history WARNINGS bigint bigint(20)
+events_statements_history_long CREATED_TMP_DISK_TABLES bigint bigint(20)
+events_statements_history_long CREATED_TMP_TABLES bigint bigint(20)
+events_statements_history_long ERRORS bigint bigint(20)
+events_statements_history_long EVENT_ID bigint bigint(20)
+events_statements_history_long LOCK_TIME bigint bigint(20)
+events_statements_history_long NESTING_EVENT_ID bigint bigint(20)
+events_statements_history_long NO_GOOD_INDEX_USED bigint bigint(20)
+events_statements_history_long NO_INDEX_USED bigint bigint(20)
+events_statements_history_long OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_statements_history_long ROWS_AFFECTED bigint bigint(20)
+events_statements_history_long ROWS_EXAMINED bigint bigint(20)
+events_statements_history_long ROWS_SENT bigint bigint(20)
+events_statements_history_long SELECT_FULL_JOIN bigint bigint(20)
+events_statements_history_long SELECT_FULL_RANGE_JOIN bigint bigint(20)
+events_statements_history_long SELECT_RANGE bigint bigint(20)
+events_statements_history_long SELECT_RANGE_CHECK bigint bigint(20)
+events_statements_history_long SELECT_SCAN bigint bigint(20)
+events_statements_history_long SORT_MERGE_PASSES bigint bigint(20)
+events_statements_history_long SORT_RANGE bigint bigint(20)
+events_statements_history_long SORT_ROWS bigint bigint(20)
+events_statements_history_long SORT_SCAN bigint bigint(20)
+events_statements_history_long TIMER_END bigint bigint(20)
+events_statements_history_long TIMER_START bigint bigint(20)
+events_statements_history_long TIMER_WAIT bigint bigint(20)
+events_statements_history_long WARNINGS bigint bigint(20)
+events_statements_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20)
+events_statements_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20)
+events_statements_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20)
+events_statements_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_DISK_TABLES bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_TABLES bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_ERRORS bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_LOCK_TIME bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_NO_GOOD_INDEX_USED bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_NO_INDEX_USED bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_ROWS_AFFECTED bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_ROWS_EXAMINED bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_ROWS_SENT bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_JOIN bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_RANGE_JOIN bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE_CHECK bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SELECT_SCAN bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SORT_MERGE_PASSES bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SORT_RANGE bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SORT_ROWS bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_SORT_SCAN bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20)
+events_statements_summary_by_thread_by_event_name SUM_WARNINGS bigint bigint(20)
+events_statements_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20)
+events_statements_summary_global_by_event_name COUNT_STAR bigint bigint(20)
+events_statements_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20)
+events_statements_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_CREATED_TMP_DISK_TABLES bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_CREATED_TMP_TABLES bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_ERRORS bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_LOCK_TIME bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_NO_GOOD_INDEX_USED bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_NO_INDEX_USED bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_ROWS_AFFECTED bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_ROWS_EXAMINED bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_ROWS_SENT bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SELECT_FULL_JOIN bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SELECT_FULL_RANGE_JOIN bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SELECT_RANGE bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SELECT_RANGE_CHECK bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SELECT_SCAN bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SORT_MERGE_PASSES bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SORT_RANGE bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SORT_ROWS bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_SORT_SCAN bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20)
+events_statements_summary_global_by_event_name SUM_WARNINGS bigint bigint(20)
+events_waits_current EVENT_ID bigint bigint(20)
+events_waits_current NESTING_EVENT_ID bigint bigint(20)
+events_waits_current NUMBER_OF_BYTES bigint bigint(20)
+events_waits_current OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_waits_current TIMER_END bigint bigint(20)
+events_waits_current TIMER_START bigint bigint(20)
+events_waits_current TIMER_WAIT bigint bigint(20)
+events_waits_history EVENT_ID bigint bigint(20)
+events_waits_history NESTING_EVENT_ID bigint bigint(20)
+events_waits_history NUMBER_OF_BYTES bigint bigint(20)
+events_waits_history OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_waits_history TIMER_END bigint bigint(20)
+events_waits_history TIMER_START bigint bigint(20)
+events_waits_history TIMER_WAIT bigint bigint(20)
+events_waits_history_long EVENT_ID bigint bigint(20)
+events_waits_history_long NESTING_EVENT_ID bigint bigint(20)
+events_waits_history_long NUMBER_OF_BYTES bigint bigint(20)
+events_waits_history_long OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_waits_history_long TIMER_END bigint bigint(20)
+events_waits_history_long TIMER_START bigint bigint(20)
+events_waits_history_long TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_instance AVG_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_instance COUNT_STAR bigint bigint(20)
+events_waits_summary_by_instance MAX_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_instance MIN_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_instance OBJECT_INSTANCE_BEGIN bigint bigint(20)
+events_waits_summary_by_instance SUM_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20)
+events_waits_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20)
+events_waits_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20)
+events_waits_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20)
+events_waits_summary_global_by_event_name COUNT_STAR bigint bigint(20)
+events_waits_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20)
+events_waits_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20)
+events_waits_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20)
+file_summary_by_event_name COUNT_READ bigint bigint(20)
+file_summary_by_event_name COUNT_WRITE bigint bigint(20)
+file_summary_by_event_name SUM_NUMBER_OF_BYTES_READ bigint bigint(20)
+file_summary_by_event_name SUM_NUMBER_OF_BYTES_WRITE bigint bigint(20)
+file_summary_by_instance COUNT_READ bigint bigint(20)
+file_summary_by_instance COUNT_WRITE bigint bigint(20)
+file_summary_by_instance SUM_NUMBER_OF_BYTES_READ bigint bigint(20)
+file_summary_by_instance SUM_NUMBER_OF_BYTES_WRITE bigint bigint(20)
+mutex_instances OBJECT_INSTANCE_BEGIN bigint bigint(20)
+objects_summary_global_by_type AVG_TIMER_WAIT bigint bigint(20)
+objects_summary_global_by_type COUNT_STAR bigint bigint(20)
+objects_summary_global_by_type MAX_TIMER_WAIT bigint bigint(20)
+objects_summary_global_by_type MIN_TIMER_WAIT bigint bigint(20)
+objects_summary_global_by_type SUM_TIMER_WAIT bigint bigint(20)
+performance_timers TIMER_FREQUENCY bigint bigint(20)
+performance_timers TIMER_OVERHEAD bigint bigint(20)
+performance_timers TIMER_RESOLUTION bigint bigint(20)
+rwlock_instances OBJECT_INSTANCE_BEGIN bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_index_usage AVG_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_DELETE bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_FETCH bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_INSERT bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_READ bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_STAR bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_UPDATE bigint bigint(20)
+table_io_waits_summary_by_index_usage COUNT_WRITE bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_index_usage MAX_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_index_usage MIN_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_index_usage SUM_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_table AVG_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_table COUNT_DELETE bigint bigint(20)
+table_io_waits_summary_by_table COUNT_FETCH bigint bigint(20)
+table_io_waits_summary_by_table COUNT_INSERT bigint bigint(20)
+table_io_waits_summary_by_table COUNT_READ bigint bigint(20)
+table_io_waits_summary_by_table COUNT_STAR bigint bigint(20)
+table_io_waits_summary_by_table COUNT_UPDATE bigint bigint(20)
+table_io_waits_summary_by_table COUNT_WRITE bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_table MAX_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_table MIN_TIMER_WRITE bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_DELETE bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_FETCH bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_INSERT bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_READ bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_UPDATE bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_WAIT bigint bigint(20)
+table_io_waits_summary_by_table SUM_TIMER_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_READ bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_READ_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_READ_HIGH_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_READ_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_READ_NO_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WAIT bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE_ALLOW_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE_DELAYED bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE_LOW_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table AVG_TIMER_WRITE_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_READ bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_READ_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_READ_HIGH_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_READ_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_READ_NO_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_READ_WITH_SHARED_LOCKS bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_STAR bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE_ALLOW_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE_CONCURRENT_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE_DELAYED bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE_LOW_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table COUNT_WRITE_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_READ bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_READ_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_READ_HIGH_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_READ_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_READ_NO_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WAIT bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE_ALLOW_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE_DELAYED bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE_LOW_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table MAX_TIMER_WRITE_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_READ bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_READ_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_READ_HIGH_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_READ_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_READ_NO_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WAIT bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE_ALLOW_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE_DELAYED bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE_LOW_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table MIN_TIMER_WRITE_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_READ bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_READ_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_READ_HIGH_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_READ_NORMAL bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_READ_NO_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WAIT bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE_ALLOW_WRITE bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE_DELAYED bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE_EXTERNAL bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE_LOW_PRIORITY bigint bigint(20)
+table_lock_waits_summary_by_table SUM_TIMER_WRITE_NORMAL bigint bigint(20)
+threads PROCESSLIST_TIME bigint bigint(20)
+select table_name, column_name, data_type, column_type from information_schema.columns
+where table_schema="performance_schema" and data_type = "bigint" and column_type like "%unsigned"
+ order by table_name, column_name;
+table_name column_name data_type column_type
=== added file 'mysql-test/suite/perfschema/t/table_schema.test'
--- a/mysql-test/suite/perfschema/t/table_schema.test 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/table_schema.test 2011-05-24 20:31:16 +0000
@@ -0,0 +1,36 @@
+# Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved.
+#
+# This program is free software; you can redistribute it and/or modify
+# it under the terms of the GNU General Public License as published by
+# the Free Software Foundation; version 2 of the License.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software Foundation,
+# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA
+
+# Test to detect changest to the PERFORMANCE_SCHEMA table schemas
+
+--source include/not_embedded.inc
+--source include/have_perfschema.inc
+
+# Use the INFORMATION_SCHEMA to examine the tables in the PERFORMANCE_SCHEMA
+# and detect any tables that have changed.
+select * from information_schema.columns where table_schema="performance_schema" order by table_name, ordinal_position;
+
+# Bug#11766504 "59631: BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA"
+
+# Confirm that BIGINT columns exist.
+select table_name, column_name, data_type, column_type from information_schema.columns
+ where table_schema="performance_schema" and data_type = "bigint"
+ order by table_name, column_name;
+
+# Now confirm that the BIGINT columns are unsigned.
+select table_name, column_name, data_type, column_type from information_schema.columns
+ where table_schema="performance_schema" and data_type = "bigint" and column_type like "%unsigned"
+ order by table_name, column_name;
+
=== modified file 'scripts/mysql_system_tables.sql'
--- a/scripts/mysql_system_tables.sql 2011-05-05 22:46:07 +0000
+++ b/scripts/mysql_system_tables.sql 2011-05-24 20:31:16 +0000
@@ -189,22 +189,22 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_waits_current("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
"SPINS INTEGER unsigned,"
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(512),"
"INDEX_NAME VARCHAR(64),"
"OBJECT_TYPE VARCHAR(64),"
"OBJECT_INSTANCE_BEGIN BIGINT not null,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT'),"
"OPERATION VARCHAR(32) not null,"
- "NUMBER_OF_BYTES BIGINT unsigned,"
+ "NUMBER_OF_BYTES BIGINT,"
"FLAGS INTEGER unsigned"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -219,22 +219,22 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_waits_history("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
"SPINS INTEGER unsigned,"
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(512),"
"INDEX_NAME VARCHAR(64),"
"OBJECT_TYPE VARCHAR(64),"
"OBJECT_INSTANCE_BEGIN BIGINT not null,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT'),"
"OPERATION VARCHAR(32) not null,"
- "NUMBER_OF_BYTES BIGINT unsigned,"
+ "NUMBER_OF_BYTES BIGINT,"
"FLAGS INTEGER unsigned"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -249,22 +249,22 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_waits_history_long("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
"SPINS INTEGER unsigned,"
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(512),"
"INDEX_NAME VARCHAR(64),"
"OBJECT_TYPE VARCHAR(64),"
"OBJECT_INSTANCE_BEGIN BIGINT not null,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT'),"
"OPERATION VARCHAR(32) not null,"
- "NUMBER_OF_BYTES BIGINT unsigned,"
+ "NUMBER_OF_BYTES BIGINT,"
"FLAGS INTEGER unsigned"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -280,11 +280,11 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_waits_summary_by_instance("
"EVENT_NAME VARCHAR(128) not null,"
"OBJECT_INSTANCE_BEGIN BIGINT not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -299,11 +299,11 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_waits_summary_by_thread_by_event_name("
"THREAD_ID INTEGER not null,"
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -317,11 +317,11 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_waits_summary_global_by_event_name("
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -350,10 +350,10 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.file_summary_by_event_name("
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_READ BIGINT unsigned not null,"
- "COUNT_WRITE BIGINT unsigned not null,"
- "SUM_NUMBER_OF_BYTES_READ BIGINT unsigned not null,"
- "SUM_NUMBER_OF_BYTES_WRITE BIGINT unsigned not null"
+ "COUNT_READ BIGINT not null,"
+ "COUNT_WRITE BIGINT not null,"
+ "SUM_NUMBER_OF_BYTES_READ BIGINT not null,"
+ "SUM_NUMBER_OF_BYTES_WRITE BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -368,10 +368,10 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.file_summary_by_instance("
"FILE_NAME VARCHAR(512) not null,"
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_READ BIGINT unsigned not null,"
- "COUNT_WRITE BIGINT unsigned not null,"
- "SUM_NUMBER_OF_BYTES_READ BIGINT unsigned not null,"
- "SUM_NUMBER_OF_BYTES_WRITE BIGINT unsigned not null"
+ "COUNT_READ BIGINT not null,"
+ "COUNT_WRITE BIGINT not null,"
+ "SUM_NUMBER_OF_BYTES_READ BIGINT not null,"
+ "SUM_NUMBER_OF_BYTES_WRITE BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -402,11 +402,11 @@ SET @cmd="CREATE TABLE performance_schem
"OBJECT_TYPE VARCHAR(64),"
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(64),"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -529,41 +529,41 @@ SET @cmd="CREATE TABLE performance_schem
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(64),"
"INDEX_NAME VARCHAR(64),"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null,"
- "COUNT_READ BIGINT unsigned not null,"
- "SUM_TIMER_READ BIGINT unsigned not null,"
- "MIN_TIMER_READ BIGINT unsigned not null,"
- "AVG_TIMER_READ BIGINT unsigned not null,"
- "MAX_TIMER_READ BIGINT unsigned not null,"
- "COUNT_WRITE BIGINT unsigned not null,"
- "SUM_TIMER_WRITE BIGINT unsigned not null,"
- "MIN_TIMER_WRITE BIGINT unsigned not null,"
- "AVG_TIMER_WRITE BIGINT unsigned not null,"
- "MAX_TIMER_WRITE BIGINT unsigned not null,"
- "COUNT_FETCH BIGINT unsigned not null,"
- "SUM_TIMER_FETCH BIGINT unsigned not null,"
- "MIN_TIMER_FETCH BIGINT unsigned not null,"
- "AVG_TIMER_FETCH BIGINT unsigned not null,"
- "MAX_TIMER_FETCH BIGINT unsigned not null,"
- "COUNT_INSERT BIGINT unsigned not null,"
- "SUM_TIMER_INSERT BIGINT unsigned not null,"
- "MIN_TIMER_INSERT BIGINT unsigned not null,"
- "AVG_TIMER_INSERT BIGINT unsigned not null,"
- "MAX_TIMER_INSERT BIGINT unsigned not null,"
- "COUNT_UPDATE BIGINT unsigned not null,"
- "SUM_TIMER_UPDATE BIGINT unsigned not null,"
- "MIN_TIMER_UPDATE BIGINT unsigned not null,"
- "AVG_TIMER_UPDATE BIGINT unsigned not null,"
- "MAX_TIMER_UPDATE BIGINT unsigned not null,"
- "COUNT_DELETE BIGINT unsigned not null,"
- "SUM_TIMER_DELETE BIGINT unsigned not null,"
- "MIN_TIMER_DELETE BIGINT unsigned not null,"
- "AVG_TIMER_DELETE BIGINT unsigned not null,"
- "MAX_TIMER_DELETE BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null,"
+ "COUNT_READ BIGINT not null,"
+ "SUM_TIMER_READ BIGINT not null,"
+ "MIN_TIMER_READ BIGINT not null,"
+ "AVG_TIMER_READ BIGINT not null,"
+ "MAX_TIMER_READ BIGINT not null,"
+ "COUNT_WRITE BIGINT not null,"
+ "SUM_TIMER_WRITE BIGINT not null,"
+ "MIN_TIMER_WRITE BIGINT not null,"
+ "AVG_TIMER_WRITE BIGINT not null,"
+ "MAX_TIMER_WRITE BIGINT not null,"
+ "COUNT_FETCH BIGINT not null,"
+ "SUM_TIMER_FETCH BIGINT not null,"
+ "MIN_TIMER_FETCH BIGINT not null,"
+ "AVG_TIMER_FETCH BIGINT not null,"
+ "MAX_TIMER_FETCH BIGINT not null,"
+ "COUNT_INSERT BIGINT not null,"
+ "SUM_TIMER_INSERT BIGINT not null,"
+ "MIN_TIMER_INSERT BIGINT not null,"
+ "AVG_TIMER_INSERT BIGINT not null,"
+ "MAX_TIMER_INSERT BIGINT not null,"
+ "COUNT_UPDATE BIGINT not null,"
+ "SUM_TIMER_UPDATE BIGINT not null,"
+ "MIN_TIMER_UPDATE BIGINT not null,"
+ "AVG_TIMER_UPDATE BIGINT not null,"
+ "MAX_TIMER_UPDATE BIGINT not null,"
+ "COUNT_DELETE BIGINT not null,"
+ "SUM_TIMER_DELETE BIGINT not null,"
+ "MIN_TIMER_DELETE BIGINT not null,"
+ "AVG_TIMER_DELETE BIGINT not null,"
+ "MAX_TIMER_DELETE BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -579,41 +579,41 @@ SET @cmd="CREATE TABLE performance_schem
"OBJECT_TYPE VARCHAR(64),"
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(64),"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null,"
- "COUNT_READ BIGINT unsigned not null,"
- "SUM_TIMER_READ BIGINT unsigned not null,"
- "MIN_TIMER_READ BIGINT unsigned not null,"
- "AVG_TIMER_READ BIGINT unsigned not null,"
- "MAX_TIMER_READ BIGINT unsigned not null,"
- "COUNT_WRITE BIGINT unsigned not null,"
- "SUM_TIMER_WRITE BIGINT unsigned not null,"
- "MIN_TIMER_WRITE BIGINT unsigned not null,"
- "AVG_TIMER_WRITE BIGINT unsigned not null,"
- "MAX_TIMER_WRITE BIGINT unsigned not null,"
- "COUNT_FETCH BIGINT unsigned not null,"
- "SUM_TIMER_FETCH BIGINT unsigned not null,"
- "MIN_TIMER_FETCH BIGINT unsigned not null,"
- "AVG_TIMER_FETCH BIGINT unsigned not null,"
- "MAX_TIMER_FETCH BIGINT unsigned not null,"
- "COUNT_INSERT BIGINT unsigned not null,"
- "SUM_TIMER_INSERT BIGINT unsigned not null,"
- "MIN_TIMER_INSERT BIGINT unsigned not null,"
- "AVG_TIMER_INSERT BIGINT unsigned not null,"
- "MAX_TIMER_INSERT BIGINT unsigned not null,"
- "COUNT_UPDATE BIGINT unsigned not null,"
- "SUM_TIMER_UPDATE BIGINT unsigned not null,"
- "MIN_TIMER_UPDATE BIGINT unsigned not null,"
- "AVG_TIMER_UPDATE BIGINT unsigned not null,"
- "MAX_TIMER_UPDATE BIGINT unsigned not null,"
- "COUNT_DELETE BIGINT unsigned not null,"
- "SUM_TIMER_DELETE BIGINT unsigned not null,"
- "MIN_TIMER_DELETE BIGINT unsigned not null,"
- "AVG_TIMER_DELETE BIGINT unsigned not null,"
- "MAX_TIMER_DELETE BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null,"
+ "COUNT_READ BIGINT not null,"
+ "SUM_TIMER_READ BIGINT not null,"
+ "MIN_TIMER_READ BIGINT not null,"
+ "AVG_TIMER_READ BIGINT not null,"
+ "MAX_TIMER_READ BIGINT not null,"
+ "COUNT_WRITE BIGINT not null,"
+ "SUM_TIMER_WRITE BIGINT not null,"
+ "MIN_TIMER_WRITE BIGINT not null,"
+ "AVG_TIMER_WRITE BIGINT not null,"
+ "MAX_TIMER_WRITE BIGINT not null,"
+ "COUNT_FETCH BIGINT not null,"
+ "SUM_TIMER_FETCH BIGINT not null,"
+ "MIN_TIMER_FETCH BIGINT not null,"
+ "AVG_TIMER_FETCH BIGINT not null,"
+ "MAX_TIMER_FETCH BIGINT not null,"
+ "COUNT_INSERT BIGINT not null,"
+ "SUM_TIMER_INSERT BIGINT not null,"
+ "MIN_TIMER_INSERT BIGINT not null,"
+ "AVG_TIMER_INSERT BIGINT not null,"
+ "MAX_TIMER_INSERT BIGINT not null,"
+ "COUNT_UPDATE BIGINT not null,"
+ "SUM_TIMER_UPDATE BIGINT not null,"
+ "MIN_TIMER_UPDATE BIGINT not null,"
+ "AVG_TIMER_UPDATE BIGINT not null,"
+ "MAX_TIMER_UPDATE BIGINT not null,"
+ "COUNT_DELETE BIGINT not null,"
+ "SUM_TIMER_DELETE BIGINT not null,"
+ "MIN_TIMER_DELETE BIGINT not null,"
+ "AVG_TIMER_DELETE BIGINT not null,"
+ "MAX_TIMER_DELETE BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -629,76 +629,76 @@ SET @cmd="CREATE TABLE performance_schem
"OBJECT_TYPE VARCHAR(64),"
"OBJECT_SCHEMA VARCHAR(64),"
"OBJECT_NAME VARCHAR(64),"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null,"
- "COUNT_READ BIGINT unsigned not null,"
- "SUM_TIMER_READ BIGINT unsigned not null,"
- "MIN_TIMER_READ BIGINT unsigned not null,"
- "AVG_TIMER_READ BIGINT unsigned not null,"
- "MAX_TIMER_READ BIGINT unsigned not null,"
- "COUNT_WRITE BIGINT unsigned not null,"
- "SUM_TIMER_WRITE BIGINT unsigned not null,"
- "MIN_TIMER_WRITE BIGINT unsigned not null,"
- "AVG_TIMER_WRITE BIGINT unsigned not null,"
- "MAX_TIMER_WRITE BIGINT unsigned not null,"
- "COUNT_READ_NORMAL BIGINT unsigned not null,"
- "SUM_TIMER_READ_NORMAL BIGINT unsigned not null,"
- "MIN_TIMER_READ_NORMAL BIGINT unsigned not null,"
- "AVG_TIMER_READ_NORMAL BIGINT unsigned not null,"
- "MAX_TIMER_READ_NORMAL BIGINT unsigned not null,"
- "COUNT_READ_WITH_SHARED_LOCKS BIGINT unsigned not null,"
- "SUM_TIMER_READ_WITH_SHARED_LOCKS BIGINT unsigned not null,"
- "MIN_TIMER_READ_WITH_SHARED_LOCKS BIGINT unsigned not null,"
- "AVG_TIMER_READ_WITH_SHARED_LOCKS BIGINT unsigned not null,"
- "MAX_TIMER_READ_WITH_SHARED_LOCKS BIGINT unsigned not null,"
- "COUNT_READ_HIGH_PRIORITY BIGINT unsigned not null,"
- "SUM_TIMER_READ_HIGH_PRIORITY BIGINT unsigned not null,"
- "MIN_TIMER_READ_HIGH_PRIORITY BIGINT unsigned not null,"
- "AVG_TIMER_READ_HIGH_PRIORITY BIGINT unsigned not null,"
- "MAX_TIMER_READ_HIGH_PRIORITY BIGINT unsigned not null,"
- "COUNT_READ_NO_INSERT BIGINT unsigned not null,"
- "SUM_TIMER_READ_NO_INSERT BIGINT unsigned not null,"
- "MIN_TIMER_READ_NO_INSERT BIGINT unsigned not null,"
- "AVG_TIMER_READ_NO_INSERT BIGINT unsigned not null,"
- "MAX_TIMER_READ_NO_INSERT BIGINT unsigned not null,"
- "COUNT_READ_EXTERNAL BIGINT unsigned not null,"
- "SUM_TIMER_READ_EXTERNAL BIGINT unsigned not null,"
- "MIN_TIMER_READ_EXTERNAL BIGINT unsigned not null,"
- "AVG_TIMER_READ_EXTERNAL BIGINT unsigned not null,"
- "MAX_TIMER_READ_EXTERNAL BIGINT unsigned not null,"
- "COUNT_WRITE_ALLOW_WRITE BIGINT unsigned not null,"
- "SUM_TIMER_WRITE_ALLOW_WRITE BIGINT unsigned not null,"
- "MIN_TIMER_WRITE_ALLOW_WRITE BIGINT unsigned not null,"
- "AVG_TIMER_WRITE_ALLOW_WRITE BIGINT unsigned not null,"
- "MAX_TIMER_WRITE_ALLOW_WRITE BIGINT unsigned not null,"
- "COUNT_WRITE_CONCURRENT_INSERT BIGINT unsigned not null,"
- "SUM_TIMER_WRITE_CONCURRENT_INSERT BIGINT unsigned not null,"
- "MIN_TIMER_WRITE_CONCURRENT_INSERT BIGINT unsigned not null,"
- "AVG_TIMER_WRITE_CONCURRENT_INSERT BIGINT unsigned not null,"
- "MAX_TIMER_WRITE_CONCURRENT_INSERT BIGINT unsigned not null,"
- "COUNT_WRITE_DELAYED BIGINT unsigned not null,"
- "SUM_TIMER_WRITE_DELAYED BIGINT unsigned not null,"
- "MIN_TIMER_WRITE_DELAYED BIGINT unsigned not null,"
- "AVG_TIMER_WRITE_DELAYED BIGINT unsigned not null,"
- "MAX_TIMER_WRITE_DELAYED BIGINT unsigned not null,"
- "COUNT_WRITE_LOW_PRIORITY BIGINT unsigned not null,"
- "SUM_TIMER_WRITE_LOW_PRIORITY BIGINT unsigned not null,"
- "MIN_TIMER_WRITE_LOW_PRIORITY BIGINT unsigned not null,"
- "AVG_TIMER_WRITE_LOW_PRIORITY BIGINT unsigned not null,"
- "MAX_TIMER_WRITE_LOW_PRIORITY BIGINT unsigned not null,"
- "COUNT_WRITE_NORMAL BIGINT unsigned not null,"
- "SUM_TIMER_WRITE_NORMAL BIGINT unsigned not null,"
- "MIN_TIMER_WRITE_NORMAL BIGINT unsigned not null,"
- "AVG_TIMER_WRITE_NORMAL BIGINT unsigned not null,"
- "MAX_TIMER_WRITE_NORMAL BIGINT unsigned not null,"
- "COUNT_WRITE_EXTERNAL BIGINT unsigned not null,"
- "SUM_TIMER_WRITE_EXTERNAL BIGINT unsigned not null,"
- "MIN_TIMER_WRITE_EXTERNAL BIGINT unsigned not null,"
- "AVG_TIMER_WRITE_EXTERNAL BIGINT unsigned not null,"
- "MAX_TIMER_WRITE_EXTERNAL BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null,"
+ "COUNT_READ BIGINT not null,"
+ "SUM_TIMER_READ BIGINT not null,"
+ "MIN_TIMER_READ BIGINT not null,"
+ "AVG_TIMER_READ BIGINT not null,"
+ "MAX_TIMER_READ BIGINT not null,"
+ "COUNT_WRITE BIGINT not null,"
+ "SUM_TIMER_WRITE BIGINT not null,"
+ "MIN_TIMER_WRITE BIGINT not null,"
+ "AVG_TIMER_WRITE BIGINT not null,"
+ "MAX_TIMER_WRITE BIGINT not null,"
+ "COUNT_READ_NORMAL BIGINT not null,"
+ "SUM_TIMER_READ_NORMAL BIGINT not null,"
+ "MIN_TIMER_READ_NORMAL BIGINT not null,"
+ "AVG_TIMER_READ_NORMAL BIGINT not null,"
+ "MAX_TIMER_READ_NORMAL BIGINT not null,"
+ "COUNT_READ_WITH_SHARED_LOCKS BIGINT not null,"
+ "SUM_TIMER_READ_WITH_SHARED_LOCKS BIGINT not null,"
+ "MIN_TIMER_READ_WITH_SHARED_LOCKS BIGINT not null,"
+ "AVG_TIMER_READ_WITH_SHARED_LOCKS BIGINT not null,"
+ "MAX_TIMER_READ_WITH_SHARED_LOCKS BIGINT not null,"
+ "COUNT_READ_HIGH_PRIORITY BIGINT not null,"
+ "SUM_TIMER_READ_HIGH_PRIORITY BIGINT not null,"
+ "MIN_TIMER_READ_HIGH_PRIORITY BIGINT not null,"
+ "AVG_TIMER_READ_HIGH_PRIORITY BIGINT not null,"
+ "MAX_TIMER_READ_HIGH_PRIORITY BIGINT not null,"
+ "COUNT_READ_NO_INSERT BIGINT not null,"
+ "SUM_TIMER_READ_NO_INSERT BIGINT not null,"
+ "MIN_TIMER_READ_NO_INSERT BIGINT not null,"
+ "AVG_TIMER_READ_NO_INSERT BIGINT not null,"
+ "MAX_TIMER_READ_NO_INSERT BIGINT not null,"
+ "COUNT_READ_EXTERNAL BIGINT not null,"
+ "SUM_TIMER_READ_EXTERNAL BIGINT not null,"
+ "MIN_TIMER_READ_EXTERNAL BIGINT not null,"
+ "AVG_TIMER_READ_EXTERNAL BIGINT not null,"
+ "MAX_TIMER_READ_EXTERNAL BIGINT not null,"
+ "COUNT_WRITE_ALLOW_WRITE BIGINT not null,"
+ "SUM_TIMER_WRITE_ALLOW_WRITE BIGINT not null,"
+ "MIN_TIMER_WRITE_ALLOW_WRITE BIGINT not null,"
+ "AVG_TIMER_WRITE_ALLOW_WRITE BIGINT not null,"
+ "MAX_TIMER_WRITE_ALLOW_WRITE BIGINT not null,"
+ "COUNT_WRITE_CONCURRENT_INSERT BIGINT not null,"
+ "SUM_TIMER_WRITE_CONCURRENT_INSERT BIGINT not null,"
+ "MIN_TIMER_WRITE_CONCURRENT_INSERT BIGINT not null,"
+ "AVG_TIMER_WRITE_CONCURRENT_INSERT BIGINT not null,"
+ "MAX_TIMER_WRITE_CONCURRENT_INSERT BIGINT not null,"
+ "COUNT_WRITE_DELAYED BIGINT not null,"
+ "SUM_TIMER_WRITE_DELAYED BIGINT not null,"
+ "MIN_TIMER_WRITE_DELAYED BIGINT not null,"
+ "AVG_TIMER_WRITE_DELAYED BIGINT not null,"
+ "MAX_TIMER_WRITE_DELAYED BIGINT not null,"
+ "COUNT_WRITE_LOW_PRIORITY BIGINT not null,"
+ "SUM_TIMER_WRITE_LOW_PRIORITY BIGINT not null,"
+ "MIN_TIMER_WRITE_LOW_PRIORITY BIGINT not null,"
+ "AVG_TIMER_WRITE_LOW_PRIORITY BIGINT not null,"
+ "MAX_TIMER_WRITE_LOW_PRIORITY BIGINT not null,"
+ "COUNT_WRITE_NORMAL BIGINT not null,"
+ "SUM_TIMER_WRITE_NORMAL BIGINT not null,"
+ "MIN_TIMER_WRITE_NORMAL BIGINT not null,"
+ "AVG_TIMER_WRITE_NORMAL BIGINT not null,"
+ "MAX_TIMER_WRITE_NORMAL BIGINT not null,"
+ "COUNT_WRITE_EXTERNAL BIGINT not null,"
+ "SUM_TIMER_WRITE_EXTERNAL BIGINT not null,"
+ "MIN_TIMER_WRITE_EXTERNAL BIGINT not null,"
+ "AVG_TIMER_WRITE_EXTERNAL BIGINT not null,"
+ "MAX_TIMER_WRITE_EXTERNAL BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -738,13 +738,13 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_stages_current("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT')"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -759,13 +759,13 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_stages_history("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT')"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -780,13 +780,13 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_stages_history_long("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT')"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -802,11 +802,11 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_stages_summary_by_thread_by_event_name("
"THREAD_ID INTEGER not null,"
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -820,11 +820,11 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_stages_summary_global_by_event_name("
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -838,13 +838,13 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_statements_current("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
- "LOCK_TIME bigint unsigned not null,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
+ "LOCK_TIME BIGINT not null,"
"SQL_TEXT LONGTEXT,"
"CURRENT_SCHEMA VARCHAR(64),"
"OBJECT_TYPE VARCHAR(64),"
@@ -854,25 +854,25 @@ SET @cmd="CREATE TABLE performance_schem
"MYSQL_ERRNO INTEGER,"
"RETURNED_SQLSTATE VARCHAR(5),"
"MESSAGE_TEXT VARCHAR(128),"
- "ERRORS BIGINT unsigned not null,"
- "WARNINGS BIGINT unsigned not null,"
- "ROWS_AFFECTED BIGINT unsigned not null,"
- "ROWS_SENT BIGINT unsigned not null,"
- "ROWS_EXAMINED BIGINT unsigned not null,"
- "CREATED_TMP_DISK_TABLES BIGINT unsigned not null,"
- "CREATED_TMP_TABLES BIGINT unsigned not null,"
- "SELECT_FULL_JOIN BIGINT unsigned not null,"
- "SELECT_FULL_RANGE_JOIN BIGINT unsigned not null,"
- "SELECT_RANGE BIGINT unsigned not null,"
- "SELECT_RANGE_CHECK BIGINT unsigned not null,"
- "SELECT_SCAN BIGINT unsigned not null,"
- "SORT_MERGE_PASSES BIGINT unsigned not null,"
- "SORT_RANGE BIGINT unsigned not null,"
- "SORT_ROWS BIGINT unsigned not null,"
- "SORT_SCAN BIGINT unsigned not null,"
- "NO_INDEX_USED BIGINT unsigned not null,"
- "NO_GOOD_INDEX_USED BIGINT unsigned not null,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "ERRORS BIGINT not null,"
+ "WARNINGS BIGINT not null,"
+ "ROWS_AFFECTED BIGINT not null,"
+ "ROWS_SENT BIGINT not null,"
+ "ROWS_EXAMINED BIGINT not null,"
+ "CREATED_TMP_DISK_TABLES BIGINT not null,"
+ "CREATED_TMP_TABLES BIGINT not null,"
+ "SELECT_FULL_JOIN BIGINT not null,"
+ "SELECT_FULL_RANGE_JOIN BIGINT not null,"
+ "SELECT_RANGE BIGINT not null,"
+ "SELECT_RANGE_CHECK BIGINT not null,"
+ "SELECT_SCAN BIGINT not null,"
+ "SORT_MERGE_PASSES BIGINT not null,"
+ "SORT_RANGE BIGINT not null,"
+ "SORT_ROWS BIGINT not null,"
+ "SORT_SCAN BIGINT not null,"
+ "NO_INDEX_USED BIGINT not null,"
+ "NO_GOOD_INDEX_USED BIGINT not null,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT')"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -887,13 +887,13 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_statements_history("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
- "LOCK_TIME bigint unsigned not null,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
+ "LOCK_TIME BIGINT not null,"
"SQL_TEXT LONGTEXT,"
"CURRENT_SCHEMA VARCHAR(64),"
"OBJECT_TYPE VARCHAR(64),"
@@ -903,25 +903,25 @@ SET @cmd="CREATE TABLE performance_schem
"MYSQL_ERRNO INTEGER,"
"RETURNED_SQLSTATE VARCHAR(5),"
"MESSAGE_TEXT VARCHAR(128),"
- "ERRORS BIGINT unsigned not null,"
- "WARNINGS BIGINT unsigned not null,"
- "ROWS_AFFECTED BIGINT unsigned not null,"
- "ROWS_SENT BIGINT unsigned not null,"
- "ROWS_EXAMINED BIGINT unsigned not null,"
- "CREATED_TMP_DISK_TABLES BIGINT unsigned not null,"
- "CREATED_TMP_TABLES BIGINT unsigned not null,"
- "SELECT_FULL_JOIN BIGINT unsigned not null,"
- "SELECT_FULL_RANGE_JOIN BIGINT unsigned not null,"
- "SELECT_RANGE BIGINT unsigned not null,"
- "SELECT_RANGE_CHECK BIGINT unsigned not null,"
- "SELECT_SCAN BIGINT unsigned not null,"
- "SORT_MERGE_PASSES BIGINT unsigned not null,"
- "SORT_RANGE BIGINT unsigned not null,"
- "SORT_ROWS BIGINT unsigned not null,"
- "SORT_SCAN BIGINT unsigned not null,"
- "NO_INDEX_USED BIGINT unsigned not null,"
- "NO_GOOD_INDEX_USED BIGINT unsigned not null,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "ERRORS BIGINT not null,"
+ "WARNINGS BIGINT not null,"
+ "ROWS_AFFECTED BIGINT not null,"
+ "ROWS_SENT BIGINT not null,"
+ "ROWS_EXAMINED BIGINT not null,"
+ "CREATED_TMP_DISK_TABLES BIGINT not null,"
+ "CREATED_TMP_TABLES BIGINT not null,"
+ "SELECT_FULL_JOIN BIGINT not null,"
+ "SELECT_FULL_RANGE_JOIN BIGINT not null,"
+ "SELECT_RANGE BIGINT not null,"
+ "SELECT_RANGE_CHECK BIGINT not null,"
+ "SELECT_SCAN BIGINT not null,"
+ "SORT_MERGE_PASSES BIGINT not null,"
+ "SORT_RANGE BIGINT not null,"
+ "SORT_ROWS BIGINT not null,"
+ "SORT_SCAN BIGINT not null,"
+ "NO_INDEX_USED BIGINT not null,"
+ "NO_GOOD_INDEX_USED BIGINT not null,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT')"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -936,13 +936,13 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_statements_history_long("
"THREAD_ID INTEGER not null,"
- "EVENT_ID BIGINT unsigned not null,"
+ "EVENT_ID BIGINT not null,"
"EVENT_NAME VARCHAR(128) not null,"
"SOURCE VARCHAR(64),"
- "TIMER_START BIGINT unsigned,"
- "TIMER_END BIGINT unsigned,"
- "TIMER_WAIT BIGINT unsigned,"
- "LOCK_TIME bigint unsigned not null,"
+ "TIMER_START BIGINT,"
+ "TIMER_END BIGINT,"
+ "TIMER_WAIT BIGINT,"
+ "LOCK_TIME BIGINT not null,"
"SQL_TEXT LONGTEXT,"
"CURRENT_SCHEMA VARCHAR(64),"
"OBJECT_TYPE VARCHAR(64),"
@@ -952,25 +952,25 @@ SET @cmd="CREATE TABLE performance_schem
"MYSQL_ERRNO INTEGER,"
"RETURNED_SQLSTATE VARCHAR(5),"
"MESSAGE_TEXT VARCHAR(128),"
- "ERRORS BIGINT unsigned not null,"
- "WARNINGS BIGINT unsigned not null,"
- "ROWS_AFFECTED BIGINT unsigned not null,"
- "ROWS_SENT BIGINT unsigned not null,"
- "ROWS_EXAMINED BIGINT unsigned not null,"
- "CREATED_TMP_DISK_TABLES BIGINT unsigned not null,"
- "CREATED_TMP_TABLES BIGINT unsigned not null,"
- "SELECT_FULL_JOIN BIGINT unsigned not null,"
- "SELECT_FULL_RANGE_JOIN BIGINT unsigned not null,"
- "SELECT_RANGE BIGINT unsigned not null,"
- "SELECT_RANGE_CHECK BIGINT unsigned not null,"
- "SELECT_SCAN BIGINT unsigned not null,"
- "SORT_MERGE_PASSES BIGINT unsigned not null,"
- "SORT_RANGE BIGINT unsigned not null,"
- "SORT_ROWS BIGINT unsigned not null,"
- "SORT_SCAN BIGINT unsigned not null,"
- "NO_INDEX_USED BIGINT unsigned not null,"
- "NO_GOOD_INDEX_USED BIGINT unsigned not null,"
- "NESTING_EVENT_ID BIGINT unsigned,"
+ "ERRORS BIGINT not null,"
+ "WARNINGS BIGINT not null,"
+ "ROWS_AFFECTED BIGINT not null,"
+ "ROWS_SENT BIGINT not null,"
+ "ROWS_EXAMINED BIGINT not null,"
+ "CREATED_TMP_DISK_TABLES BIGINT not null,"
+ "CREATED_TMP_TABLES BIGINT not null,"
+ "SELECT_FULL_JOIN BIGINT not null,"
+ "SELECT_FULL_RANGE_JOIN BIGINT not null,"
+ "SELECT_RANGE BIGINT not null,"
+ "SELECT_RANGE_CHECK BIGINT not null,"
+ "SELECT_SCAN BIGINT not null,"
+ "SORT_MERGE_PASSES BIGINT not null,"
+ "SORT_RANGE BIGINT not null,"
+ "SORT_ROWS BIGINT not null,"
+ "SORT_SCAN BIGINT not null,"
+ "NO_INDEX_USED BIGINT not null,"
+ "NO_GOOD_INDEX_USED BIGINT not null,"
+ "NESTING_EVENT_ID BIGINT,"
"NESTING_EVENT_TYPE ENUM('STATEMENT', 'STAGE', 'WAIT')"
")ENGINE=PERFORMANCE_SCHEMA;";
@@ -986,30 +986,30 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_statements_summary_by_thread_by_event_name("
"THREAD_ID INTEGER not null,"
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null,"
- "SUM_LOCK_TIME BIGINT unsigned not null,"
- "SUM_ERRORS BIGINT unsigned not null,"
- "SUM_WARNINGS BIGINT unsigned not null,"
- "SUM_ROWS_AFFECTED BIGINT unsigned not null,"
- "SUM_ROWS_SENT BIGINT unsigned not null,"
- "SUM_ROWS_EXAMINED BIGINT unsigned not null,"
- "SUM_CREATED_TMP_DISK_TABLES BIGINT unsigned not null,"
- "SUM_CREATED_TMP_TABLES BIGINT unsigned not null,"
- "SUM_SELECT_FULL_JOIN BIGINT unsigned not null,"
- "SUM_SELECT_FULL_RANGE_JOIN BIGINT unsigned not null,"
- "SUM_SELECT_RANGE BIGINT unsigned not null,"
- "SUM_SELECT_RANGE_CHECK BIGINT unsigned not null,"
- "SUM_SELECT_SCAN BIGINT unsigned not null,"
- "SUM_SORT_MERGE_PASSES BIGINT unsigned not null,"
- "SUM_SORT_RANGE BIGINT unsigned not null,"
- "SUM_SORT_ROWS BIGINT unsigned not null,"
- "SUM_SORT_SCAN BIGINT unsigned not null,"
- "SUM_NO_INDEX_USED BIGINT unsigned not null,"
- "SUM_NO_GOOD_INDEX_USED BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null,"
+ "SUM_LOCK_TIME BIGINT not null,"
+ "SUM_ERRORS BIGINT not null,"
+ "SUM_WARNINGS BIGINT not null,"
+ "SUM_ROWS_AFFECTED BIGINT not null,"
+ "SUM_ROWS_SENT BIGINT not null,"
+ "SUM_ROWS_EXAMINED BIGINT not null,"
+ "SUM_CREATED_TMP_DISK_TABLES BIGINT not null,"
+ "SUM_CREATED_TMP_TABLES BIGINT not null,"
+ "SUM_SELECT_FULL_JOIN BIGINT not null,"
+ "SUM_SELECT_FULL_RANGE_JOIN BIGINT not null,"
+ "SUM_SELECT_RANGE BIGINT not null,"
+ "SUM_SELECT_RANGE_CHECK BIGINT not null,"
+ "SUM_SELECT_SCAN BIGINT not null,"
+ "SUM_SORT_MERGE_PASSES BIGINT not null,"
+ "SUM_SORT_RANGE BIGINT not null,"
+ "SUM_SORT_ROWS BIGINT not null,"
+ "SUM_SORT_SCAN BIGINT not null,"
+ "SUM_NO_INDEX_USED BIGINT not null,"
+ "SUM_NO_GOOD_INDEX_USED BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
@@ -1023,30 +1023,30 @@ DROP PREPARE stmt;
SET @cmd="CREATE TABLE performance_schema.events_statements_summary_global_by_event_name("
"EVENT_NAME VARCHAR(128) not null,"
- "COUNT_STAR BIGINT unsigned not null,"
- "SUM_TIMER_WAIT BIGINT unsigned not null,"
- "MIN_TIMER_WAIT BIGINT unsigned not null,"
- "AVG_TIMER_WAIT BIGINT unsigned not null,"
- "MAX_TIMER_WAIT BIGINT unsigned not null,"
- "SUM_LOCK_TIME BIGINT unsigned not null,"
- "SUM_ERRORS BIGINT unsigned not null,"
- "SUM_WARNINGS BIGINT unsigned not null,"
- "SUM_ROWS_AFFECTED BIGINT unsigned not null,"
- "SUM_ROWS_SENT BIGINT unsigned not null,"
- "SUM_ROWS_EXAMINED BIGINT unsigned not null,"
- "SUM_CREATED_TMP_DISK_TABLES BIGINT unsigned not null,"
- "SUM_CREATED_TMP_TABLES BIGINT unsigned not null,"
- "SUM_SELECT_FULL_JOIN BIGINT unsigned not null,"
- "SUM_SELECT_FULL_RANGE_JOIN BIGINT unsigned not null,"
- "SUM_SELECT_RANGE BIGINT unsigned not null,"
- "SUM_SELECT_RANGE_CHECK BIGINT unsigned not null,"
- "SUM_SELECT_SCAN BIGINT unsigned not null,"
- "SUM_SORT_MERGE_PASSES BIGINT unsigned not null,"
- "SUM_SORT_RANGE BIGINT unsigned not null,"
- "SUM_SORT_ROWS BIGINT unsigned not null,"
- "SUM_SORT_SCAN BIGINT unsigned not null,"
- "SUM_NO_INDEX_USED BIGINT unsigned not null,"
- "SUM_NO_GOOD_INDEX_USED BIGINT unsigned not null"
+ "COUNT_STAR BIGINT not null,"
+ "SUM_TIMER_WAIT BIGINT not null,"
+ "MIN_TIMER_WAIT BIGINT not null,"
+ "AVG_TIMER_WAIT BIGINT not null,"
+ "MAX_TIMER_WAIT BIGINT not null,"
+ "SUM_LOCK_TIME BIGINT not null,"
+ "SUM_ERRORS BIGINT not null,"
+ "SUM_WARNINGS BIGINT not null,"
+ "SUM_ROWS_AFFECTED BIGINT not null,"
+ "SUM_ROWS_SENT BIGINT not null,"
+ "SUM_ROWS_EXAMINED BIGINT not null,"
+ "SUM_CREATED_TMP_DISK_TABLES BIGINT not null,"
+ "SUM_CREATED_TMP_TABLES BIGINT not null,"
+ "SUM_SELECT_FULL_JOIN BIGINT not null,"
+ "SUM_SELECT_FULL_RANGE_JOIN BIGINT not null,"
+ "SUM_SELECT_RANGE BIGINT not null,"
+ "SUM_SELECT_RANGE_CHECK BIGINT not null,"
+ "SUM_SELECT_SCAN BIGINT not null,"
+ "SUM_SORT_MERGE_PASSES BIGINT not null,"
+ "SUM_SORT_RANGE BIGINT not null,"
+ "SUM_SORT_ROWS BIGINT not null,"
+ "SUM_SORT_SCAN BIGINT not null,"
+ "SUM_NO_INDEX_USED BIGINT not null,"
+ "SUM_NO_GOOD_INDEX_USED BIGINT not null"
")ENGINE=PERFORMANCE_SCHEMA;";
SET @str = IF(@have_pfs = 1, @cmd, 'SET @dummy = 0');
Attachment: [text/bzr-bundle] bzr/chris.powers@oracle.com-20110524203116-vh2qmoa0oaagfftr.bundle
| Thread |
|---|
| • bzr commit into mysql-trunk branch (chris.powers:3107) Bug#11766504 | Christopher Powers | 24 May |
