diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/schema.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/schema.result | 1385 |
1 files changed, 1385 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/schema.result b/mysql-test/suite/perfschema/r/schema.result new file mode 100644 index 00000000..9c838f40 --- /dev/null +++ b/mysql-test/suite/perfschema/r/schema.result @@ -0,0 +1,1385 @@ +show databases like 'performance_schema'; +Database (performance_schema) +performance_schema +show create database performance_schema; +Database Create Database +performance_schema CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8 */ +use performance_schema; +show tables; +Tables_in_performance_schema +accounts +cond_instances +events_stages_current +events_stages_history +events_stages_history_long +events_stages_summary_by_account_by_event_name +events_stages_summary_by_host_by_event_name +events_stages_summary_by_thread_by_event_name +events_stages_summary_by_user_by_event_name +events_stages_summary_global_by_event_name +events_statements_current +events_statements_history +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 +events_waits_summary_by_account_by_event_name +events_waits_summary_by_host_by_event_name +events_waits_summary_by_instance +events_waits_summary_by_thread_by_event_name +events_waits_summary_by_user_by_event_name +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 +setup_objects +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(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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table cond_instances; +Table Create Table +cond_instances CREATE TABLE `cond_instances` ( + `NAME` varchar(128) NOT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_stages_current; +Table Create Table +events_stages_current CREATE TABLE `events_stages_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, + `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, + `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('TRANSACTION','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` 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, + `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, + `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('TRANSACTION','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` 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, + `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, + `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('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 +events_stages_summary_by_host_by_event_name CREATE TABLE `events_stages_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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_stages_summary_by_thread_by_event_name; +Table Create Table +events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +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(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, + `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, + `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 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(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, + `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 +) 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 +) 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` 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, + `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, + `SQL_TEXT` longtext DEFAULT NULL, + `DIGEST` varchar(32) DEFAULT NULL, + `DIGEST_TEXT` longtext DEFAULT NULL, + `CURRENT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_TYPE` varchar(64) DEFAULT NULL, + `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_NAME` varchar(64) DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, + `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, + `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 +events_statements_history CREATE TABLE `events_statements_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, + `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, + `SQL_TEXT` longtext DEFAULT NULL, + `DIGEST` varchar(32) DEFAULT NULL, + `DIGEST_TEXT` longtext DEFAULT NULL, + `CURRENT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_TYPE` varchar(64) DEFAULT NULL, + `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_NAME` varchar(64) DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, + `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, + `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 +events_statements_history_long CREATE TABLE `events_statements_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, + `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, + `SQL_TEXT` longtext DEFAULT NULL, + `DIGEST` varchar(32) DEFAULT NULL, + `DIGEST_TEXT` longtext DEFAULT NULL, + `CURRENT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_TYPE` varchar(64) DEFAULT NULL, + `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, + `OBJECT_NAME` varchar(64) DEFAULT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, + `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, + `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 +events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_digest` ( + `SCHEMA_NAME` varchar(64) DEFAULT NULL, + `DIGEST` varchar(32) DEFAULT NULL, + `DIGEST_TEXT` longtext 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, + `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, + `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', + `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_statements_summary_by_host_by_event_name; +Table Create Table +events_statements_summary_by_host_by_event_name CREATE TABLE `events_statements_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, + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_statements_summary_by_thread_by_event_name; +Table Create Table +events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statements_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, + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +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(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, + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +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(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, + `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 +) 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 +) 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` ( + `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, + `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, + `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) unsigned NOT NULL, + `NESTING_EVENT_ID` bigint(20) unsigned 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 +) 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` 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, + `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, + `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) unsigned NOT NULL, + `NESTING_EVENT_ID` bigint(20) unsigned 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 +) 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` 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, + `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, + `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) unsigned NOT NULL, + `NESTING_EVENT_ID` bigint(20) unsigned 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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_waits_summary_by_host_by_event_name; +Table Create Table +events_waits_summary_by_host_by_event_name CREATE TABLE `events_waits_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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table events_waits_summary_by_instance; +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) unsigned 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 +) 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` 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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +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(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, + `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, + `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 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(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, + `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 +) 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 +) 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` ( + `FILE_NAME` varchar(512) NOT NULL, + `EVENT_NAME` varchar(128) NOT NULL, + `OPEN_COUNT` int(10) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table file_summary_by_event_name; +Table Create Table +file_summary_by_event_name CREATE TABLE `file_summary_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` 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, + `SUM_NUMBER_OF_BYTES_READ` bigint(20) 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, + `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL, + `COUNT_MISC` bigint(20) unsigned NOT NULL, + `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, + `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, + `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 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, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned 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` 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, + `SUM_NUMBER_OF_BYTES_READ` bigint(20) 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, + `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL, + `COUNT_MISC` bigint(20) unsigned NOT NULL, + `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, + `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, + `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 host_cache; +Table Create Table +host_cache CREATE TABLE `host_cache` ( + `IP` varchar(64) NOT NULL, + `HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST_VALIDATED` enum('YES','NO') NOT NULL, + `SUM_CONNECT_ERRORS` bigint(20) NOT NULL, + `COUNT_HOST_BLOCKED_ERRORS` bigint(20) NOT NULL, + `COUNT_NAMEINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL, + `COUNT_NAMEINFO_PERMANENT_ERRORS` bigint(20) NOT NULL, + `COUNT_FORMAT_ERRORS` bigint(20) NOT NULL, + `COUNT_ADDRINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL, + `COUNT_ADDRINFO_PERMANENT_ERRORS` bigint(20) NOT NULL, + `COUNT_FCRDNS_ERRORS` bigint(20) NOT NULL, + `COUNT_HOST_ACL_ERRORS` bigint(20) NOT NULL, + `COUNT_NO_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL, + `COUNT_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL, + `COUNT_HANDSHAKE_ERRORS` bigint(20) NOT NULL, + `COUNT_PROXY_USER_ERRORS` bigint(20) NOT NULL, + `COUNT_PROXY_USER_ACL_ERRORS` bigint(20) NOT NULL, + `COUNT_AUTHENTICATION_ERRORS` bigint(20) NOT NULL, + `COUNT_SSL_ERRORS` bigint(20) NOT NULL, + `COUNT_MAX_USER_CONNECTIONS_ERRORS` bigint(20) NOT NULL, + `COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS` bigint(20) NOT NULL, + `COUNT_DEFAULT_DATABASE_ERRORS` bigint(20) NOT NULL, + `COUNT_INIT_CONNECT_ERRORS` bigint(20) NOT NULL, + `COUNT_LOCAL_ERRORS` bigint(20) NOT NULL, + `COUNT_UNKNOWN_ERRORS` bigint(20) NOT NULL, + `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', + `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', + `FIRST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00', + `LAST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00' +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table hosts; +Table Create Table +hosts CREATE TABLE `hosts` ( + `HOST` char(60) 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 +show create table mutex_instances; +Table Create Table +mutex_instances CREATE TABLE `mutex_instances` ( + `NAME` varchar(128) NOT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, + `LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table objects_summary_global_by_type; +Table Create Table +objects_summary_global_by_type CREATE TABLE `objects_summary_global_by_type` ( + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table performance_timers; +Table Create Table +performance_timers CREATE TABLE `performance_timers` ( + `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL, + `TIMER_FREQUENCY` bigint(20) DEFAULT NULL, + `TIMER_RESOLUTION` bigint(20) DEFAULT NULL, + `TIMER_OVERHEAD` bigint(20) DEFAULT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table rwlock_instances; +Table Create Table +rwlock_instances CREATE TABLE `rwlock_instances` ( + `NAME` varchar(128) NOT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, + `WRITE_LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL, + `READ_LOCKED_BY_COUNT` int(10) unsigned NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +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(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', + `ROLE` char(128) 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 +setup_consumers CREATE TABLE `setup_consumers` ( + `NAME` varchar(64) NOT NULL, + `ENABLED` enum('YES','NO') NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table setup_instruments; +Table Create Table +setup_instruments CREATE TABLE `setup_instruments` ( + `NAME` varchar(128) NOT NULL, + `ENABLED` enum('YES','NO') NOT NULL, + `TIMED` enum('YES','NO') NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table setup_objects; +Table Create Table +setup_objects CREATE TABLE `setup_objects` ( + `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', + `TIMED` enum('YES','NO') NOT NULL DEFAULT 'YES' +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table setup_timers; +Table Create Table +setup_timers CREATE TABLE `setup_timers` ( + `NAME` varchar(64) NOT NULL, + `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table socket_instances; +Table Create Table +socket_instances CREATE TABLE `socket_instances` ( + `EVENT_NAME` varchar(128) NOT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, + `THREAD_ID` bigint(20) unsigned DEFAULT NULL, + `SOCKET_ID` int(11) NOT NULL, + `IP` varchar(64) NOT NULL, + `PORT` int(11) NOT NULL, + `STATE` enum('IDLE','ACTIVE') NOT NULL +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table socket_summary_by_instance; +Table Create Table +socket_summary_by_instance CREATE TABLE `socket_summary_by_instance` ( + `EVENT_NAME` varchar(128) NOT NULL, + `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned 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` 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, + `SUM_NUMBER_OF_BYTES_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, + `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_MISC` bigint(20) unsigned NOT NULL, + `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, + `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, + `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 socket_summary_by_event_name; +Table Create Table +socket_summary_by_event_name CREATE TABLE `socket_summary_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` 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, + `SUM_NUMBER_OF_BYTES_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, + `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL, + `COUNT_MISC` bigint(20) unsigned NOT NULL, + `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, + `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, + `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` ( + `OBJECT_TYPE` varchar(64) DEFAULT NULL, + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table table_io_waits_summary_by_table; +Table Create Table +table_io_waits_summary_by_table CREATE TABLE `table_io_waits_summary_by_table` ( + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table table_lock_waits_summary_by_table; +Table Create Table +table_lock_waits_summary_by_table CREATE TABLE `table_lock_waits_summary_by_table` ( + `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 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +show create table threads; +Table Create Table +threads CREATE TABLE `threads` ( + `THREAD_ID` bigint(20) unsigned NOT NULL, + `NAME` varchar(128) NOT NULL, + `TYPE` varchar(10) NOT NULL, + `PROCESSLIST_ID` bigint(20) unsigned 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, + `PROCESSLIST_TIME` bigint(20) DEFAULT NULL, + `PROCESSLIST_STATE` varchar(64) DEFAULT NULL, + `PROCESSLIST_INFO` longtext DEFAULT NULL, + `PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL, + `ROLE` varchar(64) DEFAULT 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(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 |