List:Commits« Previous MessageNext Message »
From:Christopher Powers Date:June 9 2011 6:44pm
Subject:bzr commit into mysql-trunk branch (chris.powers:3108) Bug#11766504
View as plain text  
#At file:///home/cpowers/work/dev/mysql-trunk-bigint/ based on revid:chris.powers@stripped

 3108 Christopher Powers	2011-06-09
      Bug#11766504 "BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA"
      
      First pass at a fix

    modified:
      mysql-test/suite/perfschema/r/schema.result
=== modified file 'mysql-test/suite/perfschema/r/schema.result'
--- a/mysql-test/suite/perfschema/r/schema.result	2011-05-17 09:15:47 +0000
+++ b/mysql-test/suite/perfschema/r/schema.result	2011-06-09 18:44:20 +0000
@@ -50,39 +50,39 @@ show create table events_stages_current;
 Table	Create Table
 events_stages_current	CREATE TABLE `events_stages_current` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_stages_history;
 Table	Create Table
 events_stages_history	CREATE TABLE `events_stages_history` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_stages_history_long;
 Table	Create Table
 events_stages_history_long	CREATE TABLE `events_stages_history_long` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_stages_summary_by_thread_by_event_name;
@@ -90,33 +90,33 @@ Table	Create Table
 events_stages_summary_by_thread_by_event_name	CREATE TABLE `events_stages_summary_by_thread_by_event_name` (
   `THREAD_ID` int(11) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_stages_summary_global_by_event_name;
 Table	Create Table
 events_stages_summary_global_by_event_name	CREATE TABLE `events_stages_summary_global_by_event_name` (
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_statements_current;
 Table	Create Table
 events_statements_current	CREATE TABLE `events_statements_current` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
-  `LOCK_TIME` bigint(20) unsigned NOT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
+  `LOCK_TIME` bigint(20) NOT NULL,
   `SQL_TEXT` longtext,
   `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
@@ -126,38 +126,38 @@ events_statements_current	CREATE TABLE `
   `MYSQL_ERRNO` int(11) DEFAULT NULL,
   `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
   `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
-  `ERRORS` bigint(20) unsigned NOT NULL,
-  `WARNINGS` bigint(20) unsigned NOT NULL,
-  `ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
-  `ROWS_SENT` bigint(20) unsigned NOT NULL,
-  `ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
-  `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
-  `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
-  `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
-  `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
-  `SELECT_RANGE` bigint(20) unsigned NOT NULL,
-  `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
-  `SELECT_SCAN` bigint(20) unsigned NOT NULL,
-  `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
-  `SORT_RANGE` bigint(20) unsigned NOT NULL,
-  `SORT_ROWS` bigint(20) unsigned NOT NULL,
-  `SORT_SCAN` bigint(20) unsigned NOT NULL,
-  `NO_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `ERRORS` bigint(20) NOT NULL,
+  `WARNINGS` bigint(20) NOT NULL,
+  `ROWS_AFFECTED` bigint(20) NOT NULL,
+  `ROWS_SENT` bigint(20) NOT NULL,
+  `ROWS_EXAMINED` bigint(20) NOT NULL,
+  `CREATED_TMP_DISK_TABLES` bigint(20) NOT NULL,
+  `CREATED_TMP_TABLES` bigint(20) NOT NULL,
+  `SELECT_FULL_JOIN` bigint(20) NOT NULL,
+  `SELECT_FULL_RANGE_JOIN` bigint(20) NOT NULL,
+  `SELECT_RANGE` bigint(20) NOT NULL,
+  `SELECT_RANGE_CHECK` bigint(20) NOT NULL,
+  `SELECT_SCAN` bigint(20) NOT NULL,
+  `SORT_MERGE_PASSES` bigint(20) NOT NULL,
+  `SORT_RANGE` bigint(20) NOT NULL,
+  `SORT_ROWS` bigint(20) NOT NULL,
+  `SORT_SCAN` bigint(20) NOT NULL,
+  `NO_INDEX_USED` bigint(20) NOT NULL,
+  `NO_GOOD_INDEX_USED` bigint(20) NOT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_statements_history;
 Table	Create Table
 events_statements_history	CREATE TABLE `events_statements_history` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
-  `LOCK_TIME` bigint(20) unsigned NOT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
+  `LOCK_TIME` bigint(20) NOT NULL,
   `SQL_TEXT` longtext,
   `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
@@ -167,38 +167,38 @@ events_statements_history	CREATE TABLE `
   `MYSQL_ERRNO` int(11) DEFAULT NULL,
   `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
   `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
-  `ERRORS` bigint(20) unsigned NOT NULL,
-  `WARNINGS` bigint(20) unsigned NOT NULL,
-  `ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
-  `ROWS_SENT` bigint(20) unsigned NOT NULL,
-  `ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
-  `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
-  `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
-  `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
-  `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
-  `SELECT_RANGE` bigint(20) unsigned NOT NULL,
-  `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
-  `SELECT_SCAN` bigint(20) unsigned NOT NULL,
-  `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
-  `SORT_RANGE` bigint(20) unsigned NOT NULL,
-  `SORT_ROWS` bigint(20) unsigned NOT NULL,
-  `SORT_SCAN` bigint(20) unsigned NOT NULL,
-  `NO_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `ERRORS` bigint(20) NOT NULL,
+  `WARNINGS` bigint(20) NOT NULL,
+  `ROWS_AFFECTED` bigint(20) NOT NULL,
+  `ROWS_SENT` bigint(20) NOT NULL,
+  `ROWS_EXAMINED` bigint(20) NOT NULL,
+  `CREATED_TMP_DISK_TABLES` bigint(20) NOT NULL,
+  `CREATED_TMP_TABLES` bigint(20) NOT NULL,
+  `SELECT_FULL_JOIN` bigint(20) NOT NULL,
+  `SELECT_FULL_RANGE_JOIN` bigint(20) NOT NULL,
+  `SELECT_RANGE` bigint(20) NOT NULL,
+  `SELECT_RANGE_CHECK` bigint(20) NOT NULL,
+  `SELECT_SCAN` bigint(20) NOT NULL,
+  `SORT_MERGE_PASSES` bigint(20) NOT NULL,
+  `SORT_RANGE` bigint(20) NOT NULL,
+  `SORT_ROWS` bigint(20) NOT NULL,
+  `SORT_SCAN` bigint(20) NOT NULL,
+  `NO_INDEX_USED` bigint(20) NOT NULL,
+  `NO_GOOD_INDEX_USED` bigint(20) NOT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_statements_history_long;
 Table	Create Table
 events_statements_history_long	CREATE TABLE `events_statements_history_long` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
-  `LOCK_TIME` bigint(20) unsigned NOT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
+  `LOCK_TIME` bigint(20) NOT NULL,
   `SQL_TEXT` longtext,
   `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
@@ -208,25 +208,25 @@ events_statements_history_long	CREATE TA
   `MYSQL_ERRNO` int(11) DEFAULT NULL,
   `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
   `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
-  `ERRORS` bigint(20) unsigned NOT NULL,
-  `WARNINGS` bigint(20) unsigned NOT NULL,
-  `ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
-  `ROWS_SENT` bigint(20) unsigned NOT NULL,
-  `ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
-  `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
-  `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
-  `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
-  `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
-  `SELECT_RANGE` bigint(20) unsigned NOT NULL,
-  `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
-  `SELECT_SCAN` bigint(20) unsigned NOT NULL,
-  `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
-  `SORT_RANGE` bigint(20) unsigned NOT NULL,
-  `SORT_ROWS` bigint(20) unsigned NOT NULL,
-  `SORT_SCAN` bigint(20) unsigned NOT NULL,
-  `NO_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `ERRORS` bigint(20) NOT NULL,
+  `WARNINGS` bigint(20) NOT NULL,
+  `ROWS_AFFECTED` bigint(20) NOT NULL,
+  `ROWS_SENT` bigint(20) NOT NULL,
+  `ROWS_EXAMINED` bigint(20) NOT NULL,
+  `CREATED_TMP_DISK_TABLES` bigint(20) NOT NULL,
+  `CREATED_TMP_TABLES` bigint(20) NOT NULL,
+  `SELECT_FULL_JOIN` bigint(20) NOT NULL,
+  `SELECT_FULL_RANGE_JOIN` bigint(20) NOT NULL,
+  `SELECT_RANGE` bigint(20) NOT NULL,
+  `SELECT_RANGE_CHECK` bigint(20) NOT NULL,
+  `SELECT_SCAN` bigint(20) NOT NULL,
+  `SORT_MERGE_PASSES` bigint(20) NOT NULL,
+  `SORT_RANGE` bigint(20) NOT NULL,
+  `SORT_ROWS` bigint(20) NOT NULL,
+  `SORT_SCAN` bigint(20) NOT NULL,
+  `NO_INDEX_USED` bigint(20) NOT NULL,
+  `NO_GOOD_INDEX_USED` bigint(20) NOT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_statements_summary_by_thread_by_event_name;
@@ -234,124 +234,124 @@ Table	Create Table
 events_statements_summary_by_thread_by_event_name	CREATE TABLE `events_statements_summary_by_thread_by_event_name` (
   `THREAD_ID` int(11) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
-  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
-  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
-  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
-  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
-  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
-  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
-  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
-  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL,
+  `SUM_LOCK_TIME` bigint(20) NOT NULL,
+  `SUM_ERRORS` bigint(20) NOT NULL,
+  `SUM_WARNINGS` bigint(20) NOT NULL,
+  `SUM_ROWS_AFFECTED` bigint(20) NOT NULL,
+  `SUM_ROWS_SENT` bigint(20) NOT NULL,
+  `SUM_ROWS_EXAMINED` bigint(20) NOT NULL,
+  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) NOT NULL,
+  `SUM_CREATED_TMP_TABLES` bigint(20) NOT NULL,
+  `SUM_SELECT_FULL_JOIN` bigint(20) NOT NULL,
+  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) NOT NULL,
+  `SUM_SELECT_RANGE` bigint(20) NOT NULL,
+  `SUM_SELECT_RANGE_CHECK` bigint(20) NOT NULL,
+  `SUM_SELECT_SCAN` bigint(20) NOT NULL,
+  `SUM_SORT_MERGE_PASSES` bigint(20) NOT NULL,
+  `SUM_SORT_RANGE` bigint(20) NOT NULL,
+  `SUM_SORT_ROWS` bigint(20) NOT NULL,
+  `SUM_SORT_SCAN` bigint(20) NOT NULL,
+  `SUM_NO_INDEX_USED` bigint(20) NOT NULL,
+  `SUM_NO_GOOD_INDEX_USED` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_statements_summary_global_by_event_name;
 Table	Create Table
 events_statements_summary_global_by_event_name	CREATE TABLE `events_statements_summary_global_by_event_name` (
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
-  `SUM_ERRORS` bigint(20) unsigned NOT NULL,
-  `SUM_WARNINGS` bigint(20) unsigned NOT NULL,
-  `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
-  `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
-  `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
-  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
-  `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
-  `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
-  `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
-  `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
-  `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL,
+  `SUM_LOCK_TIME` bigint(20) NOT NULL,
+  `SUM_ERRORS` bigint(20) NOT NULL,
+  `SUM_WARNINGS` bigint(20) NOT NULL,
+  `SUM_ROWS_AFFECTED` bigint(20) NOT NULL,
+  `SUM_ROWS_SENT` bigint(20) NOT NULL,
+  `SUM_ROWS_EXAMINED` bigint(20) NOT NULL,
+  `SUM_CREATED_TMP_DISK_TABLES` bigint(20) NOT NULL,
+  `SUM_CREATED_TMP_TABLES` bigint(20) NOT NULL,
+  `SUM_SELECT_FULL_JOIN` bigint(20) NOT NULL,
+  `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) NOT NULL,
+  `SUM_SELECT_RANGE` bigint(20) NOT NULL,
+  `SUM_SELECT_RANGE_CHECK` bigint(20) NOT NULL,
+  `SUM_SELECT_SCAN` bigint(20) NOT NULL,
+  `SUM_SORT_MERGE_PASSES` bigint(20) NOT NULL,
+  `SUM_SORT_RANGE` bigint(20) NOT NULL,
+  `SUM_SORT_ROWS` bigint(20) NOT NULL,
+  `SUM_SORT_SCAN` bigint(20) NOT NULL,
+  `SUM_NO_INDEX_USED` bigint(20) NOT NULL,
+  `SUM_NO_GOOD_INDEX_USED` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_waits_current;
 Table	Create Table
 events_waits_current	CREATE TABLE `events_waits_current` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
   `SPINS` int(10) unsigned DEFAULT NULL,
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(512) DEFAULT NULL,
   `INDEX_NAME` varchar(64) DEFAULT NULL,
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
   `OBJECT_INSTANCE_BEGIN` bigint(20) NOT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL,
   `OPERATION` varchar(32) NOT NULL,
-  `NUMBER_OF_BYTES` bigint(20) unsigned DEFAULT NULL,
+  `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL,
   `FLAGS` int(10) unsigned DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_waits_history;
 Table	Create Table
 events_waits_history	CREATE TABLE `events_waits_history` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
   `SPINS` int(10) unsigned DEFAULT NULL,
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(512) DEFAULT NULL,
   `INDEX_NAME` varchar(64) DEFAULT NULL,
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
   `OBJECT_INSTANCE_BEGIN` bigint(20) NOT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL,
   `OPERATION` varchar(32) NOT NULL,
-  `NUMBER_OF_BYTES` bigint(20) unsigned DEFAULT NULL,
+  `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL,
   `FLAGS` int(10) unsigned DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_waits_history_long;
 Table	Create Table
 events_waits_history_long	CREATE TABLE `events_waits_history_long` (
   `THREAD_ID` int(11) NOT NULL,
-  `EVENT_ID` bigint(20) unsigned NOT NULL,
+  `EVENT_ID` bigint(20) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
   `SOURCE` varchar(64) DEFAULT NULL,
-  `TIMER_START` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_END` bigint(20) unsigned DEFAULT NULL,
-  `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL,
+  `TIMER_START` bigint(20) DEFAULT NULL,
+  `TIMER_END` bigint(20) DEFAULT NULL,
+  `TIMER_WAIT` bigint(20) DEFAULT NULL,
   `SPINS` int(10) unsigned DEFAULT NULL,
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(512) DEFAULT NULL,
   `INDEX_NAME` varchar(64) DEFAULT NULL,
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
   `OBJECT_INSTANCE_BEGIN` bigint(20) NOT NULL,
-  `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
+  `NESTING_EVENT_ID` bigint(20) DEFAULT NULL,
   `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL,
   `OPERATION` varchar(32) NOT NULL,
-  `NUMBER_OF_BYTES` bigint(20) unsigned DEFAULT NULL,
+  `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL,
   `FLAGS` int(10) unsigned DEFAULT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_waits_summary_by_instance;
@@ -359,32 +359,32 @@ Table	Create Table
 events_waits_summary_by_instance	CREATE TABLE `events_waits_summary_by_instance` (
   `EVENT_NAME` varchar(128) NOT NULL,
   `OBJECT_INSTANCE_BEGIN` bigint(20) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_waits_summary_by_thread_by_event_name;
 Table	Create Table
 events_waits_summary_by_thread_by_event_name	CREATE TABLE `events_waits_summary_by_thread_by_event_name` (
   `THREAD_ID` int(11) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table events_waits_summary_global_by_event_name;
 Table	Create Table
 events_waits_summary_global_by_event_name	CREATE TABLE `events_waits_summary_global_by_event_name` (
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table file_instances;
 Table	Create Table
@@ -397,20 +397,20 @@ show create table file_summary_by_event_
 Table	Create Table
 file_summary_by_event_name	CREATE TABLE `file_summary_by_event_name` (
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_READ` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
-  `SUM_NUMBER_OF_BYTES_READ` bigint(20) unsigned NOT NULL,
-  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL
+  `COUNT_READ` bigint(20) NOT NULL,
+  `COUNT_WRITE` bigint(20) NOT NULL,
+  `SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL,
+  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table file_summary_by_instance;
 Table	Create Table
 file_summary_by_instance	CREATE TABLE `file_summary_by_instance` (
   `FILE_NAME` varchar(512) NOT NULL,
   `EVENT_NAME` varchar(128) NOT NULL,
-  `COUNT_READ` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
-  `SUM_NUMBER_OF_BYTES_READ` bigint(20) unsigned NOT NULL,
-  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL
+  `COUNT_READ` bigint(20) NOT NULL,
+  `COUNT_WRITE` bigint(20) NOT NULL,
+  `SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL,
+  `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table mutex_instances;
 Table	Create Table
@@ -425,11 +425,11 @@ objects_summary_global_by_type	CREATE TA
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(64) DEFAULT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table performance_timers;
 Table	Create Table
@@ -488,41 +488,41 @@ table_io_waits_summary_by_index_usage	CR
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(64) DEFAULT NULL,
   `INDEX_NAME` varchar(64) DEFAULT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `COUNT_READ` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `COUNT_FETCH` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `COUNT_INSERT` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `COUNT_UPDATE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `COUNT_DELETE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL,
+  `COUNT_READ` bigint(20) NOT NULL,
+  `SUM_TIMER_READ` bigint(20) NOT NULL,
+  `MIN_TIMER_READ` bigint(20) NOT NULL,
+  `AVG_TIMER_READ` bigint(20) NOT NULL,
+  `MAX_TIMER_READ` bigint(20) NOT NULL,
+  `COUNT_WRITE` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE` bigint(20) NOT NULL,
+  `COUNT_FETCH` bigint(20) NOT NULL,
+  `SUM_TIMER_FETCH` bigint(20) NOT NULL,
+  `MIN_TIMER_FETCH` bigint(20) NOT NULL,
+  `AVG_TIMER_FETCH` bigint(20) NOT NULL,
+  `MAX_TIMER_FETCH` bigint(20) NOT NULL,
+  `COUNT_INSERT` bigint(20) NOT NULL,
+  `SUM_TIMER_INSERT` bigint(20) NOT NULL,
+  `MIN_TIMER_INSERT` bigint(20) NOT NULL,
+  `AVG_TIMER_INSERT` bigint(20) NOT NULL,
+  `MAX_TIMER_INSERT` bigint(20) NOT NULL,
+  `COUNT_UPDATE` bigint(20) NOT NULL,
+  `SUM_TIMER_UPDATE` bigint(20) NOT NULL,
+  `MIN_TIMER_UPDATE` bigint(20) NOT NULL,
+  `AVG_TIMER_UPDATE` bigint(20) NOT NULL,
+  `MAX_TIMER_UPDATE` bigint(20) NOT NULL,
+  `COUNT_DELETE` bigint(20) NOT NULL,
+  `SUM_TIMER_DELETE` bigint(20) NOT NULL,
+  `MIN_TIMER_DELETE` bigint(20) NOT NULL,
+  `AVG_TIMER_DELETE` bigint(20) NOT NULL,
+  `MAX_TIMER_DELETE` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table table_io_waits_summary_by_table;
 Table	Create Table
@@ -530,41 +530,41 @@ table_io_waits_summary_by_table	CREATE T
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(64) DEFAULT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `COUNT_READ` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `COUNT_FETCH` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL,
-  `COUNT_INSERT` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL,
-  `COUNT_UPDATE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
-  `COUNT_DELETE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL,
+  `COUNT_READ` bigint(20) NOT NULL,
+  `SUM_TIMER_READ` bigint(20) NOT NULL,
+  `MIN_TIMER_READ` bigint(20) NOT NULL,
+  `AVG_TIMER_READ` bigint(20) NOT NULL,
+  `MAX_TIMER_READ` bigint(20) NOT NULL,
+  `COUNT_WRITE` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE` bigint(20) NOT NULL,
+  `COUNT_FETCH` bigint(20) NOT NULL,
+  `SUM_TIMER_FETCH` bigint(20) NOT NULL,
+  `MIN_TIMER_FETCH` bigint(20) NOT NULL,
+  `AVG_TIMER_FETCH` bigint(20) NOT NULL,
+  `MAX_TIMER_FETCH` bigint(20) NOT NULL,
+  `COUNT_INSERT` bigint(20) NOT NULL,
+  `SUM_TIMER_INSERT` bigint(20) NOT NULL,
+  `MIN_TIMER_INSERT` bigint(20) NOT NULL,
+  `AVG_TIMER_INSERT` bigint(20) NOT NULL,
+  `MAX_TIMER_INSERT` bigint(20) NOT NULL,
+  `COUNT_UPDATE` bigint(20) NOT NULL,
+  `SUM_TIMER_UPDATE` bigint(20) NOT NULL,
+  `MIN_TIMER_UPDATE` bigint(20) NOT NULL,
+  `AVG_TIMER_UPDATE` bigint(20) NOT NULL,
+  `MAX_TIMER_UPDATE` bigint(20) NOT NULL,
+  `COUNT_DELETE` bigint(20) NOT NULL,
+  `SUM_TIMER_DELETE` bigint(20) NOT NULL,
+  `MIN_TIMER_DELETE` bigint(20) NOT NULL,
+  `AVG_TIMER_DELETE` bigint(20) NOT NULL,
+  `MAX_TIMER_DELETE` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table table_lock_waits_summary_by_table;
 Table	Create Table
@@ -572,76 +572,76 @@ table_lock_waits_summary_by_table	CREATE
   `OBJECT_TYPE` varchar(64) DEFAULT NULL,
   `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
   `OBJECT_NAME` varchar(64) DEFAULT NULL,
-  `COUNT_STAR` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
-  `COUNT_READ` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
-  `COUNT_READ_NORMAL` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
-  `COUNT_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
-  `COUNT_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
-  `COUNT_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
-  `COUNT_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
-  `COUNT_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `SUM_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `MIN_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `AVG_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
-  `MAX_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL
+  `COUNT_STAR` bigint(20) NOT NULL,
+  `SUM_TIMER_WAIT` bigint(20) NOT NULL,
+  `MIN_TIMER_WAIT` bigint(20) NOT NULL,
+  `AVG_TIMER_WAIT` bigint(20) NOT NULL,
+  `MAX_TIMER_WAIT` bigint(20) NOT NULL,
+  `COUNT_READ` bigint(20) NOT NULL,
+  `SUM_TIMER_READ` bigint(20) NOT NULL,
+  `MIN_TIMER_READ` bigint(20) NOT NULL,
+  `AVG_TIMER_READ` bigint(20) NOT NULL,
+  `MAX_TIMER_READ` bigint(20) NOT NULL,
+  `COUNT_WRITE` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE` bigint(20) NOT NULL,
+  `COUNT_READ_NORMAL` bigint(20) NOT NULL,
+  `SUM_TIMER_READ_NORMAL` bigint(20) NOT NULL,
+  `MIN_TIMER_READ_NORMAL` bigint(20) NOT NULL,
+  `AVG_TIMER_READ_NORMAL` bigint(20) NOT NULL,
+  `MAX_TIMER_READ_NORMAL` bigint(20) NOT NULL,
+  `COUNT_READ_WITH_SHARED_LOCKS` bigint(20) NOT NULL,
+  `SUM_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) NOT NULL,
+  `MIN_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) NOT NULL,
+  `AVG_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) NOT NULL,
+  `MAX_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) NOT NULL,
+  `COUNT_READ_HIGH_PRIORITY` bigint(20) NOT NULL,
+  `SUM_TIMER_READ_HIGH_PRIORITY` bigint(20) NOT NULL,
+  `MIN_TIMER_READ_HIGH_PRIORITY` bigint(20) NOT NULL,
+  `AVG_TIMER_READ_HIGH_PRIORITY` bigint(20) NOT NULL,
+  `MAX_TIMER_READ_HIGH_PRIORITY` bigint(20) NOT NULL,
+  `COUNT_READ_NO_INSERT` bigint(20) NOT NULL,
+  `SUM_TIMER_READ_NO_INSERT` bigint(20) NOT NULL,
+  `MIN_TIMER_READ_NO_INSERT` bigint(20) NOT NULL,
+  `AVG_TIMER_READ_NO_INSERT` bigint(20) NOT NULL,
+  `MAX_TIMER_READ_NO_INSERT` bigint(20) NOT NULL,
+  `COUNT_READ_EXTERNAL` bigint(20) NOT NULL,
+  `SUM_TIMER_READ_EXTERNAL` bigint(20) NOT NULL,
+  `MIN_TIMER_READ_EXTERNAL` bigint(20) NOT NULL,
+  `AVG_TIMER_READ_EXTERNAL` bigint(20) NOT NULL,
+  `MAX_TIMER_READ_EXTERNAL` bigint(20) NOT NULL,
+  `COUNT_WRITE_ALLOW_WRITE` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE_ALLOW_WRITE` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE_ALLOW_WRITE` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE_ALLOW_WRITE` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE_ALLOW_WRITE` bigint(20) NOT NULL,
+  `COUNT_WRITE_CONCURRENT_INSERT` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) NOT NULL,
+  `COUNT_WRITE_DELAYED` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE_DELAYED` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE_DELAYED` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE_DELAYED` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE_DELAYED` bigint(20) NOT NULL,
+  `COUNT_WRITE_LOW_PRIORITY` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE_LOW_PRIORITY` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE_LOW_PRIORITY` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE_LOW_PRIORITY` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE_LOW_PRIORITY` bigint(20) NOT NULL,
+  `COUNT_WRITE_NORMAL` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE_NORMAL` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE_NORMAL` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE_NORMAL` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE_NORMAL` bigint(20) NOT NULL,
+  `COUNT_WRITE_EXTERNAL` bigint(20) NOT NULL,
+  `SUM_TIMER_WRITE_EXTERNAL` bigint(20) NOT NULL,
+  `MIN_TIMER_WRITE_EXTERNAL` bigint(20) NOT NULL,
+  `AVG_TIMER_WRITE_EXTERNAL` bigint(20) NOT NULL,
+  `MAX_TIMER_WRITE_EXTERNAL` bigint(20) NOT NULL
 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
 show create table threads;
 Table	Create Table


Attachment: [text/bzr-bundle] bzr/chris.powers@oracle.com-20110609184420-vcecz2jxetzpm9l8.bundle
Thread
bzr commit into mysql-trunk branch (chris.powers:3108) Bug#11766504Christopher Powers9 Jun