Print view - phpMyAdmin 4.9.0.1

accounts

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
CURRENT_CONNECTIONS	bigint	No
TOTAL_CONNECTIONS	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
ACCOUNT	HASH	Yes	No	USER			Yes
ACCOUNT	HASH	Yes	No	HOST			Yes

cond_instances

Column	Type	Null	Default	Links to	Comments	MIME
NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN			No
NAME	HASH	No	No	NAME			No

data_locks

Column	Type	Null	Default
ENGINE (Primary)	varchar(32)	No
ENGINE_LOCK_ID (Primary)	varchar(128)	No
ENGINE_TRANSACTION_ID	bigint	Yes	NULL
THREAD_ID	bigint	Yes	NULL
EVENT_ID	bigint	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
PARTITION_NAME	varchar(64)	Yes	NULL
SUBPARTITION_NAME	varchar(64)	Yes	NULL
INDEX_NAME	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	No
LOCK_TYPE	varchar(32)	No
LOCK_MODE	varchar(32)	No
LOCK_STATUS	varchar(32)	No
LOCK_DATA	varchar(8192)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	ENGINE_LOCK_ID	No
PRIMARY	HASH	Yes	No	ENGINE	No
ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE_TRANSACTION_ID	Yes
ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE	No
THREAD_ID	HASH	No	No	THREAD_ID	Yes
THREAD_ID	HASH	No	No	EVENT_ID	Yes
OBJECT_SCHEMA	HASH	No	No	OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes
				PARTITION_NAME	Yes
				SUBPARTITION_NAME	Yes

data_lock_waits

Column	Type	Null	Default
ENGINE	varchar(32)	No
REQUESTING_ENGINE_LOCK_ID	varchar(128)	No
REQUESTING_ENGINE_TRANSACTION_ID	bigint	Yes	NULL
REQUESTING_THREAD_ID	bigint	Yes	NULL
REQUESTING_EVENT_ID	bigint	Yes	NULL
REQUESTING_OBJECT_INSTANCE_BEGIN	bigint	No
BLOCKING_ENGINE_LOCK_ID	varchar(128)	No
BLOCKING_ENGINE_TRANSACTION_ID	bigint	Yes	NULL
BLOCKING_THREAD_ID	bigint	Yes	NULL
BLOCKING_EVENT_ID	bigint	Yes	NULL
BLOCKING_OBJECT_INSTANCE_BEGIN	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
REQUESTING_ENGINE_LOCK_ID	HASH	No	No	REQUESTING_ENGINE_LOCK_ID	No
REQUESTING_ENGINE_LOCK_ID	HASH	No	No	ENGINE	No
BLOCKING_ENGINE_LOCK_ID	HASH	No	No	BLOCKING_ENGINE_LOCK_ID	No
BLOCKING_ENGINE_LOCK_ID	HASH	No	No	ENGINE	No
REQUESTING_ENGINE_TRANSACTION_ID	HASH	No	No	REQUESTING_ENGINE_TRANSACTION_ID	Yes
REQUESTING_ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE	No
BLOCKING_ENGINE_TRANSACTION_ID	HASH	No	No	BLOCKING_ENGINE_TRANSACTION_ID	Yes
BLOCKING_ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE	No
REQUESTING_THREAD_ID	HASH	No	No	REQUESTING_THREAD_ID	Yes
REQUESTING_THREAD_ID	HASH	No	No	REQUESTING_EVENT_ID	Yes
BLOCKING_THREAD_ID	HASH	No	No	BLOCKING_THREAD_ID	Yes
BLOCKING_THREAD_ID	HASH	No	No	BLOCKING_EVENT_ID	Yes

events_errors_summary_by_account_by_error

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
ERROR_NUMBER	int	Yes	NULL
ERROR_NAME	varchar(64)	Yes	NULL
SQL_STATE	varchar(5)	Yes	NULL
SUM_ERROR_RAISED	bigint	No
SUM_ERROR_HANDLED	bigint	No
FIRST_SEEN	timestamp	Yes	0000-00-00 00:00:00
LAST_SEEN	timestamp	Yes	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				ERROR_NUMBER	Yes

events_errors_summary_by_host_by_error

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
ERROR_NUMBER	int	Yes	NULL
ERROR_NAME	varchar(64)	Yes	NULL
SQL_STATE	varchar(5)	Yes	NULL
SUM_ERROR_RAISED	bigint	No
SUM_ERROR_HANDLED	bigint	No
FIRST_SEEN	timestamp	Yes	0000-00-00 00:00:00
LAST_SEEN	timestamp	Yes	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	ERROR_NUMBER			Yes

events_errors_summary_by_thread_by_error

Column	Type	Null	Default
THREAD_ID	bigint	No
ERROR_NUMBER	int	Yes	NULL
ERROR_NAME	varchar(64)	Yes	NULL
SQL_STATE	varchar(5)	Yes	NULL
SUM_ERROR_RAISED	bigint	No
SUM_ERROR_HANDLED	bigint	No
FIRST_SEEN	timestamp	Yes	0000-00-00 00:00:00
LAST_SEEN	timestamp	Yes	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
THREAD_ID	HASH	Yes	No	THREAD_ID			No
THREAD_ID	HASH	Yes	No	ERROR_NUMBER			Yes

events_errors_summary_by_user_by_error

Column	Type	Null	Default
USER	char(32)	Yes	NULL
ERROR_NUMBER	int	Yes	NULL
ERROR_NAME	varchar(64)	Yes	NULL
SQL_STATE	varchar(5)	Yes	NULL
SUM_ERROR_RAISED	bigint	No
SUM_ERROR_HANDLED	bigint	No
FIRST_SEEN	timestamp	Yes	0000-00-00 00:00:00
LAST_SEEN	timestamp	Yes	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	ERROR_NUMBER			Yes

events_errors_summary_global_by_error

Column	Type	Null	Default
ERROR_NUMBER	int	Yes	NULL
ERROR_NAME	varchar(64)	Yes	NULL
SQL_STATE	varchar(5)	Yes	NULL
SUM_ERROR_RAISED	bigint	No
SUM_ERROR_HANDLED	bigint	No
FIRST_SEEN	timestamp	Yes	0000-00-00 00:00:00
LAST_SEEN	timestamp	Yes	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
ERROR_NUMBER	HASH	Yes	No	ERROR_NUMBER			Yes

events_stages_current

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
WORK_COMPLETED	bigint	Yes	NULL
WORK_ESTIMATED	bigint	Yes	NULL
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_stages_history

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
WORK_COMPLETED	bigint	Yes	NULL
WORK_ESTIMATED	bigint	Yes	NULL
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_stages_history_long

Column	Type	Null	Default
THREAD_ID	bigint	No
EVENT_ID	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
WORK_COMPLETED	bigint	Yes	NULL
WORK_ESTIMATED	bigint	Yes	NULL
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

events_stages_summary_by_account_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_stages_summary_by_host_by_event_name

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_stages_summary_by_thread_by_event_name

Column	Type	Null
THREAD_ID (Primary)	bigint	No
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_stages_summary_by_user_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_stages_summary_global_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_statements_current

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
LOCK_TIME	bigint	No
SQL_TEXT	longtext	Yes	NULL
DIGEST	varchar(64)	Yes	NULL
DIGEST_TEXT	longtext	Yes	NULL
CURRENT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	Yes	NULL
MYSQL_ERRNO	int	Yes	NULL
RETURNED_SQLSTATE	varchar(5)	Yes	NULL
MESSAGE_TEXT	varchar(128)	Yes	NULL
ERRORS	bigint	No
WARNINGS	bigint	No
ROWS_AFFECTED	bigint	No
ROWS_SENT	bigint	No
ROWS_EXAMINED	bigint	No
CREATED_TMP_DISK_TABLES	bigint	No
CREATED_TMP_TABLES	bigint	No
SELECT_FULL_JOIN	bigint	No
SELECT_FULL_RANGE_JOIN	bigint	No
SELECT_RANGE	bigint	No
SELECT_RANGE_CHECK	bigint	No
SELECT_SCAN	bigint	No
SORT_MERGE_PASSES	bigint	No
SORT_RANGE	bigint	No
SORT_ROWS	bigint	No
SORT_SCAN	bigint	No
NO_INDEX_USED	bigint	No
NO_GOOD_INDEX_USED	bigint	No
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
NESTING_EVENT_LEVEL	int	Yes	NULL
STATEMENT_ID	bigint	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_statements_histogram_by_digest

Column	Type	Null	Default
SCHEMA_NAME	varchar(64)	Yes	NULL
DIGEST	varchar(64)	Yes	NULL
BUCKET_NUMBER	int	No
BUCKET_TIMER_LOW	bigint	No
BUCKET_TIMER_HIGH	bigint	No
COUNT_BUCKET	bigint	No
COUNT_BUCKET_AND_LOWER	bigint	No
BUCKET_QUANTILE	double(7,6)	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
SCHEMA_NAME	HASH	Yes	No	SCHEMA_NAME	Yes
				DIGEST	Yes
				BUCKET_NUMBER	No

events_statements_histogram_global

Column	Type	Null
BUCKET_NUMBER (Primary)	int	No
BUCKET_TIMER_LOW	bigint	No
BUCKET_TIMER_HIGH	bigint	No
COUNT_BUCKET	bigint	No
COUNT_BUCKET_AND_LOWER	bigint	No
BUCKET_QUANTILE	double(7,6)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	BUCKET_NUMBER			No

events_statements_history

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
LOCK_TIME	bigint	No
SQL_TEXT	longtext	Yes	NULL
DIGEST	varchar(64)	Yes	NULL
DIGEST_TEXT	longtext	Yes	NULL
CURRENT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	Yes	NULL
MYSQL_ERRNO	int	Yes	NULL
RETURNED_SQLSTATE	varchar(5)	Yes	NULL
MESSAGE_TEXT	varchar(128)	Yes	NULL
ERRORS	bigint	No
WARNINGS	bigint	No
ROWS_AFFECTED	bigint	No
ROWS_SENT	bigint	No
ROWS_EXAMINED	bigint	No
CREATED_TMP_DISK_TABLES	bigint	No
CREATED_TMP_TABLES	bigint	No
SELECT_FULL_JOIN	bigint	No
SELECT_FULL_RANGE_JOIN	bigint	No
SELECT_RANGE	bigint	No
SELECT_RANGE_CHECK	bigint	No
SELECT_SCAN	bigint	No
SORT_MERGE_PASSES	bigint	No
SORT_RANGE	bigint	No
SORT_ROWS	bigint	No
SORT_SCAN	bigint	No
NO_INDEX_USED	bigint	No
NO_GOOD_INDEX_USED	bigint	No
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
NESTING_EVENT_LEVEL	int	Yes	NULL
STATEMENT_ID	bigint	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_statements_history_long

Column	Type	Null	Default
THREAD_ID	bigint	No
EVENT_ID	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
LOCK_TIME	bigint	No
SQL_TEXT	longtext	Yes	NULL
DIGEST	varchar(64)	Yes	NULL
DIGEST_TEXT	longtext	Yes	NULL
CURRENT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	Yes	NULL
MYSQL_ERRNO	int	Yes	NULL
RETURNED_SQLSTATE	varchar(5)	Yes	NULL
MESSAGE_TEXT	varchar(128)	Yes	NULL
ERRORS	bigint	No
WARNINGS	bigint	No
ROWS_AFFECTED	bigint	No
ROWS_SENT	bigint	No
ROWS_EXAMINED	bigint	No
CREATED_TMP_DISK_TABLES	bigint	No
CREATED_TMP_TABLES	bigint	No
SELECT_FULL_JOIN	bigint	No
SELECT_FULL_RANGE_JOIN	bigint	No
SELECT_RANGE	bigint	No
SELECT_RANGE_CHECK	bigint	No
SELECT_SCAN	bigint	No
SORT_MERGE_PASSES	bigint	No
SORT_RANGE	bigint	No
SORT_ROWS	bigint	No
SORT_SCAN	bigint	No
NO_INDEX_USED	bigint	No
NO_GOOD_INDEX_USED	bigint	No
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
NESTING_EVENT_LEVEL	int	Yes	NULL
STATEMENT_ID	bigint	Yes	NULL

events_statements_summary_by_account_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_statements_summary_by_digest

Column	Type	Null	Default
SCHEMA_NAME	varchar(64)	Yes	NULL
DIGEST	varchar(64)	Yes	NULL
DIGEST_TEXT	longtext	Yes	NULL
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No
FIRST_SEEN	timestamp(6)	No	0000-00-00 00:00:00.000000
LAST_SEEN	timestamp(6)	No	0000-00-00 00:00:00.000000
QUANTILE_95	bigint	No
QUANTILE_99	bigint	No
QUANTILE_999	bigint	No
QUERY_SAMPLE_TEXT	longtext	Yes	NULL
QUERY_SAMPLE_SEEN	timestamp(6)	No	0000-00-00 00:00:00.000000
QUERY_SAMPLE_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
SCHEMA_NAME	HASH	Yes	No	SCHEMA_NAME			Yes
SCHEMA_NAME	HASH	Yes	No	DIGEST			Yes

events_statements_summary_by_host_by_event_name

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_statements_summary_by_program

Column	Type	Null
OBJECT_TYPE (Primary)	enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER')	No
OBJECT_SCHEMA (Primary)	varchar(64)	No
OBJECT_NAME (Primary)	varchar(64)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_STATEMENTS	bigint	No
SUM_STATEMENTS_WAIT	bigint	No
MIN_STATEMENTS_WAIT	bigint	No
AVG_STATEMENTS_WAIT	bigint	No
MAX_STATEMENTS_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_TYPE	No
				OBJECT_SCHEMA	No
				OBJECT_NAME	No

events_statements_summary_by_thread_by_event_name

Column	Type	Null
THREAD_ID (Primary)	bigint	No
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_statements_summary_by_user_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_statements_summary_global_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_transactions_current

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
STATE	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
TRX_ID	bigint	Yes	NULL
GTID	varchar(64)	Yes	NULL
XID_FORMAT_ID	int	Yes	NULL
XID_GTRID	varchar(130)	Yes	NULL
XID_BQUAL	varchar(130)	Yes	NULL
XA_STATE	varchar(64)	Yes	NULL
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
ACCESS_MODE	enum('READ ONLY', 'READ WRITE')	Yes	NULL
ISOLATION_LEVEL	varchar(64)	Yes	NULL
AUTOCOMMIT	enum('YES', 'NO')	No
NUMBER_OF_SAVEPOINTS	bigint	Yes	NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT	bigint	Yes	NULL
NUMBER_OF_RELEASE_SAVEPOINT	bigint	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	Yes	NULL
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_transactions_history

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
STATE	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
TRX_ID	bigint	Yes	NULL
GTID	varchar(64)	Yes	NULL
XID_FORMAT_ID	int	Yes	NULL
XID_GTRID	varchar(130)	Yes	NULL
XID_BQUAL	varchar(130)	Yes	NULL
XA_STATE	varchar(64)	Yes	NULL
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
ACCESS_MODE	enum('READ ONLY', 'READ WRITE')	Yes	NULL
ISOLATION_LEVEL	varchar(64)	Yes	NULL
AUTOCOMMIT	enum('YES', 'NO')	No
NUMBER_OF_SAVEPOINTS	bigint	Yes	NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT	bigint	Yes	NULL
NUMBER_OF_RELEASE_SAVEPOINT	bigint	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	Yes	NULL
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_transactions_history_long

Column	Type	Null	Default
THREAD_ID	bigint	No
EVENT_ID	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
STATE	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
TRX_ID	bigint	Yes	NULL
GTID	varchar(64)	Yes	NULL
XID_FORMAT_ID	int	Yes	NULL
XID_GTRID	varchar(130)	Yes	NULL
XID_BQUAL	varchar(130)	Yes	NULL
XA_STATE	varchar(64)	Yes	NULL
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
ACCESS_MODE	enum('READ ONLY', 'READ WRITE')	Yes	NULL
ISOLATION_LEVEL	varchar(64)	Yes	NULL
AUTOCOMMIT	enum('YES', 'NO')	No
NUMBER_OF_SAVEPOINTS	bigint	Yes	NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT	bigint	Yes	NULL
NUMBER_OF_RELEASE_SAVEPOINT	bigint	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	Yes	NULL
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

events_transactions_summary_by_account_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ_WRITE	bigint	No
SUM_TIMER_READ_WRITE	bigint	No
MIN_TIMER_READ_WRITE	bigint	No
AVG_TIMER_READ_WRITE	bigint	No
MAX_TIMER_READ_WRITE	bigint	No
COUNT_READ_ONLY	bigint	No
SUM_TIMER_READ_ONLY	bigint	No
MIN_TIMER_READ_ONLY	bigint	No
AVG_TIMER_READ_ONLY	bigint	No
MAX_TIMER_READ_ONLY	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_transactions_summary_by_host_by_event_name

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ_WRITE	bigint	No
SUM_TIMER_READ_WRITE	bigint	No
MIN_TIMER_READ_WRITE	bigint	No
AVG_TIMER_READ_WRITE	bigint	No
MAX_TIMER_READ_WRITE	bigint	No
COUNT_READ_ONLY	bigint	No
SUM_TIMER_READ_ONLY	bigint	No
MIN_TIMER_READ_ONLY	bigint	No
AVG_TIMER_READ_ONLY	bigint	No
MAX_TIMER_READ_ONLY	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_transactions_summary_by_thread_by_event_name

Column	Type	Null
THREAD_ID (Primary)	bigint	No
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ_WRITE	bigint	No
SUM_TIMER_READ_WRITE	bigint	No
MIN_TIMER_READ_WRITE	bigint	No
AVG_TIMER_READ_WRITE	bigint	No
MAX_TIMER_READ_WRITE	bigint	No
COUNT_READ_ONLY	bigint	No
SUM_TIMER_READ_ONLY	bigint	No
MIN_TIMER_READ_ONLY	bigint	No
AVG_TIMER_READ_ONLY	bigint	No
MAX_TIMER_READ_ONLY	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_transactions_summary_by_user_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ_WRITE	bigint	No
SUM_TIMER_READ_WRITE	bigint	No
MIN_TIMER_READ_WRITE	bigint	No
AVG_TIMER_READ_WRITE	bigint	No
MAX_TIMER_READ_WRITE	bigint	No
COUNT_READ_ONLY	bigint	No
SUM_TIMER_READ_ONLY	bigint	No
MIN_TIMER_READ_ONLY	bigint	No
AVG_TIMER_READ_ONLY	bigint	No
MAX_TIMER_READ_ONLY	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_transactions_summary_global_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ_WRITE	bigint	No
SUM_TIMER_READ_WRITE	bigint	No
MIN_TIMER_READ_WRITE	bigint	No
AVG_TIMER_READ_WRITE	bigint	No
MAX_TIMER_READ_WRITE	bigint	No
COUNT_READ_ONLY	bigint	No
SUM_TIMER_READ_ONLY	bigint	No
MIN_TIMER_READ_ONLY	bigint	No
AVG_TIMER_READ_ONLY	bigint	No
MAX_TIMER_READ_ONLY	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_waits_current

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
SPINS	int	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(512)	Yes	NULL
INDEX_NAME	varchar(64)	Yes	NULL
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	No
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
OPERATION	varchar(32)	No
NUMBER_OF_BYTES	bigint	Yes	NULL
FLAGS	int	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_waits_history

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
EVENT_ID (Primary)	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
SPINS	int	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(512)	Yes	NULL
INDEX_NAME	varchar(64)	Yes	NULL
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	No
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
OPERATION	varchar(32)	No
NUMBER_OF_BYTES	bigint	Yes	NULL
FLAGS	int	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_waits_history_long

Column	Type	Null	Default
THREAD_ID	bigint	No
EVENT_ID	bigint	No
END_EVENT_ID	bigint	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint	Yes	NULL
TIMER_END	bigint	Yes	NULL
TIMER_WAIT	bigint	Yes	NULL
SPINS	int	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(512)	Yes	NULL
INDEX_NAME	varchar(64)	Yes	NULL
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN	bigint	No
NESTING_EVENT_ID	bigint	Yes	NULL
NESTING_EVENT_TYPE	enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
OPERATION	varchar(32)	No
NUMBER_OF_BYTES	bigint	Yes	NULL
FLAGS	int	Yes	NULL

events_waits_summary_by_account_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_waits_summary_by_host_by_event_name

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_waits_summary_by_instance

Column	Type	Null
EVENT_NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN			No
EVENT_NAME	HASH	No	No	EVENT_NAME			No

events_waits_summary_by_thread_by_event_name

Column	Type	Null
THREAD_ID (Primary)	bigint	No
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_waits_summary_by_user_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_waits_summary_global_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

file_instances

Column	Type	Null
FILE_NAME (Primary)	varchar(512)	No
EVENT_NAME	varchar(128)	No
OPEN_COUNT	int	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	FILE_NAME			No
EVENT_NAME	HASH	No	No	EVENT_NAME			No

file_summary_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
SUM_NUMBER_OF_BYTES_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
SUM_NUMBER_OF_BYTES_WRITE	bigint	No
COUNT_MISC	bigint	No
SUM_TIMER_MISC	bigint	No
MIN_TIMER_MISC	bigint	No
AVG_TIMER_MISC	bigint	No
MAX_TIMER_MISC	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

file_summary_by_instance

Column	Type	Null
FILE_NAME	varchar(512)	No
EVENT_NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
SUM_NUMBER_OF_BYTES_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
SUM_NUMBER_OF_BYTES_WRITE	bigint	No
COUNT_MISC	bigint	No
SUM_TIMER_MISC	bigint	No
MIN_TIMER_MISC	bigint	No
AVG_TIMER_MISC	bigint	No
MAX_TIMER_MISC	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
FILE_NAME	HASH	No	No	FILE_NAME	No
EVENT_NAME	HASH	No	No	EVENT_NAME	No

global_status

Column	Type	Null	Default	Links to	Comments	MIME
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

global_variables

Column	Type	Null	Default	Links to	Comments	MIME
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

hosts

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
CURRENT_CONNECTIONS	bigint	No
TOTAL_CONNECTIONS	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes

host_cache

Column	Type	Null	Default
IP (Primary)	varchar(64)	No
HOST	varchar(255)	Yes	NULL
HOST_VALIDATED	enum('YES', 'NO')	No
SUM_CONNECT_ERRORS	bigint	No
COUNT_HOST_BLOCKED_ERRORS	bigint	No
COUNT_NAMEINFO_TRANSIENT_ERRORS	bigint	No
COUNT_NAMEINFO_PERMANENT_ERRORS	bigint	No
COUNT_FORMAT_ERRORS	bigint	No
COUNT_ADDRINFO_TRANSIENT_ERRORS	bigint	No
COUNT_ADDRINFO_PERMANENT_ERRORS	bigint	No
COUNT_FCRDNS_ERRORS	bigint	No
COUNT_HOST_ACL_ERRORS	bigint	No
COUNT_NO_AUTH_PLUGIN_ERRORS	bigint	No
COUNT_AUTH_PLUGIN_ERRORS	bigint	No
COUNT_HANDSHAKE_ERRORS	bigint	No
COUNT_PROXY_USER_ERRORS	bigint	No
COUNT_PROXY_USER_ACL_ERRORS	bigint	No
COUNT_AUTHENTICATION_ERRORS	bigint	No
COUNT_SSL_ERRORS	bigint	No
COUNT_MAX_USER_CONNECTIONS_ERRORS	bigint	No
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	bigint	No
COUNT_DEFAULT_DATABASE_ERRORS	bigint	No
COUNT_INIT_CONNECT_ERRORS	bigint	No
COUNT_LOCAL_ERRORS	bigint	No
COUNT_UNKNOWN_ERRORS	bigint	No
FIRST_SEEN	timestamp	No	0000-00-00 00:00:00
LAST_SEEN	timestamp	No	0000-00-00 00:00:00
FIRST_ERROR_SEEN	timestamp	Yes	0000-00-00 00:00:00
LAST_ERROR_SEEN	timestamp	Yes	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	IP			No
HOST	HASH	No	No	HOST			Yes

keyring_keys

Column	Type	Null	Default
KEY_ID	varchar(255)	No
KEY_OWNER	varchar(255)	Yes	NULL
BACKEND_KEY_ID	varchar(255)	Yes	NULL

log_status

Column	Type	Null
SERVER_UUID	char(36)	No
LOCAL	json	No
REPLICATION	json	No
STORAGE_ENGINES	json	No

memory_summary_by_account_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_ALLOC	bigint	No
COUNT_FREE	bigint	No
SUM_NUMBER_OF_BYTES_ALLOC	bigint	No
SUM_NUMBER_OF_BYTES_FREE	bigint	No
LOW_COUNT_USED	bigint	No
CURRENT_COUNT_USED	bigint	No
HIGH_COUNT_USED	bigint	No
LOW_NUMBER_OF_BYTES_USED	bigint	No
CURRENT_NUMBER_OF_BYTES_USED	bigint	No
HIGH_NUMBER_OF_BYTES_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

memory_summary_by_host_by_event_name

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_ALLOC	bigint	No
COUNT_FREE	bigint	No
SUM_NUMBER_OF_BYTES_ALLOC	bigint	No
SUM_NUMBER_OF_BYTES_FREE	bigint	No
LOW_COUNT_USED	bigint	No
CURRENT_COUNT_USED	bigint	No
HIGH_COUNT_USED	bigint	No
LOW_NUMBER_OF_BYTES_USED	bigint	No
CURRENT_NUMBER_OF_BYTES_USED	bigint	No
HIGH_NUMBER_OF_BYTES_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

memory_summary_by_thread_by_event_name

Column	Type	Null
THREAD_ID (Primary)	bigint	No
EVENT_NAME (Primary)	varchar(128)	No
COUNT_ALLOC	bigint	No
COUNT_FREE	bigint	No
SUM_NUMBER_OF_BYTES_ALLOC	bigint	No
SUM_NUMBER_OF_BYTES_FREE	bigint	No
LOW_COUNT_USED	bigint	No
CURRENT_COUNT_USED	bigint	No
HIGH_COUNT_USED	bigint	No
LOW_NUMBER_OF_BYTES_USED	bigint	No
CURRENT_NUMBER_OF_BYTES_USED	bigint	No
HIGH_NUMBER_OF_BYTES_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

memory_summary_by_user_by_event_name

Column	Type	Null	Default
USER	char(32)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_ALLOC	bigint	No
COUNT_FREE	bigint	No
SUM_NUMBER_OF_BYTES_ALLOC	bigint	No
SUM_NUMBER_OF_BYTES_FREE	bigint	No
LOW_COUNT_USED	bigint	No
CURRENT_COUNT_USED	bigint	No
HIGH_COUNT_USED	bigint	No
LOW_NUMBER_OF_BYTES_USED	bigint	No
CURRENT_NUMBER_OF_BYTES_USED	bigint	No
HIGH_NUMBER_OF_BYTES_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

memory_summary_global_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_ALLOC	bigint	No
COUNT_FREE	bigint	No
SUM_NUMBER_OF_BYTES_ALLOC	bigint	No
SUM_NUMBER_OF_BYTES_FREE	bigint	No
LOW_COUNT_USED	bigint	No
CURRENT_COUNT_USED	bigint	No
HIGH_COUNT_USED	bigint	No
LOW_NUMBER_OF_BYTES_USED	bigint	No
CURRENT_NUMBER_OF_BYTES_USED	bigint	No
HIGH_NUMBER_OF_BYTES_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

metadata_locks

Column	Type	Null	Default
OBJECT_TYPE	varchar(64)	No
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
COLUMN_NAME	varchar(64)	Yes	NULL
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
LOCK_TYPE	varchar(32)	No
LOCK_DURATION	varchar(32)	No
LOCK_STATUS	varchar(32)	No
SOURCE	varchar(64)	Yes	NULL
OWNER_THREAD_ID	bigint	Yes	NULL
OWNER_EVENT_ID	bigint	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
OBJECT_TYPE	HASH	No	No	OBJECT_TYPE	No
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes
				COLUMN_NAME	Yes
OWNER_THREAD_ID	HASH	No	No	OWNER_THREAD_ID	Yes
OWNER_THREAD_ID	HASH	No	No	OWNER_EVENT_ID	Yes

mutex_instances

Column	Type	Null	Default
NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
LOCKED_BY_THREAD_ID	bigint	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
NAME	HASH	No	No	NAME	No
LOCKED_BY_THREAD_ID	HASH	No	No	LOCKED_BY_THREAD_ID	Yes

objects_summary_global_by_type

Column	Type	Null	Default
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes

performance_timers

Column	Type	Null	Default
TIMER_NAME	enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND')	No
TIMER_FREQUENCY	bigint	Yes	NULL
TIMER_RESOLUTION	bigint	Yes	NULL
TIMER_OVERHEAD	bigint	Yes	NULL

persisted_variables

Column	Type	Null	Default	Links to	Comments	MIME
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

prepared_statements_instances

Column	Type	Null	Default
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
STATEMENT_ID	bigint	No
STATEMENT_NAME	varchar(64)	Yes	NULL
SQL_TEXT	longtext	No
OWNER_THREAD_ID	bigint	No
OWNER_EVENT_ID	bigint	No
OWNER_OBJECT_TYPE	enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER')	Yes	NULL
OWNER_OBJECT_SCHEMA	varchar(64)	Yes	NULL
OWNER_OBJECT_NAME	varchar(64)	Yes	NULL
TIMER_PREPARE	bigint	No
COUNT_REPREPARE	bigint	No
COUNT_EXECUTE	bigint	No
SUM_TIMER_EXECUTE	bigint	No
MIN_TIMER_EXECUTE	bigint	No
AVG_TIMER_EXECUTE	bigint	No
MAX_TIMER_EXECUTE	bigint	No
SUM_LOCK_TIME	bigint	No
SUM_ERRORS	bigint	No
SUM_WARNINGS	bigint	No
SUM_ROWS_AFFECTED	bigint	No
SUM_ROWS_SENT	bigint	No
SUM_ROWS_EXAMINED	bigint	No
SUM_CREATED_TMP_DISK_TABLES	bigint	No
SUM_CREATED_TMP_TABLES	bigint	No
SUM_SELECT_FULL_JOIN	bigint	No
SUM_SELECT_FULL_RANGE_JOIN	bigint	No
SUM_SELECT_RANGE	bigint	No
SUM_SELECT_RANGE_CHECK	bigint	No
SUM_SELECT_SCAN	bigint	No
SUM_SORT_MERGE_PASSES	bigint	No
SUM_SORT_RANGE	bigint	No
SUM_SORT_ROWS	bigint	No
SUM_SORT_SCAN	bigint	No
SUM_NO_INDEX_USED	bigint	No
SUM_NO_GOOD_INDEX_USED	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
OWNER_THREAD_ID	HASH	Yes	No	OWNER_THREAD_ID	No
OWNER_THREAD_ID	HASH	Yes	No	OWNER_EVENT_ID	No
STATEMENT_ID	HASH	No	No	STATEMENT_ID	No
STATEMENT_NAME	HASH	No	No	STATEMENT_NAME	Yes
OWNER_OBJECT_TYPE	HASH	No	No	OWNER_OBJECT_TYPE	Yes
				OWNER_OBJECT_SCHEMA	Yes
				OWNER_OBJECT_NAME	Yes

replication_applier_configuration

Column	Type	Null	Default	Comments
CHANNEL_NAME (Primary)	char(64)	No
DESIRED_DELAY	int	No
PRIVILEGE_CHECKS_USER	text	Yes	NULL	User name for the security context of the applier.
REQUIRE_ROW_FORMAT	enum('YES', 'NO')	No		Indicates whether the channel shall only accept row based events.

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No

replication_applier_filters

Column	Type	Null	Default
CHANNEL_NAME	char(64)	No
FILTER_NAME	char(64)	No
FILTER_RULE	longtext	No
CONFIGURED_BY	enum('STARTUP_OPTIONS', 'CHANGE_REPLICATION_FILTER', 'STARTUP_OPTIONS_FOR_CHANNEL', 'CHANGE_REPLICATION_FILTER_FOR_CHANNEL')	No
ACTIVE_SINCE	timestamp(6)	No	0000-00-00 00:00:00.000000
COUNTER	bigint	No	0

replication_applier_global_filters

Column	Type	Null	Default
FILTER_NAME	char(64)	No
FILTER_RULE	longtext	No
CONFIGURED_BY	enum('STARTUP_OPTIONS', 'CHANGE_REPLICATION_FILTER')	No
ACTIVE_SINCE	timestamp(6)	No	0000-00-00 00:00:00.000000

replication_applier_status

Column	Type	Null	Default
CHANNEL_NAME (Primary)	char(64)	No
SERVICE_STATE	enum('ON', 'OFF')	No
REMAINING_DELAY	int	Yes	NULL
COUNT_TRANSACTIONS_RETRIES	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No

replication_applier_status_by_coordinator

Column	Type	Null	Default
CHANNEL_NAME (Primary)	char(64)	No
THREAD_ID	bigint	Yes	NULL
SERVICE_STATE	enum('ON', 'OFF')	No
LAST_ERROR_NUMBER	int	No
LAST_ERROR_MESSAGE	varchar(1024)	No
LAST_ERROR_TIMESTAMP	timestamp(6)	No
LAST_PROCESSED_TRANSACTION	char(57)	Yes	NULL
LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP	timestamp(6)	No
LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP	timestamp(6)	No
LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP	timestamp(6)	No
LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP	timestamp(6)	No
PROCESSING_TRANSACTION	char(57)	Yes	NULL
PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP	timestamp(6)	No
PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP	timestamp(6)	No
PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP	timestamp(6)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No
THREAD_ID	HASH	No	No	THREAD_ID			Yes

replication_applier_status_by_worker

Column	Type	Null	Default
CHANNEL_NAME (Primary)	char(64)	No
WORKER_ID (Primary)	bigint	No
THREAD_ID	bigint	Yes	NULL
SERVICE_STATE	enum('ON', 'OFF')	No
LAST_ERROR_NUMBER	int	No
LAST_ERROR_MESSAGE	varchar(1024)	No
LAST_ERROR_TIMESTAMP	timestamp(6)	No
LAST_APPLIED_TRANSACTION	char(57)	Yes	NULL
LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP	timestamp(6)	No
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP	timestamp(6)	No
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP	timestamp(6)	No
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP	timestamp(6)	No
APPLYING_TRANSACTION	char(57)	Yes	NULL
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP	timestamp(6)	No
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP	timestamp(6)	No
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP	timestamp(6)	No
LAST_APPLIED_TRANSACTION_RETRIES_COUNT	bigint	No
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER	int	No
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE	varchar(1024)	Yes	NULL
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP	timestamp(6)	No
APPLYING_TRANSACTION_RETRIES_COUNT	bigint	No
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER	int	No
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE	varchar(1024)	Yes	NULL
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP	timestamp(6)	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	CHANNEL_NAME	No
PRIMARY	HASH	Yes	No	WORKER_ID	No
THREAD_ID	HASH	No	No	THREAD_ID	Yes

replication_connection_configuration

Column	Type	Null	Default	Comments
CHANNEL_NAME (Primary)	char(64)	No
HOST	char(255)	No
PORT	int	No
USER	char(32)	No
NETWORK_INTERFACE	char(60)	No
AUTO_POSITION	enum('1', '0')	No
SSL_ALLOWED	enum('YES', 'NO', 'IGNORED')	No
SSL_CA_FILE	varchar(512)	No
SSL_CA_PATH	varchar(512)	No
SSL_CERTIFICATE	varchar(512)	No
SSL_CIPHER	varchar(512)	No
SSL_KEY	varchar(512)	No
SSL_VERIFY_SERVER_CERTIFICATE	enum('YES', 'NO')	No
SSL_CRL_FILE	varchar(255)	No
SSL_CRL_PATH	varchar(255)	No
CONNECTION_RETRY_INTERVAL	int	No
CONNECTION_RETRY_COUNT	bigint	No
HEARTBEAT_INTERVAL	double(10,3)	No		Number of seconds after which a heartbeat will be sent .
TLS_VERSION	varchar(255)	No
PUBLIC_KEY_PATH	varchar(512)	No
GET_PUBLIC_KEY	enum('YES', 'NO')	No
NETWORK_NAMESPACE	varchar(64)	No
COMPRESSION_ALGORITHM	char(64)	No		Compression algorithm used for data transfer between master and slave.
ZSTD_COMPRESSION_LEVEL	int	No		Compression level associated with zstd compression algorithm.
TLS_CIPHERSUITES	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No

replication_connection_status

Column	Type	Null	Default	Comments
CHANNEL_NAME (Primary)	char(64)	No
GROUP_NAME	char(36)	No
SOURCE_UUID	char(36)	No
THREAD_ID	bigint	Yes	NULL
SERVICE_STATE	enum('ON', 'OFF', 'CONNECTING')	No
COUNT_RECEIVED_HEARTBEATS	bigint	No	0
LAST_HEARTBEAT_TIMESTAMP	timestamp(6)	No		Shows when the most recent heartbeat signal was received.
RECEIVED_TRANSACTION_SET	longtext	No
LAST_ERROR_NUMBER	int	No
LAST_ERROR_MESSAGE	varchar(1024)	No
LAST_ERROR_TIMESTAMP	timestamp(6)	No
LAST_QUEUED_TRANSACTION	char(57)	Yes	NULL
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP	timestamp(6)	No
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP	timestamp(6)	No
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP	timestamp(6)	No
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP	timestamp(6)	No
QUEUEING_TRANSACTION	char(57)	Yes	NULL
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP	timestamp(6)	No
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP	timestamp(6)	No
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP	timestamp(6)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No
THREAD_ID	HASH	No	No	THREAD_ID			Yes

replication_group_members

Column	Type	Null	Default
CHANNEL_NAME	char(64)	No
MEMBER_ID	char(36)	No
MEMBER_HOST	char(255)	No
MEMBER_PORT	int	Yes	NULL
MEMBER_STATE	char(64)	No
MEMBER_ROLE	char(64)	No
MEMBER_VERSION	char(64)	No

replication_group_member_stats

Column	Type	Null
CHANNEL_NAME	char(64)	No
VIEW_ID	char(60)	No
MEMBER_ID	char(36)	No
COUNT_TRANSACTIONS_IN_QUEUE	bigint	No
COUNT_TRANSACTIONS_CHECKED	bigint	No
COUNT_CONFLICTS_DETECTED	bigint	No
COUNT_TRANSACTIONS_ROWS_VALIDATING	bigint	No
TRANSACTIONS_COMMITTED_ALL_MEMBERS	longtext	No
LAST_CONFLICT_FREE_TRANSACTION	text	No
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE	bigint	No
COUNT_TRANSACTIONS_REMOTE_APPLIED	bigint	No
COUNT_TRANSACTIONS_LOCAL_PROPOSED	bigint	No
COUNT_TRANSACTIONS_LOCAL_ROLLBACK	bigint	No

rwlock_instances

Column	Type	Null	Default
NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
WRITE_LOCKED_BY_THREAD_ID	bigint	Yes	NULL
READ_LOCKED_BY_COUNT	int	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
NAME	HASH	No	No	NAME	No
WRITE_LOCKED_BY_THREAD_ID	HASH	No	No	WRITE_LOCKED_BY_THREAD_ID	Yes

session_account_connect_attrs

Column	Type	Null	Default
PROCESSLIST_ID (Primary)	bigint	No
ATTR_NAME (Primary)	varchar(32)	No
ATTR_VALUE	varchar(1024)	Yes	NULL
ORDINAL_POSITION	int	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	PROCESSLIST_ID			No
PRIMARY	HASH	Yes	No	ATTR_NAME			No

session_connect_attrs

Column	Type	Null	Default
PROCESSLIST_ID (Primary)	bigint	No
ATTR_NAME (Primary)	varchar(32)	No
ATTR_VALUE	varchar(1024)	Yes	NULL
ORDINAL_POSITION	int	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	PROCESSLIST_ID			No
PRIMARY	HASH	Yes	No	ATTR_NAME			No

session_status

Column	Type	Null	Default	Links to	Comments	MIME
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

session_variables

Column	Type	Null	Default	Links to	Comments	MIME
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

setup_actors

Column	Type	Null	Default
HOST (Primary)	char(255)	No	%
USER (Primary)	char(32)	No	%
ROLE (Primary)	char(32)	No	%
ENABLED	enum('YES', 'NO')	No	YES
HISTORY	enum('YES', 'NO')	No	YES

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	HOST	No
				USER	No
				ROLE	No

setup_consumers

Column	Type	Null	Default	Links to	Comments	MIME
NAME (Primary)	varchar(64)	No
ENABLED	enum('YES', 'NO')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	NAME			No

setup_instruments

Column	Type	Null	Default
NAME (Primary)	varchar(128)	No
ENABLED	enum('YES', 'NO')	No
TIMED	enum('YES', 'NO')	Yes	NULL
PROPERTIES	set('singleton', 'progress', 'user', 'global_statistics', 'mutable')	No
VOLATILITY	int	No
DOCUMENTATION	longtext	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	NAME			No

setup_objects

Column	Type	Null	Default
OBJECT_TYPE	enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER')	No	TABLE
OBJECT_SCHEMA	varchar(64)	Yes	%
OBJECT_NAME	varchar(64)	No	%
ENABLED	enum('YES', 'NO')	No	YES
TIMED	enum('YES', 'NO')	No	YES

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	No
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	No

setup_threads

Column	Type	Null	Default
NAME (Primary)	varchar(128)	No
ENABLED	enum('YES', 'NO')	No
HISTORY	enum('YES', 'NO')	No
PROPERTIES	set('singleton', 'user')	No
VOLATILITY	int	No
DOCUMENTATION	longtext	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	NAME			No

socket_instances

Column	Type	Null	Default
EVENT_NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
THREAD_ID	bigint	Yes	NULL
SOCKET_ID	int	No
IP	varchar(64)	No
PORT	int	No
STATE	enum('IDLE', 'ACTIVE')	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
THREAD_ID	HASH	No	No	THREAD_ID	Yes
SOCKET_ID	HASH	No	No	SOCKET_ID	No
IP	HASH	No	No	IP	No
IP	HASH	No	No	PORT	No

socket_summary_by_event_name

Column	Type	Null
EVENT_NAME (Primary)	varchar(128)	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
SUM_NUMBER_OF_BYTES_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
SUM_NUMBER_OF_BYTES_WRITE	bigint	No
COUNT_MISC	bigint	No
SUM_TIMER_MISC	bigint	No
MIN_TIMER_MISC	bigint	No
AVG_TIMER_MISC	bigint	No
MAX_TIMER_MISC	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

socket_summary_by_instance

Column	Type	Null
EVENT_NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
SUM_NUMBER_OF_BYTES_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
SUM_NUMBER_OF_BYTES_WRITE	bigint	No
COUNT_MISC	bigint	No
SUM_TIMER_MISC	bigint	No
MIN_TIMER_MISC	bigint	No
AVG_TIMER_MISC	bigint	No
MAX_TIMER_MISC	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN			No
EVENT_NAME	HASH	No	No	EVENT_NAME			No

status_by_account

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
VARIABLE_NAME	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				VARIABLE_NAME	No

status_by_host

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
VARIABLE_NAME	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	VARIABLE_NAME			No

status_by_thread

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

status_by_user

Column	Type	Null	Default
USER	char(32)	Yes	NULL
VARIABLE_NAME	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	VARIABLE_NAME			No

table_handles

Column	Type	Null	Default
OBJECT_TYPE	varchar(64)	No
OBJECT_SCHEMA	varchar(64)	No
OBJECT_NAME	varchar(64)	No
OBJECT_INSTANCE_BEGIN (Primary)	bigint	No
OWNER_THREAD_ID	bigint	Yes	NULL
OWNER_EVENT_ID	bigint	Yes	NULL
INTERNAL_LOCK	varchar(64)	Yes	NULL
EXTERNAL_LOCK	varchar(64)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
OBJECT_TYPE	HASH	No	No	OBJECT_TYPE	No
				OBJECT_SCHEMA	No
				OBJECT_NAME	No
OWNER_THREAD_ID	HASH	No	No	OWNER_THREAD_ID	Yes
OWNER_THREAD_ID	HASH	No	No	OWNER_EVENT_ID	Yes

table_io_waits_summary_by_index_usage

Column	Type	Null	Default
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
INDEX_NAME	varchar(64)	Yes	NULL
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
COUNT_FETCH	bigint	No
SUM_TIMER_FETCH	bigint	No
MIN_TIMER_FETCH	bigint	No
AVG_TIMER_FETCH	bigint	No
MAX_TIMER_FETCH	bigint	No
COUNT_INSERT	bigint	No
SUM_TIMER_INSERT	bigint	No
MIN_TIMER_INSERT	bigint	No
AVG_TIMER_INSERT	bigint	No
MAX_TIMER_INSERT	bigint	No
COUNT_UPDATE	bigint	No
SUM_TIMER_UPDATE	bigint	No
MIN_TIMER_UPDATE	bigint	No
AVG_TIMER_UPDATE	bigint	No
MAX_TIMER_UPDATE	bigint	No
COUNT_DELETE	bigint	No
SUM_TIMER_DELETE	bigint	No
MIN_TIMER_DELETE	bigint	No
AVG_TIMER_DELETE	bigint	No
MAX_TIMER_DELETE	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes
				INDEX_NAME	Yes

table_io_waits_summary_by_table

Column	Type	Null	Default
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
COUNT_FETCH	bigint	No
SUM_TIMER_FETCH	bigint	No
MIN_TIMER_FETCH	bigint	No
AVG_TIMER_FETCH	bigint	No
MAX_TIMER_FETCH	bigint	No
COUNT_INSERT	bigint	No
SUM_TIMER_INSERT	bigint	No
MIN_TIMER_INSERT	bigint	No
AVG_TIMER_INSERT	bigint	No
MAX_TIMER_INSERT	bigint	No
COUNT_UPDATE	bigint	No
SUM_TIMER_UPDATE	bigint	No
MIN_TIMER_UPDATE	bigint	No
AVG_TIMER_UPDATE	bigint	No
MAX_TIMER_UPDATE	bigint	No
COUNT_DELETE	bigint	No
SUM_TIMER_DELETE	bigint	No
MIN_TIMER_DELETE	bigint	No
AVG_TIMER_DELETE	bigint	No
MAX_TIMER_DELETE	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes

table_lock_waits_summary_by_table

Column	Type	Null	Default
OBJECT_TYPE	varchar(64)	Yes	NULL
OBJECT_SCHEMA	varchar(64)	Yes	NULL
OBJECT_NAME	varchar(64)	Yes	NULL
COUNT_STAR	bigint	No
SUM_TIMER_WAIT	bigint	No
MIN_TIMER_WAIT	bigint	No
AVG_TIMER_WAIT	bigint	No
MAX_TIMER_WAIT	bigint	No
COUNT_READ	bigint	No
SUM_TIMER_READ	bigint	No
MIN_TIMER_READ	bigint	No
AVG_TIMER_READ	bigint	No
MAX_TIMER_READ	bigint	No
COUNT_WRITE	bigint	No
SUM_TIMER_WRITE	bigint	No
MIN_TIMER_WRITE	bigint	No
AVG_TIMER_WRITE	bigint	No
MAX_TIMER_WRITE	bigint	No
COUNT_READ_NORMAL	bigint	No
SUM_TIMER_READ_NORMAL	bigint	No
MIN_TIMER_READ_NORMAL	bigint	No
AVG_TIMER_READ_NORMAL	bigint	No
MAX_TIMER_READ_NORMAL	bigint	No
COUNT_READ_WITH_SHARED_LOCKS	bigint	No
SUM_TIMER_READ_WITH_SHARED_LOCKS	bigint	No
MIN_TIMER_READ_WITH_SHARED_LOCKS	bigint	No
AVG_TIMER_READ_WITH_SHARED_LOCKS	bigint	No
MAX_TIMER_READ_WITH_SHARED_LOCKS	bigint	No
COUNT_READ_HIGH_PRIORITY	bigint	No
SUM_TIMER_READ_HIGH_PRIORITY	bigint	No
MIN_TIMER_READ_HIGH_PRIORITY	bigint	No
AVG_TIMER_READ_HIGH_PRIORITY	bigint	No
MAX_TIMER_READ_HIGH_PRIORITY	bigint	No
COUNT_READ_NO_INSERT	bigint	No
SUM_TIMER_READ_NO_INSERT	bigint	No
MIN_TIMER_READ_NO_INSERT	bigint	No
AVG_TIMER_READ_NO_INSERT	bigint	No
MAX_TIMER_READ_NO_INSERT	bigint	No
COUNT_READ_EXTERNAL	bigint	No
SUM_TIMER_READ_EXTERNAL	bigint	No
MIN_TIMER_READ_EXTERNAL	bigint	No
AVG_TIMER_READ_EXTERNAL	bigint	No
MAX_TIMER_READ_EXTERNAL	bigint	No
COUNT_WRITE_ALLOW_WRITE	bigint	No
SUM_TIMER_WRITE_ALLOW_WRITE	bigint	No
MIN_TIMER_WRITE_ALLOW_WRITE	bigint	No
AVG_TIMER_WRITE_ALLOW_WRITE	bigint	No
MAX_TIMER_WRITE_ALLOW_WRITE	bigint	No
COUNT_WRITE_CONCURRENT_INSERT	bigint	No
SUM_TIMER_WRITE_CONCURRENT_INSERT	bigint	No
MIN_TIMER_WRITE_CONCURRENT_INSERT	bigint	No
AVG_TIMER_WRITE_CONCURRENT_INSERT	bigint	No
MAX_TIMER_WRITE_CONCURRENT_INSERT	bigint	No
COUNT_WRITE_LOW_PRIORITY	bigint	No
SUM_TIMER_WRITE_LOW_PRIORITY	bigint	No
MIN_TIMER_WRITE_LOW_PRIORITY	bigint	No
AVG_TIMER_WRITE_LOW_PRIORITY	bigint	No
MAX_TIMER_WRITE_LOW_PRIORITY	bigint	No
COUNT_WRITE_NORMAL	bigint	No
SUM_TIMER_WRITE_NORMAL	bigint	No
MIN_TIMER_WRITE_NORMAL	bigint	No
AVG_TIMER_WRITE_NORMAL	bigint	No
MAX_TIMER_WRITE_NORMAL	bigint	No
COUNT_WRITE_EXTERNAL	bigint	No
SUM_TIMER_WRITE_EXTERNAL	bigint	No
MIN_TIMER_WRITE_EXTERNAL	bigint	No
AVG_TIMER_WRITE_EXTERNAL	bigint	No
MAX_TIMER_WRITE_EXTERNAL	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes

threads

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
NAME	varchar(128)	No
TYPE	varchar(10)	No
PROCESSLIST_ID	bigint	Yes	NULL
PROCESSLIST_USER	varchar(32)	Yes	NULL
PROCESSLIST_HOST	varchar(255)	Yes	NULL
PROCESSLIST_DB	varchar(64)	Yes	NULL
PROCESSLIST_COMMAND	varchar(16)	Yes	NULL
PROCESSLIST_TIME	bigint	Yes	NULL
PROCESSLIST_STATE	varchar(64)	Yes	NULL
PROCESSLIST_INFO	longtext	Yes	NULL
PARENT_THREAD_ID	bigint	Yes	NULL
ROLE	varchar(64)	Yes	NULL
INSTRUMENTED	enum('YES', 'NO')	No
HISTORY	enum('YES', 'NO')	No
CONNECTION_TYPE	varchar(16)	Yes	NULL
THREAD_OS_ID	bigint	Yes	NULL
RESOURCE_GROUP	varchar(64)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	THREAD_ID	No
PROCESSLIST_ID	HASH	No	No	PROCESSLIST_ID	Yes
THREAD_OS_ID	HASH	No	No	THREAD_OS_ID	Yes
NAME	HASH	No	No	NAME	No
PROCESSLIST_ACCOUNT	HASH	No	No	PROCESSLIST_USER	Yes
PROCESSLIST_ACCOUNT	HASH	No	No	PROCESSLIST_HOST	Yes
PROCESSLIST_HOST	HASH	No	No	PROCESSLIST_HOST	Yes
RESOURCE_GROUP	HASH	No	No	RESOURCE_GROUP	Yes

users

Column	Type	Null	Default
USER	char(32)	Yes	NULL
CURRENT_CONNECTIONS	bigint	No
TOTAL_CONNECTIONS	bigint	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes

user_defined_functions

Column	Type	Null	Default
UDF_NAME (Primary)	varchar(64)	No
UDF_RETURN_TYPE	varchar(20)	No
UDF_TYPE	varchar(20)	No
UDF_LIBRARY	varchar(1024)	Yes	NULL
UDF_USAGE_COUNT	bigint	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	UDF_NAME			No

user_variables_by_thread

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	longblob	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

variables_by_thread

Column	Type	Null	Default
THREAD_ID (Primary)	bigint	No
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

variables_info

Column	Type	Null	Default
VARIABLE_NAME	varchar(64)	No
VARIABLE_SOURCE	enum('COMPILED', 'GLOBAL', 'SERVER', 'EXPLICIT', 'EXTRA', 'USER', 'LOGIN', 'COMMAND_LINE', 'PERSISTED', 'DYNAMIC')	Yes	COMPILED
VARIABLE_PATH	varchar(1024)	Yes	NULL
MIN_VALUE	varchar(64)	Yes	NULL
MAX_VALUE	varchar(64)	Yes	NULL
SET_TIME	timestamp(6)	Yes	NULL
SET_USER	char(32)	Yes	NULL
SET_HOST	char(255)	Yes	NULL