From: Christopher Powers Date: June 9 2011 6:44pm Subject: bzr commit into mysql-trunk branch (chris.powers:3108) Bug#11766504 List-Archive: http://lists.mysql.com/commits/139000 X-Bug: 11766504 Message-Id: <20110609184426.957E91DB033E@xeno.mysql.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2983712201863656134==" --===============2983712201863656134== 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 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 --===============2983712201863656134== 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: 64e8acc214fb3122026eef5b87b028b6f26c7828 # timestamp: 2011-06-09 13:44:26 -0500 # base_revision_id: chris.powers@stripped\ # vh2qmoa0oaagfftr # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWZjNu0AACoXfgAAQWGf/93// 3+D////wYApd9w3dw0AXfPAABqqoS+fch99AVqhJJAAjSeJppomNTRNMmmJoDamammEDQSIjRCNN KNTBoQZAAaAAANABpJ/qqTEYCaYAAJiMTTAjATAhgSaUpkmk0PTUGg0A0ABoAAA0AEVJJ6ZTynlN HqfqgGgAAA0PUAGgDQKUomQk9A0Ck9TTQAAANAAaeUAu7vcGqAiESVqqD9NfMNenOSQ5QzlgaMGt HrecaKjLIyylXpcFoWrh19fABZ0kbOTQ1rfC2q65TGGK0zHKSc5hpCBFtuPp5MAGxH6fggPTans9 n0mZh6tdMqZ3vjMzOatG9sYcZIUVEpmWmzpeCIg0uYkl5eB3AegzOI0uKtLQMtiCcRe9tbXu4euN YtDvmztatrPNya7ed4uwbJIHkQgQOGQgQ8XF3Mb8ggRXJ9khAju3fn/b9M7SMHuqtfvs0aOdO4HI 8IkhCa8N6RPtKqPm+s7+L4J17/Lfb6PsN/h17V1sPP4UjtEeJdnPW/Z7HXfCDk0Nrky7SUtETCJc +BAIRE7jM3ilSScx7d/OaGLrb2dP31FLS2HREc1kWilSZUY049Qa3OiQXw4jTY8s/HsCorvHrePC Fc0XvwXqMyV14Lat7Y7D5eqfZrcn085Maap4vpKk/P1dUgozVscEQwxFMeZbo4JqJBSMKrGGiHXo SECOQqJQsSrncyUXGaIZfXtkrZuDjGQ8Zt3TU8X/C8HmWywaLXMRHV3CzITN6HAHEwBt3oGymUs+ MjPU79EDFtnlybbHKsNdt5H1KFhd/OcD6ch+sL1KJpUpfl5xy5Rwduo9BchowGN2+Zznng6LLTPI zmWKUeS64o5NbD1DbOvV4pIvDDuUG498m28iqxod3Tt7Lcx33NuGue/TCN+OIpvW01O9OcznKwQd hbn5b1JRz5q+N6xRO5BLezFoZMEljSCu+PeQynWOkauY2JtfcsckoPH0i+G9+OvXc24POLN+YzWg 0t14dY4kfgeTRtCQhBE03UYUybcg81XZkzcgju6BHvBI9EeSIRhwmSiqqqq/iD9gh7iHxhphqCGF OikTtE8lQtBCkEJUjoQYFxY2iaVi07ncJHGSS8JhEupNKlaiQIMC4KzJPI8U3qNqtkydicpvNExM n9o2jVpGtoyZZZlisYyzs9VLw9J5Tyi577zE8HxcLGi1tWjRr6VG2ThFicu6PijabTx9JzTd52xO EH4axIdI3rtW1hjuTROUcoyrtTefRMqyYmT36HZYq1WjRoYOtRznFPKd+ielfS704TE9a2mivIjx ncuE7Z2zVNUec8t9gp7bJ4zsnCNSc+BHcnanWYpe+YnjJcU7p0mJ6UiedV3pifGkTjMTjPWyt5rU dNE2Jv2U4kb1xnmFN5wI4eCYqOG6bc5qnKPDSco2Jorec06kRjZZXjsTszDmpjMQyb0ibG9sRysW TDHRPdNq+Cd67ZxTyT2751JqRG4mpOxNauc707tE8E00A4p3TXlPBfInmpeMmqbzadbmyxlle6bT eLeNFCynTamyGcoxGIxGMmAhyIWF1w0TAxGJljeYTjGqo7E0ZMnxZY62i1sUQpjchuSTdRRWLFiq rCAMZCMsFWIy93NOhOSe/pTxnzJrXeAMgyKCIUpQpSkpSwNIHJgIFkYMjJJyjE1Tmc0yLpNAGIlI IFiJQJiBiAkYyCMVlMMpmloxoZSJ5pyqNK7eSo8u4TsTsmJ0RyI0kulkq2VcKuBGJk9h7JznCdKx PUydw2es0jg9I4zf5MxmZmbDiXunCaIyaQwOGlS2lsXXMoiZQ2iw0QxVVVwFghnJiHP3lVVzhpgk MgUFBQzDMsZHNpcVlXHRNZxmg2jantdGcnKYpSiqAnkIQhCEIAAAAAABhhhhCEJ5MMycwzIZk8hw AAA8BEzMzMypUqVdHMRkDJQiEIVyyICzBQUFBQds4+CIxZgrODtdOHW9eDVM3VbbayyRgKM3RTZc YVUibDBo3255yiUhuLXdkqL1N72Q5iKswLq5RRVOL0qJSG4td2RRcmziqVEpDcWu7KRdxUqUqFKs muqalSmrDILkliSCxYggsWGXGSSMZkoxlxfKo6JDtN6dlSO0EgR51zbljXYzdPSdfNCt3x3n33JF 97gnXb38PDBBVIJq2OTtK6DBndZOognjZg/OpRL1GjlTGn+jPVKRzc9qbS0hJ+ooWSL0h+2lLgl1 m+SoxKFNU+n4yfcaSDeYMhR7+HPKYnWjiY8duEXGbXUQhqlH8yWM4if1eupafNtlfZ37cUKI4kyd PVLp9Ui++0kWQTBEnserOTldl1rF1BctmvkKL3GKYtmT3HsAnBIEQ501wWRPLN4uEd9IhGmIzmTl 7kz+c4gSBFSeLPIJrgSBHnnqfrDvpEZQbXRBpw1CzZW5YrQ9bglCV3ohmYwNUqQxrKtgR0CNgmkW WtRukK4caggUEJAF8D4PNqnckIJQQgwgwbI3TFtVtjVrZgNAbtZKa+JSAVsXLF4PCKM9mVmTPEJO KHpEZYo7Flt63LGTJKyClMjZa9vBp5PdSNVua24pI77q7XexcRAi08eh45+Bk0gNGuWrscVSUNHI Dkz5RrwSECGG5x93QQM6iwxjHd5amqNF0T63hb7it0+bGVl3FlNYDVI8OvmE+o9jGBreFTEQ1i/4 u5IpwoSExm3aAA== --===============2983712201863656134==--