From: Christopher Powers Date: June 10 2011 6:20pm Subject: bzr commit into mysql-trunk branch (chris.powers:3180) Bug#11766504 List-Archive: http://lists.mysql.com/commits/139101 X-Bug: 11766504 Message-Id: <20110610182057.8EC371DB033E@xeno.mysql.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1874289871460800448==" --===============1874289871460800448== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///home/cpowers/work/dev/mysql-trunk-bigint/ based on revid:chris.powers@stripped 3180 Christopher Powers 2011-06-10 Bug#11766504 "59631: BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA" - Improved test to verify perfschema column types modified: mysql-test/suite/perfschema/r/table_schema.result* mysql-test/suite/perfschema/t/table_schema.test === modified file 'mysql-test/suite/perfschema/r/table_schema.result' (properties changed: +x to -x) --- a/mysql-test/suite/perfschema/r/table_schema.result 2011-06-10 17:03:45 +0000 +++ b/mysql-test/suite/perfschema/r/table_schema.result 2011-06-10 18:20:50 +0000 @@ -1,4 +1,5 @@ -select * from information_schema.columns where table_schema="performance_schema" order by table_name, ordinal_position; +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 @@ -489,680 +490,16 @@ def performance_schema threads PROCESSLI 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 +select count(*) 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) unsigned -events_stages_current NESTING_EVENT_ID bigint bigint(20) unsigned -events_stages_current TIMER_END bigint bigint(20) unsigned -events_stages_current TIMER_START bigint bigint(20) unsigned -events_stages_current TIMER_WAIT bigint bigint(20) unsigned -events_stages_history EVENT_ID bigint bigint(20) unsigned -events_stages_history NESTING_EVENT_ID bigint bigint(20) unsigned -events_stages_history TIMER_END bigint bigint(20) unsigned -events_stages_history TIMER_START bigint bigint(20) unsigned -events_stages_history TIMER_WAIT bigint bigint(20) unsigned -events_stages_history_long EVENT_ID bigint bigint(20) unsigned -events_stages_history_long NESTING_EVENT_ID bigint bigint(20) unsigned -events_stages_history_long TIMER_END bigint bigint(20) unsigned -events_stages_history_long TIMER_START bigint bigint(20) unsigned -events_stages_history_long TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_stages_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_statements_current CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_current CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_current ERRORS bigint bigint(20) unsigned -events_statements_current EVENT_ID bigint bigint(20) unsigned -events_statements_current LOCK_TIME bigint bigint(20) unsigned -events_statements_current NESTING_EVENT_ID bigint bigint(20) unsigned -events_statements_current NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_current NO_INDEX_USED bigint bigint(20) unsigned -events_statements_current OBJECT_INSTANCE_BEGIN bigint bigint(20) -events_statements_current ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_current ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_current ROWS_SENT bigint bigint(20) unsigned -events_statements_current SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_current SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_current SELECT_RANGE bigint bigint(20) unsigned -events_statements_current SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_current SELECT_SCAN bigint bigint(20) unsigned -events_statements_current SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_current SORT_RANGE bigint bigint(20) unsigned -events_statements_current SORT_ROWS bigint bigint(20) unsigned -events_statements_current SORT_SCAN bigint bigint(20) unsigned -events_statements_current TIMER_END bigint bigint(20) unsigned -events_statements_current TIMER_START bigint bigint(20) unsigned -events_statements_current TIMER_WAIT bigint bigint(20) unsigned -events_statements_current WARNINGS bigint bigint(20) unsigned -events_statements_history CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_history CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_history ERRORS bigint bigint(20) unsigned -events_statements_history EVENT_ID bigint bigint(20) unsigned -events_statements_history LOCK_TIME bigint bigint(20) unsigned -events_statements_history NESTING_EVENT_ID bigint bigint(20) unsigned -events_statements_history NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_history NO_INDEX_USED bigint bigint(20) unsigned -events_statements_history OBJECT_INSTANCE_BEGIN bigint bigint(20) -events_statements_history ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_history ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_history ROWS_SENT bigint bigint(20) unsigned -events_statements_history SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_history SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_history SELECT_RANGE bigint bigint(20) unsigned -events_statements_history SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_history SELECT_SCAN bigint bigint(20) unsigned -events_statements_history SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_history SORT_RANGE bigint bigint(20) unsigned -events_statements_history SORT_ROWS bigint bigint(20) unsigned -events_statements_history SORT_SCAN bigint bigint(20) unsigned -events_statements_history TIMER_END bigint bigint(20) unsigned -events_statements_history TIMER_START bigint bigint(20) unsigned -events_statements_history TIMER_WAIT bigint bigint(20) unsigned -events_statements_history WARNINGS bigint bigint(20) unsigned -events_statements_history_long CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_history_long CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_history_long ERRORS bigint bigint(20) unsigned -events_statements_history_long EVENT_ID bigint bigint(20) unsigned -events_statements_history_long LOCK_TIME bigint bigint(20) unsigned -events_statements_history_long NESTING_EVENT_ID bigint bigint(20) unsigned -events_statements_history_long NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_history_long NO_INDEX_USED bigint bigint(20) unsigned -events_statements_history_long OBJECT_INSTANCE_BEGIN bigint bigint(20) -events_statements_history_long ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_history_long ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_history_long ROWS_SENT bigint bigint(20) unsigned -events_statements_history_long SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_history_long SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_history_long SELECT_RANGE bigint bigint(20) unsigned -events_statements_history_long SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_history_long SELECT_SCAN bigint bigint(20) unsigned -events_statements_history_long SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_history_long SORT_RANGE bigint bigint(20) unsigned -events_statements_history_long SORT_ROWS bigint bigint(20) unsigned -events_statements_history_long SORT_SCAN bigint bigint(20) unsigned -events_statements_history_long TIMER_END bigint bigint(20) unsigned -events_statements_history_long TIMER_START bigint bigint(20) unsigned -events_statements_history_long TIMER_WAIT bigint bigint(20) unsigned -events_statements_history_long WARNINGS bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ERRORS bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_LOCK_TIME bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_NO_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ROWS_SENT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_SCAN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_RANGE bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_ROWS bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_SCAN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_WARNINGS bigint bigint(20) unsigned -events_statements_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_statements_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ERRORS bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_LOCK_TIME bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_NO_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ROWS_SENT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_RANGE bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_SCAN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_RANGE bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_ROWS bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_SCAN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_WARNINGS bigint bigint(20) unsigned -events_waits_current EVENT_ID bigint bigint(20) unsigned -events_waits_current NESTING_EVENT_ID bigint bigint(20) unsigned -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) unsigned -events_waits_current TIMER_START bigint bigint(20) unsigned -events_waits_current TIMER_WAIT bigint bigint(20) unsigned -events_waits_history EVENT_ID bigint bigint(20) unsigned -events_waits_history NESTING_EVENT_ID bigint bigint(20) unsigned -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) unsigned -events_waits_history TIMER_START bigint bigint(20) unsigned -events_waits_history TIMER_WAIT bigint bigint(20) unsigned -events_waits_history_long EVENT_ID bigint bigint(20) unsigned -events_waits_history_long NESTING_EVENT_ID bigint bigint(20) unsigned -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) unsigned -events_waits_history_long TIMER_START bigint bigint(20) unsigned -events_waits_history_long TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance AVG_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance COUNT_STAR bigint bigint(20) unsigned -events_waits_summary_by_instance MAX_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance MIN_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance OBJECT_INSTANCE_BEGIN bigint bigint(20) -events_waits_summary_by_instance SUM_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_waits_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -file_summary_by_event_name COUNT_READ bigint bigint(20) unsigned -file_summary_by_event_name COUNT_WRITE bigint bigint(20) unsigned -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) unsigned -file_summary_by_instance COUNT_WRITE bigint bigint(20) unsigned -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) unsigned -objects_summary_global_by_type COUNT_STAR bigint bigint(20) unsigned -objects_summary_global_by_type MAX_TIMER_WAIT bigint bigint(20) unsigned -objects_summary_global_by_type MIN_TIMER_WAIT bigint bigint(20) unsigned -objects_summary_global_by_type SUM_TIMER_WAIT bigint bigint(20) unsigned -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) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_STAR bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_STAR bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_STAR bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -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 -events_stages_current EVENT_ID bigint bigint(20) unsigned -events_stages_current NESTING_EVENT_ID bigint bigint(20) unsigned -events_stages_current TIMER_END bigint bigint(20) unsigned -events_stages_current TIMER_START bigint bigint(20) unsigned -events_stages_current TIMER_WAIT bigint bigint(20) unsigned -events_stages_history EVENT_ID bigint bigint(20) unsigned -events_stages_history NESTING_EVENT_ID bigint bigint(20) unsigned -events_stages_history TIMER_END bigint bigint(20) unsigned -events_stages_history TIMER_START bigint bigint(20) unsigned -events_stages_history TIMER_WAIT bigint bigint(20) unsigned -events_stages_history_long EVENT_ID bigint bigint(20) unsigned -events_stages_history_long NESTING_EVENT_ID bigint bigint(20) unsigned -events_stages_history_long TIMER_END bigint bigint(20) unsigned -events_stages_history_long TIMER_START bigint bigint(20) unsigned -events_stages_history_long TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_stages_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_stages_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_statements_current CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_current CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_current ERRORS bigint bigint(20) unsigned -events_statements_current EVENT_ID bigint bigint(20) unsigned -events_statements_current LOCK_TIME bigint bigint(20) unsigned -events_statements_current NESTING_EVENT_ID bigint bigint(20) unsigned -events_statements_current NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_current NO_INDEX_USED bigint bigint(20) unsigned -events_statements_current ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_current ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_current ROWS_SENT bigint bigint(20) unsigned -events_statements_current SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_current SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_current SELECT_RANGE bigint bigint(20) unsigned -events_statements_current SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_current SELECT_SCAN bigint bigint(20) unsigned -events_statements_current SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_current SORT_RANGE bigint bigint(20) unsigned -events_statements_current SORT_ROWS bigint bigint(20) unsigned -events_statements_current SORT_SCAN bigint bigint(20) unsigned -events_statements_current TIMER_END bigint bigint(20) unsigned -events_statements_current TIMER_START bigint bigint(20) unsigned -events_statements_current TIMER_WAIT bigint bigint(20) unsigned -events_statements_current WARNINGS bigint bigint(20) unsigned -events_statements_history CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_history CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_history ERRORS bigint bigint(20) unsigned -events_statements_history EVENT_ID bigint bigint(20) unsigned -events_statements_history LOCK_TIME bigint bigint(20) unsigned -events_statements_history NESTING_EVENT_ID bigint bigint(20) unsigned -events_statements_history NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_history NO_INDEX_USED bigint bigint(20) unsigned -events_statements_history ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_history ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_history ROWS_SENT bigint bigint(20) unsigned -events_statements_history SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_history SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_history SELECT_RANGE bigint bigint(20) unsigned -events_statements_history SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_history SELECT_SCAN bigint bigint(20) unsigned -events_statements_history SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_history SORT_RANGE bigint bigint(20) unsigned -events_statements_history SORT_ROWS bigint bigint(20) unsigned -events_statements_history SORT_SCAN bigint bigint(20) unsigned -events_statements_history TIMER_END bigint bigint(20) unsigned -events_statements_history TIMER_START bigint bigint(20) unsigned -events_statements_history TIMER_WAIT bigint bigint(20) unsigned -events_statements_history WARNINGS bigint bigint(20) unsigned -events_statements_history_long CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_history_long CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_history_long ERRORS bigint bigint(20) unsigned -events_statements_history_long EVENT_ID bigint bigint(20) unsigned -events_statements_history_long LOCK_TIME bigint bigint(20) unsigned -events_statements_history_long NESTING_EVENT_ID bigint bigint(20) unsigned -events_statements_history_long NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_history_long NO_INDEX_USED bigint bigint(20) unsigned -events_statements_history_long ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_history_long ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_history_long ROWS_SENT bigint bigint(20) unsigned -events_statements_history_long SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_history_long SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_history_long SELECT_RANGE bigint bigint(20) unsigned -events_statements_history_long SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_history_long SELECT_SCAN bigint bigint(20) unsigned -events_statements_history_long SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_history_long SORT_RANGE bigint bigint(20) unsigned -events_statements_history_long SORT_ROWS bigint bigint(20) unsigned -events_statements_history_long SORT_SCAN bigint bigint(20) unsigned -events_statements_history_long TIMER_END bigint bigint(20) unsigned -events_statements_history_long TIMER_START bigint bigint(20) unsigned -events_statements_history_long TIMER_WAIT bigint bigint(20) unsigned -events_statements_history_long WARNINGS bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ERRORS bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_LOCK_TIME bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_NO_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_ROWS_SENT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SELECT_SCAN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_RANGE bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_ROWS bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_SORT_SCAN bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_by_thread_by_event_name SUM_WARNINGS bigint bigint(20) unsigned -events_statements_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_statements_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_CREATED_TMP_DISK_TABLES bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_CREATED_TMP_TABLES bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ERRORS bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_LOCK_TIME bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_NO_GOOD_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_NO_INDEX_USED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ROWS_AFFECTED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ROWS_EXAMINED bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_ROWS_SENT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_FULL_JOIN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_FULL_RANGE_JOIN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_RANGE bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_RANGE_CHECK bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SELECT_SCAN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_MERGE_PASSES bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_RANGE bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_ROWS bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_SORT_SCAN bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_statements_summary_global_by_event_name SUM_WARNINGS bigint bigint(20) unsigned -events_waits_current EVENT_ID bigint bigint(20) unsigned -events_waits_current NESTING_EVENT_ID bigint bigint(20) unsigned -events_waits_current TIMER_END bigint bigint(20) unsigned -events_waits_current TIMER_START bigint bigint(20) unsigned -events_waits_current TIMER_WAIT bigint bigint(20) unsigned -events_waits_history EVENT_ID bigint bigint(20) unsigned -events_waits_history NESTING_EVENT_ID bigint bigint(20) unsigned -events_waits_history TIMER_END bigint bigint(20) unsigned -events_waits_history TIMER_START bigint bigint(20) unsigned -events_waits_history TIMER_WAIT bigint bigint(20) unsigned -events_waits_history_long EVENT_ID bigint bigint(20) unsigned -events_waits_history_long NESTING_EVENT_ID bigint bigint(20) unsigned -events_waits_history_long TIMER_END bigint bigint(20) unsigned -events_waits_history_long TIMER_START bigint bigint(20) unsigned -events_waits_history_long TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance AVG_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance COUNT_STAR bigint bigint(20) unsigned -events_waits_summary_by_instance MAX_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance MIN_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_instance SUM_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_by_thread_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name AVG_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name COUNT_STAR bigint bigint(20) unsigned -events_waits_summary_global_by_event_name MAX_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name MIN_TIMER_WAIT bigint bigint(20) unsigned -events_waits_summary_global_by_event_name SUM_TIMER_WAIT bigint bigint(20) unsigned -file_summary_by_event_name COUNT_READ bigint bigint(20) unsigned -file_summary_by_event_name COUNT_WRITE bigint bigint(20) unsigned -file_summary_by_instance COUNT_READ bigint bigint(20) unsigned -file_summary_by_instance COUNT_WRITE bigint bigint(20) unsigned -objects_summary_global_by_type AVG_TIMER_WAIT bigint bigint(20) unsigned -objects_summary_global_by_type COUNT_STAR bigint bigint(20) unsigned -objects_summary_global_by_type MAX_TIMER_WAIT bigint bigint(20) unsigned -objects_summary_global_by_type MIN_TIMER_WAIT bigint bigint(20) unsigned -objects_summary_global_by_type SUM_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage AVG_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_STAR bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage COUNT_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MAX_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage MIN_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_index_usage SUM_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table AVG_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_STAR bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table COUNT_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table MAX_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table MIN_TIMER_WRITE bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_DELETE bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_FETCH bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_INSERT bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_READ bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_UPDATE bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_WAIT bigint bigint(20) unsigned -table_io_waits_summary_by_table SUM_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table AVG_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_STAR bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table COUNT_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MAX_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table MIN_TIMER_WRITE_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_HIGH_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_NORMAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_NO_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_READ_WITH_SHARED_LOCKS bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WAIT bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_ALLOW_WRITE bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_CONCURRENT_INSERT bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_DELAYED bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_EXTERNAL bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_LOW_PRIORITY bigint bigint(20) unsigned -table_lock_waits_summary_by_table SUM_TIMER_WRITE_NORMAL bigint bigint(20) unsigned + and column_name like "%number_of_bytes" into @count_columns; +select @count_columns > 0; +@count_columns > 0 +1 +select count(*) from information_schema.columns +where table_schema="performance_schema" and data_type="bigint" + and column_name like "%number_of_bytes" + and column_type not like "%unsigned" into @count_signed; +select @count_columns - @count_signed; +@count_columns - @count_signed +0 === modified file 'mysql-test/suite/perfschema/t/table_schema.test' --- a/mysql-test/suite/perfschema/t/table_schema.test 2011-06-10 17:03:45 +0000 +++ b/mysql-test/suite/perfschema/t/table_schema.test 2011-06-10 18:20:50 +0000 @@ -20,17 +20,28 @@ # 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; + +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 +# Goal: Confirm that all byte related columns are BIGINT signed. This test will +# not have to be changed to accommodate new or deleted columns. + +# Count the number of NUMBER_OF_BYTES columns. +select count(*) from information_schema.columns where table_schema="performance_schema" and data_type = "bigint" - order by table_name, column_name; + and column_name like "%number_of_bytes" into @count_columns; + +# Confirm that at least one column was found. +select @count_columns > 0; + +# Confirm that all NUMBER_OF_BYTES columns are BIGINT signed. +select count(*) from information_schema.columns + where table_schema="performance_schema" and data_type="bigint" + and column_name like "%number_of_bytes" + and column_type not like "%unsigned" into @count_signed; -# 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; +select @count_columns - @count_signed; --===============1874289871460800448== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/chris.powers@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: chris.powers@stripped # target_branch: file:///home/cpowers/work/dev/mysql-trunk-bigint/ # testament_sha1: 0f5c4894070a4d493436ce49357c98cdd90ad8e9 # timestamp: 2011-06-10 13:20:57 -0500 # base_revision_id: chris.powers@stripped\ # f49qedbd6qa7vgsp # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWYSVDMQAArvfgAAQWnf//3/n 3iC////wYAZ8XwABrQAAAADRU8piPU0MgAyGgAAAGgHpAOYExNBhMmTJkYTBNNMjEwBDAcwJiaDC ZMmTIwmCaaZGJgCGAaaInqao/SjZCH6kaA0AAAA0AAcwJiaDCZMmTIwmCaaZGJgCGASSAmgJkAmI DIpsagNT0UyGymjwpojNhZdiiPcqF9PwXxhLq8hhioFc0fKvbY6SEFv0YIkxKLOoWcaiysorvE1E zggFqAdwTFH5FSWjB355BIT2YZUvWhZOMxkMGBLXa7LGLDYwKXbOAkBQawMzgnDCHkGW1h6HWvM/ wblh8E8HAhLQU5CdsFNMGyA4lAp9vzZyD2FKf2KoH0Bhw7Uysh+cTzITLpuWcePCy+IWqyEXctDT LYfFh5oPdycPVZxJHs5cvMw67xfBM0GQHmj/mkVgSzbwce8LByq/v8DeXCtG5C3mQHbzRwlsK95V y2m/ezFpwFoEoCThaC6kTcaY+bJGGIDm2vL7uaQMPcYg5Ae0cicAIxQEIkucPfef9h3BFXEyt8wL Ls5WBYZHuKiwKmWTBAxOy4zYoCiAs2GzpjZUkHjGUKiPLPoP0XO0h9FMPxZpeXdBUPQXe/U8CZqO 3jwNugtOBaZGDNt4KF2w6cUggbQKbpWjX7YPZjeTyojyHmwvIGiphmwzxWbWZqqF7q9Mka32llxQ uqLCFheBZdcESTloM1qMTCIyYZFqHYNgqtRrLa6TzvojBBjEY3N0IspfonpjrcKwvIGkCVlUlQuQ Fz1CKyK4zNOFoRszDECCORZaRQVYXzLiDy6Vr9tVtAuYrYijPKgwwGVK7hoDK7TFp3yMLXGE9TzI ssiXmJet1V199VVw6hMZiiPaA6MSUXQc1QqoabmlYqNBgC5ilaCLmGTILkYtTZTcpMpWHagCiBJO 35lFurcMyCwS+p9aojDMM8iH3P34+vrF7BA9KMRl+FwBI7x1hYCksE2hZG2ybURSIWXUpJoOiVEg pKjGLEnB97WJPNTsyoYFPMOsDrY1pOBj4B4m//EAiJhEkDjtOpAeBIXi6f5REKj5+wHIWf54CXOh g9HvPXE+dBwFdwTgBjk4uS+N05KLua0uSh0UzgelDQoa2K0WaTXaj2nrNC5/yVLiHuQfLUel5wPl mt1mRvD5mDunN1oRkj0NKYd97ZsJTA+gahOHDDhwlLfAPwhcEh41wmGGQzG2+vg3QXatRQNCLCsJ mkjaFEXnF6O8fxL+CcTn/Anl9fE7A76HS6Yfr+ZEwDMOAfV9nFhsOvfJcT/Jx/YgWF12bYnPMEMb wYR05tD4DCP61VkNNIAeaPEs7c+LVzsw62q+7jdWI8ckIesyYLQHwM7ar3hAMEUpzST5H1Y7H7Xo a5bGRo7ooj27zYZ+JzQ7Ydp3FQbjrWS8jwMxirBsgecXick98+f7CkniXQjiaQO45HSJuhXMrXoR v6Q/08S+mdByqM5jv9qGh3qPJZkETuFuFhsKGes8kYPFrTB9uGuN5QZMK1eGIluQ0TvYxxNmpqHA WtEl47Qoh9Q8NaaZQSY2sMC0wSGFGDGXUFO0QvAYWSZCmNRCHoUkVC7QGNczRUSEJ0Yr+GlAkkwM JhxnFeTQqoIluQNFk9KPYdU7SarED1MYL2AYZDkOTMEPyD1s3pfo2gf1XopkG0QniYArQoc+KiWQ +Ik5DguQs70xwWqFViAp9piV9e1hg1j17jODDfEJXQbcU0HoJdFtnQB8Ee1F71Y3Tg5J6QdzBAeG ZyVqs7oKIr28ElwVELd0ClnJgEYstyW1kX0cSQw4SYgJSxrrBEy4RfsZQVDAcFiLhxYHlgBsRtux YVLUOTbTcRYGTBa5jLBhjk5wbHDx8WEcxkMOKsif7sMzgqjfN11MohM2pgtZeg1V+3EyICsCSvE4 Nc3BLWEtJ3kzZ67rFWjMIWF3gOEEes3YwqWHqjYjzGyAhJJMupuwwO1KbXjkZsZGA85nV0o4yQ4z /IDerP/i7kinChIQkqGYgA== --===============1874289871460800448==--