accounts

Column	Type	Null	Default	Comments
USER	char(16)	Yes	NULL
HOST	char(60)	Yes	NULL
CURRENT_CONNECTIONS	bigint(20)	No
TOTAL_CONNECTIONS	bigint(20)	No

cond_instances

Column	Type	Null	Default	Comments
NAME	varchar(128)	No
OBJECT_INSTANCE_BEGIN	bigint(20)	No

events_stages_current

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

events_stages_history

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

events_stages_history_long

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

events_stages_summary_by_account_by_event_name

Column	Type	Null	Default	Comments
USER	char(16)	Yes	NULL
HOST	char(60)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint(20)	No
SUM_TIMER_WAIT	bigint(20)	No
MIN_TIMER_WAIT	bigint(20)	No
AVG_TIMER_WAIT	bigint(20)	No
MAX_TIMER_WAIT	bigint(20)	No

events_stages_summary_by_host_by_event_name

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

events_stages_summary_by_thread_by_event_name

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

events_stages_summary_by_user_by_event_name

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

events_stages_summary_global_by_event_name

Column	Type	Null	Default	Comments
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint(20)	No
SUM_TIMER_WAIT	bigint(20)	No
MIN_TIMER_WAIT	bigint(20)	No
AVG_TIMER_WAIT	bigint(20)	No
MAX_TIMER_WAIT	bigint(20)	No

events_statements_current

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
EVENT_ID	bigint(20)	No
END_EVENT_ID	bigint(20)	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint(20)	Yes	NULL
TIMER_END	bigint(20)	Yes	NULL
TIMER_WAIT	bigint(20)	Yes	NULL
LOCK_TIME	bigint(20)	No
SQL_TEXT	longtext	Yes	NULL
DIGEST	varchar(32)	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(20)	Yes	NULL
MYSQL_ERRNO	int(11)	Yes	NULL
RETURNED_SQLSTATE	varchar(5)	Yes	NULL
MESSAGE_TEXT	varchar(128)	Yes	NULL
ERRORS	bigint(20)	No
WARNINGS	bigint(20)	No
ROWS_AFFECTED	bigint(20)	No
ROWS_SENT	bigint(20)	No
ROWS_EXAMINED	bigint(20)	No
CREATED_TMP_DISK_TABLES	bigint(20)	No
CREATED_TMP_TABLES	bigint(20)	No
SELECT_FULL_JOIN	bigint(20)	No
SELECT_FULL_RANGE_JOIN	bigint(20)	No
SELECT_RANGE	bigint(20)	No
SELECT_RANGE_CHECK	bigint(20)	No
SELECT_SCAN	bigint(20)	No
SORT_MERGE_PASSES	bigint(20)	No
SORT_RANGE	bigint(20)	No
SORT_ROWS	bigint(20)	No
SORT_SCAN	bigint(20)	No
NO_INDEX_USED	bigint(20)	No
NO_GOOD_INDEX_USED	bigint(20)	No
NESTING_EVENT_ID	bigint(20)	Yes	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

events_statements_history

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
EVENT_ID	bigint(20)	No
END_EVENT_ID	bigint(20)	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint(20)	Yes	NULL
TIMER_END	bigint(20)	Yes	NULL
TIMER_WAIT	bigint(20)	Yes	NULL
LOCK_TIME	bigint(20)	No
SQL_TEXT	longtext	Yes	NULL
DIGEST	varchar(32)	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(20)	Yes	NULL
MYSQL_ERRNO	int(11)	Yes	NULL
RETURNED_SQLSTATE	varchar(5)	Yes	NULL
MESSAGE_TEXT	varchar(128)	Yes	NULL
ERRORS	bigint(20)	No
WARNINGS	bigint(20)	No
ROWS_AFFECTED	bigint(20)	No
ROWS_SENT	bigint(20)	No
ROWS_EXAMINED	bigint(20)	No
CREATED_TMP_DISK_TABLES	bigint(20)	No
CREATED_TMP_TABLES	bigint(20)	No
SELECT_FULL_JOIN	bigint(20)	No
SELECT_FULL_RANGE_JOIN	bigint(20)	No
SELECT_RANGE	bigint(20)	No
SELECT_RANGE_CHECK	bigint(20)	No
SELECT_SCAN	bigint(20)	No
SORT_MERGE_PASSES	bigint(20)	No
SORT_RANGE	bigint(20)	No
SORT_ROWS	bigint(20)	No
SORT_SCAN	bigint(20)	No
NO_INDEX_USED	bigint(20)	No
NO_GOOD_INDEX_USED	bigint(20)	No
NESTING_EVENT_ID	bigint(20)	Yes	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

events_statements_history_long

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
EVENT_ID	bigint(20)	No
END_EVENT_ID	bigint(20)	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint(20)	Yes	NULL
TIMER_END	bigint(20)	Yes	NULL
TIMER_WAIT	bigint(20)	Yes	NULL
LOCK_TIME	bigint(20)	No
SQL_TEXT	longtext	Yes	NULL
DIGEST	varchar(32)	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(20)	Yes	NULL
MYSQL_ERRNO	int(11)	Yes	NULL
RETURNED_SQLSTATE	varchar(5)	Yes	NULL
MESSAGE_TEXT	varchar(128)	Yes	NULL
ERRORS	bigint(20)	No
WARNINGS	bigint(20)	No
ROWS_AFFECTED	bigint(20)	No
ROWS_SENT	bigint(20)	No
ROWS_EXAMINED	bigint(20)	No
CREATED_TMP_DISK_TABLES	bigint(20)	No
CREATED_TMP_TABLES	bigint(20)	No
SELECT_FULL_JOIN	bigint(20)	No
SELECT_FULL_RANGE_JOIN	bigint(20)	No
SELECT_RANGE	bigint(20)	No
SELECT_RANGE_CHECK	bigint(20)	No
SELECT_SCAN	bigint(20)	No
SORT_MERGE_PASSES	bigint(20)	No
SORT_RANGE	bigint(20)	No
SORT_ROWS	bigint(20)	No
SORT_SCAN	bigint(20)	No
NO_INDEX_USED	bigint(20)	No
NO_GOOD_INDEX_USED	bigint(20)	No
NESTING_EVENT_ID	bigint(20)	Yes	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	Yes	NULL

events_statements_summary_by_account_by_event_name

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

events_statements_summary_by_digest

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

events_statements_summary_by_host_by_event_name

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

events_statements_summary_by_thread_by_event_name

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

events_statements_summary_by_user_by_event_name

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

events_statements_summary_global_by_event_name

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

events_waits_current

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
EVENT_ID	bigint(20)	No
END_EVENT_ID	bigint(20)	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint(20)	Yes	NULL
TIMER_END	bigint(20)	Yes	NULL
TIMER_WAIT	bigint(20)	Yes	NULL
SPINS	int(10)	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(20)	No
NESTING_EVENT_ID	bigint(20)	Yes	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
OPERATION	varchar(32)	No
NUMBER_OF_BYTES	bigint(20)	Yes	NULL
FLAGS	int(10)	Yes	NULL

events_waits_history

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
EVENT_ID	bigint(20)	No
END_EVENT_ID	bigint(20)	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint(20)	Yes	NULL
TIMER_END	bigint(20)	Yes	NULL
TIMER_WAIT	bigint(20)	Yes	NULL
SPINS	int(10)	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(20)	No
NESTING_EVENT_ID	bigint(20)	Yes	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
OPERATION	varchar(32)	No
NUMBER_OF_BYTES	bigint(20)	Yes	NULL
FLAGS	int(10)	Yes	NULL

events_waits_history_long

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
EVENT_ID	bigint(20)	No
END_EVENT_ID	bigint(20)	Yes	NULL
EVENT_NAME	varchar(128)	No
SOURCE	varchar(64)	Yes	NULL
TIMER_START	bigint(20)	Yes	NULL
TIMER_END	bigint(20)	Yes	NULL
TIMER_WAIT	bigint(20)	Yes	NULL
SPINS	int(10)	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(20)	No
NESTING_EVENT_ID	bigint(20)	Yes	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	Yes	NULL
OPERATION	varchar(32)	No
NUMBER_OF_BYTES	bigint(20)	Yes	NULL
FLAGS	int(10)	Yes	NULL

events_waits_summary_by_account_by_event_name

Column	Type	Null	Default	Comments
USER	char(16)	Yes	NULL
HOST	char(60)	Yes	NULL
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint(20)	No
SUM_TIMER_WAIT	bigint(20)	No
MIN_TIMER_WAIT	bigint(20)	No
AVG_TIMER_WAIT	bigint(20)	No
MAX_TIMER_WAIT	bigint(20)	No

events_waits_summary_by_host_by_event_name

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

events_waits_summary_by_instance

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

events_waits_summary_by_thread_by_event_name

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

events_waits_summary_by_user_by_event_name

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

events_waits_summary_global_by_event_name

Column	Type	Null	Default	Comments
EVENT_NAME	varchar(128)	No
COUNT_STAR	bigint(20)	No
SUM_TIMER_WAIT	bigint(20)	No
MIN_TIMER_WAIT	bigint(20)	No
AVG_TIMER_WAIT	bigint(20)	No
MAX_TIMER_WAIT	bigint(20)	No

file_instances

Column	Type	Null	Default	Comments
FILE_NAME	varchar(512)	No
EVENT_NAME	varchar(128)	No
OPEN_COUNT	int(10)	No

file_summary_by_event_name

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

file_summary_by_instance

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

host_cache

Column	Type	Null	Default	Comments
IP	varchar(64)	No
HOST	varchar(255)	Yes	NULL
HOST_VALIDATED	enum('YES', 'NO')	No
SUM_CONNECT_ERRORS	bigint(20)	No
COUNT_HOST_BLOCKED_ERRORS	bigint(20)	No
COUNT_NAMEINFO_TRANSIENT_ERRORS	bigint(20)	No
COUNT_NAMEINFO_PERMANENT_ERRORS	bigint(20)	No
COUNT_FORMAT_ERRORS	bigint(20)	No
COUNT_ADDRINFO_TRANSIENT_ERRORS	bigint(20)	No
COUNT_ADDRINFO_PERMANENT_ERRORS	bigint(20)	No
COUNT_FCRDNS_ERRORS	bigint(20)	No
COUNT_HOST_ACL_ERRORS	bigint(20)	No
COUNT_NO_AUTH_PLUGIN_ERRORS	bigint(20)	No
COUNT_AUTH_PLUGIN_ERRORS	bigint(20)	No
COUNT_HANDSHAKE_ERRORS	bigint(20)	No
COUNT_PROXY_USER_ERRORS	bigint(20)	No
COUNT_PROXY_USER_ACL_ERRORS	bigint(20)	No
COUNT_AUTHENTICATION_ERRORS	bigint(20)	No
COUNT_SSL_ERRORS	bigint(20)	No
COUNT_MAX_USER_CONNECTIONS_ERRORS	bigint(20)	No
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	bigint(20)	No
COUNT_DEFAULT_DATABASE_ERRORS	bigint(20)	No
COUNT_INIT_CONNECT_ERRORS	bigint(20)	No
COUNT_LOCAL_ERRORS	bigint(20)	No
COUNT_UNKNOWN_ERRORS	bigint(20)	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

hosts

Column	Type	Null	Default	Comments
HOST	char(60)	Yes	NULL
CURRENT_CONNECTIONS	bigint(20)	No
TOTAL_CONNECTIONS	bigint(20)	No

mutex_instances

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

objects_summary_global_by_type

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

performance_timers

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

rwlock_instances

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

session_account_connect_attrs

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

session_connect_attrs

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

setup_actors

Column	Type	Null	Default	Comments
HOST	char(60)	No	%
USER	char(16)	No	%
ROLE	char(16)	No	%

setup_consumers

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

setup_instruments

Column	Type	Null	Default	Comments
NAME	varchar(128)	No
ENABLED	enum('YES', 'NO')	No
TIMED	enum('YES', 'NO')	No

setup_objects

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

setup_timers

Column	Type	Null	Default	Comments
NAME	varchar(64)	No
TIMER_NAME	enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')	No

socket_instances

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

socket_summary_by_event_name

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

socket_summary_by_instance

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

table_io_waits_summary_by_index_usage

Column	Type	Null	Default	Comments
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(20)	No
SUM_TIMER_WAIT	bigint(20)	No
MIN_TIMER_WAIT	bigint(20)	No
AVG_TIMER_WAIT	bigint(20)	No
MAX_TIMER_WAIT	bigint(20)	No
COUNT_READ	bigint(20)	No
SUM_TIMER_READ	bigint(20)	No
MIN_TIMER_READ	bigint(20)	No
AVG_TIMER_READ	bigint(20)	No
MAX_TIMER_READ	bigint(20)	No
COUNT_WRITE	bigint(20)	No
SUM_TIMER_WRITE	bigint(20)	No
MIN_TIMER_WRITE	bigint(20)	No
AVG_TIMER_WRITE	bigint(20)	No
MAX_TIMER_WRITE	bigint(20)	No
COUNT_FETCH	bigint(20)	No
SUM_TIMER_FETCH	bigint(20)	No
MIN_TIMER_FETCH	bigint(20)	No
AVG_TIMER_FETCH	bigint(20)	No
MAX_TIMER_FETCH	bigint(20)	No
COUNT_INSERT	bigint(20)	No
SUM_TIMER_INSERT	bigint(20)	No
MIN_TIMER_INSERT	bigint(20)	No
AVG_TIMER_INSERT	bigint(20)	No
MAX_TIMER_INSERT	bigint(20)	No
COUNT_UPDATE	bigint(20)	No
SUM_TIMER_UPDATE	bigint(20)	No
MIN_TIMER_UPDATE	bigint(20)	No
AVG_TIMER_UPDATE	bigint(20)	No
MAX_TIMER_UPDATE	bigint(20)	No
COUNT_DELETE	bigint(20)	No
SUM_TIMER_DELETE	bigint(20)	No
MIN_TIMER_DELETE	bigint(20)	No
AVG_TIMER_DELETE	bigint(20)	No
MAX_TIMER_DELETE	bigint(20)	No

table_io_waits_summary_by_table

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

table_lock_waits_summary_by_table

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

threads

Column	Type	Null	Default	Comments
THREAD_ID	bigint(20)	No
NAME	varchar(128)	No
TYPE	varchar(10)	No
PROCESSLIST_ID	bigint(20)	Yes	NULL
PROCESSLIST_USER	varchar(16)	Yes	NULL
PROCESSLIST_HOST	varchar(60)	Yes	NULL
PROCESSLIST_DB	varchar(64)	Yes	NULL
PROCESSLIST_COMMAND	varchar(16)	Yes	NULL
PROCESSLIST_TIME	bigint(20)	Yes	NULL
PROCESSLIST_STATE	varchar(64)	Yes	NULL
PROCESSLIST_INFO	longtext	Yes	NULL
PARENT_THREAD_ID	bigint(20)	Yes	NULL
ROLE	varchar(64)	Yes	NULL
INSTRUMENTED	enum('YES', 'NO')	No

users

Column	Type	Null	Default	Comments
USER	char(16)	Yes	NULL
CURRENT_CONNECTIONS	bigint(20)	No
TOTAL_CONNECTIONS	bigint(20)	No