1540 lines
74 KiB
Plaintext
1540 lines
74 KiB
Plaintext
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 utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
|
|
use performance_schema;
|
|
show tables;
|
|
Tables_in_performance_schema
|
|
accounts
|
|
cond_instances
|
|
data_lock_waits
|
|
data_locks
|
|
events_errors_summary_by_account_by_error
|
|
events_errors_summary_by_host_by_error
|
|
events_errors_summary_by_thread_by_error
|
|
events_errors_summary_by_user_by_error
|
|
events_errors_summary_global_by_error
|
|
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_histogram_by_digest
|
|
events_statements_histogram_global
|
|
events_statements_history
|
|
events_statements_history_long
|
|
events_statements_summary_by_account_by_event_name
|
|
events_statements_summary_by_digest
|
|
events_statements_summary_by_digest_supplement
|
|
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
|
|
global_variables
|
|
host_cache
|
|
hosts
|
|
keyring_keys
|
|
log_status
|
|
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
|
|
persisted_variables
|
|
prepared_statements_instances
|
|
replication_applier_configuration
|
|
replication_applier_filters
|
|
replication_applier_global_filters
|
|
replication_applier_status
|
|
replication_applier_status_by_coordinator
|
|
replication_applier_status_by_worker
|
|
replication_connection_configuration
|
|
replication_connection_status
|
|
replication_group_member_stats
|
|
replication_group_members
|
|
rwlock_instances
|
|
session_account_connect_attrs
|
|
session_connect_attrs
|
|
session_status
|
|
session_variables
|
|
setup_actors
|
|
setup_consumers
|
|
setup_instruments
|
|
setup_objects
|
|
setup_threads
|
|
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_defined_functions
|
|
user_variables_by_thread
|
|
users
|
|
variables_by_thread
|
|
variables_info
|
|
show create table accounts;
|
|
Table Create Table
|
|
accounts CREATE TABLE `accounts` (
|
|
`USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
|
|
`CURRENT_CONNECTIONS` bigint(20) NOT NULL,
|
|
`TOTAL_CONNECTIONS` bigint(20) NOT NULL,
|
|
UNIQUE KEY `ACCOUNT` (`USER`,`HOST`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `NAME` (`NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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,
|
|
UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
`DIGEST` varchar(64) DEFAULT NULL,
|
|
`DIGEST_TEXT` longtext,
|
|
`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,
|
|
`STATEMENT_ID` bigint(20) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
`DIGEST` varchar(64) DEFAULT NULL,
|
|
`DIGEST_TEXT` longtext,
|
|
`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,
|
|
`STATEMENT_ID` bigint(20) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
`DIGEST` varchar(64) DEFAULT NULL,
|
|
`DIGEST_TEXT` longtext,
|
|
`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,
|
|
`STATEMENT_ID` bigint(20) unsigned DEFAULT NULL
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(64) DEFAULT NULL,
|
|
`DIGEST_TEXT` longtext,
|
|
`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(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
|
|
`LAST_SEEN` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
|
|
`QUANTILE_95` bigint(20) unsigned NOT NULL,
|
|
`QUANTILE_99` bigint(20) unsigned NOT NULL,
|
|
`QUANTILE_999` bigint(20) unsigned NOT NULL,
|
|
`QUERY_SAMPLE_TEXT` longtext,
|
|
`QUERY_SAMPLE_SEEN` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
|
|
`QUERY_SAMPLE_TIMER_WAIT` bigint(20) unsigned NOT NULL,
|
|
UNIQUE KEY `SCHEMA_NAME` (`SCHEMA_NAME`,`DIGEST`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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,
|
|
UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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 utf8mb4 COLLATE utf8mb4_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,
|
|
UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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 utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `EVENT_NAME` (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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,
|
|
UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `HOST` (`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`THREAD_ID`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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 utf8mb4 COLLATE utf8mb4_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,
|
|
UNIQUE KEY `USER` (`USER`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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 utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
UNIQUE KEY `ACCOUNT` (`USER`,`HOST`,`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
`COLUMN_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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `OBJECT_TYPE` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`,`COLUMN_NAME`),
|
|
KEY `OWNER_THREAD_ID` (`OWNER_THREAD_ID`,`OWNER_EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`FILE_NAME`),
|
|
KEY `EVENT_NAME` (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `FILE_NAME` (`FILE_NAME`),
|
|
KEY `EVENT_NAME` (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table host_cache;
|
|
Table Create Table
|
|
host_cache CREATE TABLE `host_cache` (
|
|
`IP` varchar(64) NOT NULL,
|
|
`HOST` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci 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',
|
|
PRIMARY KEY (`IP`),
|
|
KEY `HOST` (`HOST`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table hosts;
|
|
Table Create Table
|
|
hosts CREATE TABLE `hosts` (
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
|
|
`CURRENT_CONNECTIONS` bigint(20) NOT NULL,
|
|
`TOTAL_CONNECTIONS` bigint(20) NOT NULL,
|
|
UNIQUE KEY `HOST` (`HOST`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `NAME` (`NAME`),
|
|
KEY `LOCKED_BY_THREAD_ID` (`LOCKED_BY_THREAD_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table performance_timers;
|
|
Table Create Table
|
|
performance_timers CREATE TABLE `performance_timers` (
|
|
`TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND') 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table data_locks;
|
|
Table Create Table
|
|
data_locks CREATE TABLE `data_locks` (
|
|
`ENGINE` varchar(32) NOT NULL,
|
|
`ENGINE_LOCK_ID` varchar(128) NOT NULL,
|
|
`ENGINE_TRANSACTION_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`THREAD_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`EVENT_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
|
|
`OBJECT_NAME` varchar(64) DEFAULT NULL,
|
|
`PARTITION_NAME` varchar(64) DEFAULT NULL,
|
|
`SUBPARTITION_NAME` varchar(64) DEFAULT NULL,
|
|
`INDEX_NAME` varchar(64) DEFAULT NULL,
|
|
`OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
|
|
`LOCK_TYPE` varchar(32) NOT NULL,
|
|
`LOCK_MODE` varchar(32) NOT NULL,
|
|
`LOCK_STATUS` varchar(32) NOT NULL,
|
|
`LOCK_DATA` varchar(8192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|
PRIMARY KEY (`ENGINE_LOCK_ID`,`ENGINE`),
|
|
KEY `ENGINE_TRANSACTION_ID` (`ENGINE_TRANSACTION_ID`,`ENGINE`),
|
|
KEY `THREAD_ID` (`THREAD_ID`,`EVENT_ID`),
|
|
KEY `OBJECT_SCHEMA` (`OBJECT_SCHEMA`,`OBJECT_NAME`,`PARTITION_NAME`,`SUBPARTITION_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table data_lock_waits;
|
|
Table Create Table
|
|
data_lock_waits CREATE TABLE `data_lock_waits` (
|
|
`ENGINE` varchar(32) NOT NULL,
|
|
`REQUESTING_ENGINE_LOCK_ID` varchar(128) NOT NULL,
|
|
`REQUESTING_ENGINE_TRANSACTION_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`REQUESTING_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`REQUESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`REQUESTING_OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
|
|
`BLOCKING_ENGINE_LOCK_ID` varchar(128) NOT NULL,
|
|
`BLOCKING_ENGINE_TRANSACTION_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`BLOCKING_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`BLOCKING_EVENT_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`BLOCKING_OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
|
|
KEY `REQUESTING_ENGINE_LOCK_ID` (`REQUESTING_ENGINE_LOCK_ID`,`ENGINE`),
|
|
KEY `BLOCKING_ENGINE_LOCK_ID` (`BLOCKING_ENGINE_LOCK_ID`,`ENGINE`),
|
|
KEY `REQUESTING_ENGINE_TRANSACTION_ID` (`REQUESTING_ENGINE_TRANSACTION_ID`,`ENGINE`),
|
|
KEY `BLOCKING_ENGINE_TRANSACTION_ID` (`BLOCKING_ENGINE_TRANSACTION_ID`,`ENGINE`),
|
|
KEY `REQUESTING_THREAD_ID` (`REQUESTING_THREAD_ID`,`REQUESTING_EVENT_ID`),
|
|
KEY `BLOCKING_THREAD_ID` (`BLOCKING_THREAD_ID`,`BLOCKING_EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `NAME` (`NAME`),
|
|
KEY `WRITE_LOCKED_BY_THREAD_ID` (`WRITE_LOCKED_BY_THREAD_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table setup_actors;
|
|
Table Create Table
|
|
setup_actors CREATE TABLE `setup_actors` (
|
|
`HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '%',
|
|
`USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '%',
|
|
`ROLE` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '%',
|
|
`ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES',
|
|
`HISTORY` enum('YES','NO') NOT NULL DEFAULT 'YES',
|
|
PRIMARY KEY (`HOST`,`USER`,`ROLE`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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') DEFAULT NULL,
|
|
`PROPERTIES` set('singleton','progress','user','global_statistics','mutable') NOT NULL,
|
|
`VOLATILITY` int(11) NOT NULL,
|
|
`DOCUMENTATION` longtext,
|
|
PRIMARY KEY (`NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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',
|
|
UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `THREAD_ID` (`THREAD_ID`),
|
|
KEY `SOCKET_ID` (`SOCKET_ID`),
|
|
KEY `IP` (`IP`,`PORT`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `EVENT_NAME` (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`EVENT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
PRIMARY KEY (`OBJECT_INSTANCE_BEGIN`),
|
|
KEY `OBJECT_TYPE` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`),
|
|
KEY `OWNER_THREAD_ID` (`OWNER_THREAD_ID`,`OWNER_EVENT_ID`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`,`INDEX_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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,
|
|
UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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_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,
|
|
UNIQUE KEY `OBJECT` (`OBJECT_TYPE`,`OBJECT_SCHEMA`,`OBJECT_NAME`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
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(32) DEFAULT NULL,
|
|
`PROCESSLIST_HOST` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci 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,
|
|
`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,
|
|
`RESOURCE_GROUP` varchar(64) DEFAULT NULL,
|
|
PRIMARY KEY (`THREAD_ID`),
|
|
KEY `PROCESSLIST_ID` (`PROCESSLIST_ID`),
|
|
KEY `THREAD_OS_ID` (`THREAD_OS_ID`),
|
|
KEY `NAME` (`NAME`),
|
|
KEY `PROCESSLIST_ACCOUNT` (`PROCESSLIST_USER`,`PROCESSLIST_HOST`),
|
|
KEY `PROCESSLIST_HOST` (`PROCESSLIST_HOST`),
|
|
KEY `RESOURCE_GROUP` (`RESOURCE_GROUP`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show create table users;
|
|
Table Create Table
|
|
users CREATE TABLE `users` (
|
|
`USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`CURRENT_CONNECTIONS` bigint(20) NOT NULL,
|
|
`TOTAL_CONNECTIONS` bigint(20) NOT NULL,
|
|
UNIQUE KEY `USER` (`USER`)
|
|
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|