#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#11766504 | Christopher Powers | 9 Jun |
