diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/schema.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/schema.result | 381 |
1 files changed, 359 insertions, 22 deletions
diff --git a/mysql-test/suite/perfschema/r/schema.result b/mysql-test/suite/perfschema/r/schema.result index 1f331394df6..f92548d5876 100644 --- a/mysql-test/suite/perfschema/r/schema.result +++ b/mysql-test/suite/perfschema/r/schema.result @@ -23,9 +23,18 @@ events_statements_history_long events_statements_summary_by_account_by_event_name events_statements_summary_by_digest events_statements_summary_by_host_by_event_name +events_statements_summary_by_program events_statements_summary_by_thread_by_event_name events_statements_summary_by_user_by_event_name events_statements_summary_global_by_event_name +events_transactions_current +events_transactions_history +events_transactions_history_long +events_transactions_summary_by_account_by_event_name +events_transactions_summary_by_host_by_event_name +events_transactions_summary_by_thread_by_event_name +events_transactions_summary_by_user_by_event_name +events_transactions_summary_global_by_event_name events_waits_current events_waits_history events_waits_history_long @@ -38,14 +47,27 @@ events_waits_summary_global_by_event_name file_instances file_summary_by_event_name file_summary_by_instance +global_status host_cache hosts +memory_summary_by_account_by_event_name +memory_summary_by_host_by_event_name +memory_summary_by_thread_by_event_name +memory_summary_by_user_by_event_name +memory_summary_global_by_event_name +metadata_locks mutex_instances objects_summary_global_by_type performance_timers +prepared_statements_instances +replication_applier_configuration +replication_applier_status +replication_applier_status_by_coordinator +replication_connection_configuration rwlock_instances session_account_connect_attrs session_connect_attrs +session_status setup_actors setup_consumers setup_instruments @@ -54,15 +76,21 @@ setup_timers socket_instances socket_summary_by_event_name socket_summary_by_instance +status_by_account +status_by_host +status_by_thread +status_by_user +table_handles table_io_waits_summary_by_index_usage table_io_waits_summary_by_table table_lock_waits_summary_by_table threads +user_variables_by_thread users show create table accounts; Table Create Table accounts CREATE TABLE `accounts` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `CURRENT_CONNECTIONS` bigint(20) NOT NULL, `TOTAL_CONNECTIONS` bigint(20) NOT NULL @@ -84,8 +112,10 @@ events_stages_current CREATE TABLE `events_stages_current` ( `TIMER_START` bigint(20) unsigned DEFAULT NULL, `TIMER_END` bigint(20) unsigned DEFAULT NULL, `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, + `WORK_COMPLETED` bigint(20) unsigned DEFAULT NULL, + `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table events_stages_history; Table Create Table @@ -98,8 +128,10 @@ events_stages_history CREATE TABLE `events_stages_history` ( `TIMER_START` bigint(20) unsigned DEFAULT NULL, `TIMER_END` bigint(20) unsigned DEFAULT NULL, `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, + `WORK_COMPLETED` bigint(20) unsigned DEFAULT NULL, + `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table events_stages_history_long; Table Create Table @@ -112,8 +144,10 @@ events_stages_history_long CREATE TABLE `events_stages_history_long` ( `TIMER_START` bigint(20) unsigned DEFAULT NULL, `TIMER_END` bigint(20) unsigned DEFAULT NULL, `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, + `WORK_COMPLETED` bigint(20) unsigned DEFAULT NULL, + `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table events_stages_summary_by_host_by_event_name; Table Create Table @@ -140,7 +174,7 @@ events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_summar show create table events_stages_summary_by_user_by_event_name; Table Create Table events_stages_summary_by_user_by_event_name CREATE TABLE `events_stages_summary_by_user_by_event_name` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -151,7 +185,7 @@ events_stages_summary_by_user_by_event_name CREATE TABLE `events_stages_summary_ show create table events_stages_summary_by_account_by_event_name; Table Create Table events_stages_summary_by_account_by_event_name CREATE TABLE `events_stages_summary_by_account_by_event_name` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, @@ -212,7 +246,8 @@ events_statements_current CREATE TABLE `events_statements_current` ( `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, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, + `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table events_statements_history; Table Create Table @@ -256,7 +291,8 @@ events_statements_history CREATE TABLE `events_statements_history` ( `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, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, + `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table events_statements_history_long; Table Create Table @@ -300,7 +336,8 @@ events_statements_history_long CREATE TABLE `events_statements_history_long` ( `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, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, + `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table events_statements_summary_by_digest; Table Create Table @@ -398,7 +435,7 @@ events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statement show create table events_statements_summary_by_user_by_event_name; Table Create Table events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_summary_by_user_by_event_name` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -428,7 +465,7 @@ events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_ show create table events_statements_summary_by_account_by_event_name; Table Create Table events_statements_summary_by_account_by_event_name CREATE TABLE `events_statements_summary_by_account_by_event_name` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, @@ -485,6 +522,195 @@ events_statements_summary_global_by_event_name CREATE TABLE `events_statements_s `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_current; +Table Create Table +events_transactions_current CREATE TABLE `events_transactions_current` ( + `THREAD_ID` bigint(20) unsigned NOT NULL, + `EVENT_ID` bigint(20) unsigned NOT NULL, + `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL, + `TRX_ID` bigint(20) unsigned DEFAULT NULL, + `GTID` varchar(64) DEFAULT NULL, + `XID_FORMAT_ID` int(11) DEFAULT NULL, + `XID_GTRID` varchar(130) DEFAULT NULL, + `XID_BQUAL` varchar(130) DEFAULT NULL, + `XA_STATE` varchar(64) DEFAULT 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, + `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL, + `ISOLATION_LEVEL` varchar(64) DEFAULT NULL, + `AUTOCOMMIT` enum('YES','NO') NOT NULL, + `NUMBER_OF_SAVEPOINTS` bigint(20) unsigned DEFAULT NULL, + `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint(20) unsigned DEFAULT NULL, + `NUMBER_OF_RELEASE_SAVEPOINT` bigint(20) unsigned DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, + `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_history; +Table Create Table +events_transactions_history CREATE TABLE `events_transactions_history` ( + `THREAD_ID` bigint(20) unsigned NOT NULL, + `EVENT_ID` bigint(20) unsigned NOT NULL, + `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL, + `TRX_ID` bigint(20) unsigned DEFAULT NULL, + `GTID` varchar(64) DEFAULT NULL, + `XID_FORMAT_ID` int(11) DEFAULT NULL, + `XID_GTRID` varchar(130) DEFAULT NULL, + `XID_BQUAL` varchar(130) DEFAULT NULL, + `XA_STATE` varchar(64) DEFAULT 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, + `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL, + `ISOLATION_LEVEL` varchar(64) DEFAULT NULL, + `AUTOCOMMIT` enum('YES','NO') NOT NULL, + `NUMBER_OF_SAVEPOINTS` bigint(20) unsigned DEFAULT NULL, + `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint(20) unsigned DEFAULT NULL, + `NUMBER_OF_RELEASE_SAVEPOINT` bigint(20) unsigned DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, + `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_history_long; +Table Create Table +events_transactions_history_long CREATE TABLE `events_transactions_history_long` ( + `THREAD_ID` bigint(20) unsigned NOT NULL, + `EVENT_ID` bigint(20) unsigned NOT NULL, + `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL, + `TRX_ID` bigint(20) unsigned DEFAULT NULL, + `GTID` varchar(64) DEFAULT NULL, + `XID_FORMAT_ID` int(11) DEFAULT NULL, + `XID_GTRID` varchar(130) DEFAULT NULL, + `XID_BQUAL` varchar(130) DEFAULT NULL, + `XA_STATE` varchar(64) DEFAULT 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, + `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL, + `ISOLATION_LEVEL` varchar(64) DEFAULT NULL, + `AUTOCOMMIT` enum('YES','NO') NOT NULL, + `NUMBER_OF_SAVEPOINTS` bigint(20) unsigned DEFAULT NULL, + `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint(20) unsigned DEFAULT NULL, + `NUMBER_OF_RELEASE_SAVEPOINT` bigint(20) unsigned DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, + `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_summary_by_host_by_event_name; +Table Create Table +events_transactions_summary_by_host_by_event_name CREATE TABLE `events_transactions_summary_by_host_by_event_name` ( + `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 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_READ_WRITE` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_READ_ONLY` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_summary_by_thread_by_event_name; +Table Create Table +events_transactions_summary_by_thread_by_event_name CREATE TABLE `events_transactions_summary_by_thread_by_event_name` ( + `THREAD_ID` bigint(20) unsigned 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_READ_WRITE` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_READ_ONLY` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_summary_by_user_by_event_name; +Table Create Table +events_transactions_summary_by_user_by_event_name CREATE TABLE `events_transactions_summary_by_user_by_event_name` ( + `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 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_READ_WRITE` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_READ_ONLY` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_summary_by_account_by_event_name; +Table Create Table +events_transactions_summary_by_account_by_event_name CREATE TABLE `events_transactions_summary_by_account_by_event_name` ( + `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 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_READ_WRITE` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_READ_ONLY` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_transactions_summary_global_by_event_name; +Table Create Table +events_transactions_summary_global_by_event_name CREATE TABLE `events_transactions_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_READ_WRITE` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_READ_ONLY` bigint(20) unsigned NOT NULL, + `SUM_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, + `MAX_TIMER_READ_ONLY` bigint(20) unsigned 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` ( @@ -503,7 +729,7 @@ events_waits_current CREATE TABLE `events_waits_current` ( `OBJECT_TYPE` varchar(64) DEFAULT NULL, `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL, + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, `FLAGS` int(10) unsigned DEFAULT NULL @@ -526,7 +752,7 @@ events_waits_history CREATE TABLE `events_waits_history` ( `OBJECT_TYPE` varchar(64) DEFAULT NULL, `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL, + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, `FLAGS` int(10) unsigned DEFAULT NULL @@ -549,7 +775,7 @@ events_waits_history_long CREATE TABLE `events_waits_history_long` ( `OBJECT_TYPE` varchar(64) DEFAULT NULL, `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, - `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL, + `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, `FLAGS` int(10) unsigned DEFAULT NULL @@ -590,7 +816,7 @@ events_waits_summary_by_thread_by_event_name CREATE TABLE `events_waits_summary_ show create table events_waits_summary_by_user_by_event_name; Table Create Table events_waits_summary_by_user_by_event_name CREATE TABLE `events_waits_summary_by_user_by_event_name` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -601,7 +827,7 @@ events_waits_summary_by_user_by_event_name CREATE TABLE `events_waits_summary_by show create table events_waits_summary_by_account_by_event_name; Table Create Table events_waits_summary_by_account_by_event_name CREATE TABLE `events_waits_summary_by_account_by_event_name` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, @@ -620,6 +846,100 @@ events_waits_summary_global_by_event_name CREATE TABLE `events_waits_summary_glo `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table memory_summary_by_host_by_event_name; +Table Create Table +memory_summary_by_host_by_event_name CREATE TABLE `memory_summary_by_host_by_event_name` ( + `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `COUNT_ALLOC` bigint(20) unsigned NOT NULL, + `COUNT_FREE` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_ALLOC` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_FREE` bigint(20) unsigned NOT NULL, + `LOW_COUNT_USED` bigint(20) NOT NULL, + `CURRENT_COUNT_USED` bigint(20) NOT NULL, + `HIGH_COUNT_USED` bigint(20) NOT NULL, + `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table memory_summary_by_thread_by_event_name; +Table Create Table +memory_summary_by_thread_by_event_name CREATE TABLE `memory_summary_by_thread_by_event_name` ( + `THREAD_ID` bigint(20) unsigned NOT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `COUNT_ALLOC` bigint(20) unsigned NOT NULL, + `COUNT_FREE` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_ALLOC` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_FREE` bigint(20) unsigned NOT NULL, + `LOW_COUNT_USED` bigint(20) NOT NULL, + `CURRENT_COUNT_USED` bigint(20) NOT NULL, + `HIGH_COUNT_USED` bigint(20) NOT NULL, + `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table memory_summary_by_user_by_event_name; +Table Create Table +memory_summary_by_user_by_event_name CREATE TABLE `memory_summary_by_user_by_event_name` ( + `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `COUNT_ALLOC` bigint(20) unsigned NOT NULL, + `COUNT_FREE` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_ALLOC` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_FREE` bigint(20) unsigned NOT NULL, + `LOW_COUNT_USED` bigint(20) NOT NULL, + `CURRENT_COUNT_USED` bigint(20) NOT NULL, + `HIGH_COUNT_USED` bigint(20) NOT NULL, + `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table memory_summary_by_account_by_event_name; +Table Create Table +memory_summary_by_account_by_event_name CREATE TABLE `memory_summary_by_account_by_event_name` ( + `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `COUNT_ALLOC` bigint(20) unsigned NOT NULL, + `COUNT_FREE` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_ALLOC` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_FREE` bigint(20) unsigned NOT NULL, + `LOW_COUNT_USED` bigint(20) NOT NULL, + `CURRENT_COUNT_USED` bigint(20) NOT NULL, + `HIGH_COUNT_USED` bigint(20) NOT NULL, + `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table memory_summary_global_by_event_name; +Table Create Table +memory_summary_global_by_event_name CREATE TABLE `memory_summary_global_by_event_name` ( + `EVENT_NAME` varchar(128) NOT NULL, + `COUNT_ALLOC` bigint(20) unsigned NOT NULL, + `COUNT_FREE` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_ALLOC` bigint(20) unsigned NOT NULL, + `SUM_NUMBER_OF_BYTES_FREE` bigint(20) unsigned NOT NULL, + `LOW_COUNT_USED` bigint(20) NOT NULL, + `CURRENT_COUNT_USED` bigint(20) NOT NULL, + `HIGH_COUNT_USED` bigint(20) NOT NULL, + `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, + `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table metadata_locks; +Table Create Table +metadata_locks CREATE TABLE `metadata_locks` ( + `OBJECT_TYPE` varchar(64) NOT NULL, + `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_NAME` varchar(64) DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, + `LOCK_TYPE` varchar(32) NOT NULL, + `LOCK_DURATION` varchar(32) NOT NULL, + `LOCK_STATUS` varchar(32) NOT NULL, + `SOURCE` varchar(64) DEFAULT NULL, + `OWNER_THREAD_ID` bigint(20) unsigned DEFAULT NULL, + `OWNER_EVENT_ID` bigint(20) unsigned DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table file_instances; Table Create Table file_instances CREATE TABLE `file_instances` ( @@ -762,8 +1082,10 @@ show create table setup_actors; Table Create Table setup_actors CREATE TABLE `setup_actors` ( `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', - `ROLE` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%' + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', + `ROLE` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', + `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES', + `HISTORY` enum('YES','NO') NOT NULL DEFAULT 'YES' ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table setup_consumers; Table Create Table @@ -781,7 +1103,7 @@ setup_instruments CREATE TABLE `setup_instruments` ( show create table setup_objects; Table Create Table setup_objects CREATE TABLE `setup_objects` ( - `OBJECT_TYPE` enum('TABLE') NOT NULL DEFAULT 'TABLE', + `OBJECT_TYPE` enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER') NOT NULL DEFAULT 'TABLE', `OBJECT_SCHEMA` varchar(64) DEFAULT '%', `OBJECT_NAME` varchar(64) NOT NULL DEFAULT '%', `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES', @@ -859,6 +1181,18 @@ socket_summary_by_event_name CREATE TABLE `socket_summary_by_event_name` ( `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table table_handles; +Table Create Table +table_handles CREATE TABLE `table_handles` ( + `OBJECT_TYPE` varchar(64) NOT NULL, + `OBJECT_SCHEMA` varchar(64) NOT NULL, + `OBJECT_NAME` varchar(64) NOT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, + `OWNER_THREAD_ID` bigint(20) unsigned DEFAULT NULL, + `OWNER_EVENT_ID` bigint(20) unsigned DEFAULT NULL, + `INTERNAL_LOCK` varchar(64) DEFAULT NULL, + `EXTERNAL_LOCK` varchar(64) DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table table_io_waits_summary_by_index_usage; Table Create Table table_io_waits_summary_by_index_usage CREATE TABLE `table_io_waits_summary_by_index_usage` ( @@ -1028,7 +1362,7 @@ threads CREATE TABLE `threads` ( `NAME` varchar(128) NOT NULL, `TYPE` varchar(10) NOT NULL, `PROCESSLIST_ID` bigint(20) unsigned DEFAULT NULL, - `PROCESSLIST_USER` varchar(16) DEFAULT NULL, + `PROCESSLIST_USER` varchar(128) DEFAULT NULL, `PROCESSLIST_HOST` varchar(60) DEFAULT NULL, `PROCESSLIST_DB` varchar(64) DEFAULT NULL, `PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL, @@ -1037,12 +1371,15 @@ threads CREATE TABLE `threads` ( `PROCESSLIST_INFO` longtext DEFAULT NULL, `PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL, `ROLE` varchar(64) DEFAULT NULL, - `INSTRUMENTED` enum('YES','NO') NOT NULL + `INSTRUMENTED` enum('YES','NO') NOT NULL, + `HISTORY` enum('YES','NO') NOT NULL, + `CONNECTION_TYPE` varchar(16) DEFAULT NULL, + `THREAD_OS_ID` bigint(20) unsigned DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 show create table users; Table Create Table users CREATE TABLE `users` ( - `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `CURRENT_CONNECTIONS` bigint(20) NOT NULL, `TOTAL_CONNECTIONS` bigint(20) NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 |