打印预览 - phpMyAdmin 4.7.6

accounts

字段	类型	空	默认
USER	char(16)	是	NULL
HOST	char(60)	是	NULL
CURRENT_CONNECTIONS	bigint(20)	否
TOTAL_CONNECTIONS	bigint(20)	否

cond_instances

字段	类型	空	默认	链接到	注释	MIME
NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否

events_stages_current

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL

events_stages_history

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL

events_stages_history_long

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL

events_stages_summary_by_account_by_event_name

字段	类型	空	默认
USER	char(16)	是	NULL
HOST	char(60)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_stages_summary_by_host_by_event_name

字段	类型	空	默认
HOST	char(60)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_stages_summary_by_thread_by_event_name

字段	类型	空
THREAD_ID	bigint(20)	否
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_stages_summary_by_user_by_event_name

字段	类型	空	默认
USER	char(16)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_stages_summary_global_by_event_name

字段	类型	空
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_statements_current

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
LOCK_TIME	bigint(20)	否
SQL_TEXT	longtext	是	NULL
DIGEST	varchar(32)	是	NULL
DIGEST_TEXT	longtext	是	NULL
CURRENT_SCHEMA	varchar(64)	是	NULL
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(64)	是	NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	是	NULL
MYSQL_ERRNO	int(11)	是	NULL
RETURNED_SQLSTATE	varchar(5)	是	NULL
MESSAGE_TEXT	varchar(128)	是	NULL
ERRORS	bigint(20)	否
WARNINGS	bigint(20)	否
ROWS_AFFECTED	bigint(20)	否
ROWS_SENT	bigint(20)	否
ROWS_EXAMINED	bigint(20)	否
CREATED_TMP_DISK_TABLES	bigint(20)	否
CREATED_TMP_TABLES	bigint(20)	否
SELECT_FULL_JOIN	bigint(20)	否
SELECT_FULL_RANGE_JOIN	bigint(20)	否
SELECT_RANGE	bigint(20)	否
SELECT_RANGE_CHECK	bigint(20)	否
SELECT_SCAN	bigint(20)	否
SORT_MERGE_PASSES	bigint(20)	否
SORT_RANGE	bigint(20)	否
SORT_ROWS	bigint(20)	否
SORT_SCAN	bigint(20)	否
NO_INDEX_USED	bigint(20)	否
NO_GOOD_INDEX_USED	bigint(20)	否
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL

events_statements_history

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
LOCK_TIME	bigint(20)	否
SQL_TEXT	longtext	是	NULL
DIGEST	varchar(32)	是	NULL
DIGEST_TEXT	longtext	是	NULL
CURRENT_SCHEMA	varchar(64)	是	NULL
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(64)	是	NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	是	NULL
MYSQL_ERRNO	int(11)	是	NULL
RETURNED_SQLSTATE	varchar(5)	是	NULL
MESSAGE_TEXT	varchar(128)	是	NULL
ERRORS	bigint(20)	否
WARNINGS	bigint(20)	否
ROWS_AFFECTED	bigint(20)	否
ROWS_SENT	bigint(20)	否
ROWS_EXAMINED	bigint(20)	否
CREATED_TMP_DISK_TABLES	bigint(20)	否
CREATED_TMP_TABLES	bigint(20)	否
SELECT_FULL_JOIN	bigint(20)	否
SELECT_FULL_RANGE_JOIN	bigint(20)	否
SELECT_RANGE	bigint(20)	否
SELECT_RANGE_CHECK	bigint(20)	否
SELECT_SCAN	bigint(20)	否
SORT_MERGE_PASSES	bigint(20)	否
SORT_RANGE	bigint(20)	否
SORT_ROWS	bigint(20)	否
SORT_SCAN	bigint(20)	否
NO_INDEX_USED	bigint(20)	否
NO_GOOD_INDEX_USED	bigint(20)	否
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL

events_statements_history_long

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
LOCK_TIME	bigint(20)	否
SQL_TEXT	longtext	是	NULL
DIGEST	varchar(32)	是	NULL
DIGEST_TEXT	longtext	是	NULL
CURRENT_SCHEMA	varchar(64)	是	NULL
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(64)	是	NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	是	NULL
MYSQL_ERRNO	int(11)	是	NULL
RETURNED_SQLSTATE	varchar(5)	是	NULL
MESSAGE_TEXT	varchar(128)	是	NULL
ERRORS	bigint(20)	否
WARNINGS	bigint(20)	否
ROWS_AFFECTED	bigint(20)	否
ROWS_SENT	bigint(20)	否
ROWS_EXAMINED	bigint(20)	否
CREATED_TMP_DISK_TABLES	bigint(20)	否
CREATED_TMP_TABLES	bigint(20)	否
SELECT_FULL_JOIN	bigint(20)	否
SELECT_FULL_RANGE_JOIN	bigint(20)	否
SELECT_RANGE	bigint(20)	否
SELECT_RANGE_CHECK	bigint(20)	否
SELECT_SCAN	bigint(20)	否
SORT_MERGE_PASSES	bigint(20)	否
SORT_RANGE	bigint(20)	否
SORT_ROWS	bigint(20)	否
SORT_SCAN	bigint(20)	否
NO_INDEX_USED	bigint(20)	否
NO_GOOD_INDEX_USED	bigint(20)	否
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL

events_statements_summary_by_account_by_event_name

字段	类型	空	默认
USER	char(16)	是	NULL
HOST	char(60)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
SUM_LOCK_TIME	bigint(20)	否
SUM_ERRORS	bigint(20)	否
SUM_WARNINGS	bigint(20)	否
SUM_ROWS_AFFECTED	bigint(20)	否
SUM_ROWS_SENT	bigint(20)	否
SUM_ROWS_EXAMINED	bigint(20)	否
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否
SUM_CREATED_TMP_TABLES	bigint(20)	否
SUM_SELECT_FULL_JOIN	bigint(20)	否
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否
SUM_SELECT_RANGE	bigint(20)	否
SUM_SELECT_RANGE_CHECK	bigint(20)	否
SUM_SELECT_SCAN	bigint(20)	否
SUM_SORT_MERGE_PASSES	bigint(20)	否
SUM_SORT_RANGE	bigint(20)	否
SUM_SORT_ROWS	bigint(20)	否
SUM_SORT_SCAN	bigint(20)	否
SUM_NO_INDEX_USED	bigint(20)	否
SUM_NO_GOOD_INDEX_USED	bigint(20)	否

events_statements_summary_by_digest

字段	类型	空	默认
SCHEMA_NAME	varchar(64)	是	NULL
DIGEST	varchar(32)	是	NULL
DIGEST_TEXT	longtext	是	NULL
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
SUM_LOCK_TIME	bigint(20)	否
SUM_ERRORS	bigint(20)	否
SUM_WARNINGS	bigint(20)	否
SUM_ROWS_AFFECTED	bigint(20)	否
SUM_ROWS_SENT	bigint(20)	否
SUM_ROWS_EXAMINED	bigint(20)	否
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否
SUM_CREATED_TMP_TABLES	bigint(20)	否
SUM_SELECT_FULL_JOIN	bigint(20)	否
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否
SUM_SELECT_RANGE	bigint(20)	否
SUM_SELECT_RANGE_CHECK	bigint(20)	否
SUM_SELECT_SCAN	bigint(20)	否
SUM_SORT_MERGE_PASSES	bigint(20)	否
SUM_SORT_RANGE	bigint(20)	否
SUM_SORT_ROWS	bigint(20)	否
SUM_SORT_SCAN	bigint(20)	否
SUM_NO_INDEX_USED	bigint(20)	否
SUM_NO_GOOD_INDEX_USED	bigint(20)	否
FIRST_SEEN	timestamp	否	0000-00-00 00:00:00
LAST_SEEN	timestamp	否	0000-00-00 00:00:00

events_statements_summary_by_host_by_event_name

字段	类型	空	默认
HOST	char(60)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
SUM_LOCK_TIME	bigint(20)	否
SUM_ERRORS	bigint(20)	否
SUM_WARNINGS	bigint(20)	否
SUM_ROWS_AFFECTED	bigint(20)	否
SUM_ROWS_SENT	bigint(20)	否
SUM_ROWS_EXAMINED	bigint(20)	否
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否
SUM_CREATED_TMP_TABLES	bigint(20)	否
SUM_SELECT_FULL_JOIN	bigint(20)	否
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否
SUM_SELECT_RANGE	bigint(20)	否
SUM_SELECT_RANGE_CHECK	bigint(20)	否
SUM_SELECT_SCAN	bigint(20)	否
SUM_SORT_MERGE_PASSES	bigint(20)	否
SUM_SORT_RANGE	bigint(20)	否
SUM_SORT_ROWS	bigint(20)	否
SUM_SORT_SCAN	bigint(20)	否
SUM_NO_INDEX_USED	bigint(20)	否
SUM_NO_GOOD_INDEX_USED	bigint(20)	否

events_statements_summary_by_thread_by_event_name

字段	类型	空
THREAD_ID	bigint(20)	否
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
SUM_LOCK_TIME	bigint(20)	否
SUM_ERRORS	bigint(20)	否
SUM_WARNINGS	bigint(20)	否
SUM_ROWS_AFFECTED	bigint(20)	否
SUM_ROWS_SENT	bigint(20)	否
SUM_ROWS_EXAMINED	bigint(20)	否
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否
SUM_CREATED_TMP_TABLES	bigint(20)	否
SUM_SELECT_FULL_JOIN	bigint(20)	否
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否
SUM_SELECT_RANGE	bigint(20)	否
SUM_SELECT_RANGE_CHECK	bigint(20)	否
SUM_SELECT_SCAN	bigint(20)	否
SUM_SORT_MERGE_PASSES	bigint(20)	否
SUM_SORT_RANGE	bigint(20)	否
SUM_SORT_ROWS	bigint(20)	否
SUM_SORT_SCAN	bigint(20)	否
SUM_NO_INDEX_USED	bigint(20)	否
SUM_NO_GOOD_INDEX_USED	bigint(20)	否

events_statements_summary_by_user_by_event_name

字段	类型	空	默认
USER	char(16)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
SUM_LOCK_TIME	bigint(20)	否
SUM_ERRORS	bigint(20)	否
SUM_WARNINGS	bigint(20)	否
SUM_ROWS_AFFECTED	bigint(20)	否
SUM_ROWS_SENT	bigint(20)	否
SUM_ROWS_EXAMINED	bigint(20)	否
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否
SUM_CREATED_TMP_TABLES	bigint(20)	否
SUM_SELECT_FULL_JOIN	bigint(20)	否
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否
SUM_SELECT_RANGE	bigint(20)	否
SUM_SELECT_RANGE_CHECK	bigint(20)	否
SUM_SELECT_SCAN	bigint(20)	否
SUM_SORT_MERGE_PASSES	bigint(20)	否
SUM_SORT_RANGE	bigint(20)	否
SUM_SORT_ROWS	bigint(20)	否
SUM_SORT_SCAN	bigint(20)	否
SUM_NO_INDEX_USED	bigint(20)	否
SUM_NO_GOOD_INDEX_USED	bigint(20)	否

events_statements_summary_global_by_event_name

字段	类型	空
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
SUM_LOCK_TIME	bigint(20)	否
SUM_ERRORS	bigint(20)	否
SUM_WARNINGS	bigint(20)	否
SUM_ROWS_AFFECTED	bigint(20)	否
SUM_ROWS_SENT	bigint(20)	否
SUM_ROWS_EXAMINED	bigint(20)	否
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否
SUM_CREATED_TMP_TABLES	bigint(20)	否
SUM_SELECT_FULL_JOIN	bigint(20)	否
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否
SUM_SELECT_RANGE	bigint(20)	否
SUM_SELECT_RANGE_CHECK	bigint(20)	否
SUM_SELECT_SCAN	bigint(20)	否
SUM_SORT_MERGE_PASSES	bigint(20)	否
SUM_SORT_RANGE	bigint(20)	否
SUM_SORT_ROWS	bigint(20)	否
SUM_SORT_SCAN	bigint(20)	否
SUM_NO_INDEX_USED	bigint(20)	否
SUM_NO_GOOD_INDEX_USED	bigint(20)	否

events_waits_current

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
SPINS	int(10)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(512)	是	NULL
INDEX_NAME	varchar(64)	是	NULL
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	否
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL
OPERATION	varchar(32)	否
NUMBER_OF_BYTES	bigint(20)	是	NULL
FLAGS	int(10)	是	NULL

events_waits_history

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
SPINS	int(10)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(512)	是	NULL
INDEX_NAME	varchar(64)	是	NULL
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	否
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL
OPERATION	varchar(32)	否
NUMBER_OF_BYTES	bigint(20)	是	NULL
FLAGS	int(10)	是	NULL

events_waits_history_long

字段	类型	空	默认
THREAD_ID	bigint(20)	否
EVENT_ID	bigint(20)	否
END_EVENT_ID	bigint(20)	是	NULL
EVENT_NAME	varchar(128)	否
SOURCE	varchar(64)	是	NULL
TIMER_START	bigint(20)	是	NULL
TIMER_END	bigint(20)	是	NULL
TIMER_WAIT	bigint(20)	是	NULL
SPINS	int(10)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(512)	是	NULL
INDEX_NAME	varchar(64)	是	NULL
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	否
NESTING_EVENT_ID	bigint(20)	是	NULL
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL
OPERATION	varchar(32)	否
NUMBER_OF_BYTES	bigint(20)	是	NULL
FLAGS	int(10)	是	NULL

events_waits_summary_by_account_by_event_name

字段	类型	空	默认
USER	char(16)	是	NULL
HOST	char(60)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_waits_summary_by_host_by_event_name

字段	类型	空	默认
HOST	char(60)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_waits_summary_by_instance

字段	类型	空
EVENT_NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_waits_summary_by_thread_by_event_name

字段	类型	空
THREAD_ID	bigint(20)	否
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_waits_summary_by_user_by_event_name

字段	类型	空	默认
USER	char(16)	是	NULL
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

events_waits_summary_global_by_event_name

字段	类型	空
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

file_instances

字段	类型	空
FILE_NAME	varchar(512)	否
EVENT_NAME	varchar(128)	否
OPEN_COUNT	int(10)	否

file_summary_by_event_name

字段	类型	空
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
COUNT_READ	bigint(20)	否
SUM_TIMER_READ	bigint(20)	否
MIN_TIMER_READ	bigint(20)	否
AVG_TIMER_READ	bigint(20)	否
MAX_TIMER_READ	bigint(20)	否
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否
COUNT_WRITE	bigint(20)	否
SUM_TIMER_WRITE	bigint(20)	否
MIN_TIMER_WRITE	bigint(20)	否
AVG_TIMER_WRITE	bigint(20)	否
MAX_TIMER_WRITE	bigint(20)	否
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否
COUNT_MISC	bigint(20)	否
SUM_TIMER_MISC	bigint(20)	否
MIN_TIMER_MISC	bigint(20)	否
AVG_TIMER_MISC	bigint(20)	否
MAX_TIMER_MISC	bigint(20)	否

file_summary_by_instance

字段	类型	空
FILE_NAME	varchar(512)	否
EVENT_NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
COUNT_READ	bigint(20)	否
SUM_TIMER_READ	bigint(20)	否
MIN_TIMER_READ	bigint(20)	否
AVG_TIMER_READ	bigint(20)	否
MAX_TIMER_READ	bigint(20)	否
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否
COUNT_WRITE	bigint(20)	否
SUM_TIMER_WRITE	bigint(20)	否
MIN_TIMER_WRITE	bigint(20)	否
AVG_TIMER_WRITE	bigint(20)	否
MAX_TIMER_WRITE	bigint(20)	否
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否
COUNT_MISC	bigint(20)	否
SUM_TIMER_MISC	bigint(20)	否
MIN_TIMER_MISC	bigint(20)	否
AVG_TIMER_MISC	bigint(20)	否
MAX_TIMER_MISC	bigint(20)	否

hosts

字段	类型	空	默认
HOST	char(60)	是	NULL
CURRENT_CONNECTIONS	bigint(20)	否
TOTAL_CONNECTIONS	bigint(20)	否

host_cache

字段	类型	空	默认
IP	varchar(64)	否
HOST	varchar(255)	是	NULL
HOST_VALIDATED	enum('YES', 'NO')	否
SUM_CONNECT_ERRORS	bigint(20)	否
COUNT_HOST_BLOCKED_ERRORS	bigint(20)	否
COUNT_NAMEINFO_TRANSIENT_ERRORS	bigint(20)	否
COUNT_NAMEINFO_PERMANENT_ERRORS	bigint(20)	否
COUNT_FORMAT_ERRORS	bigint(20)	否
COUNT_ADDRINFO_TRANSIENT_ERRORS	bigint(20)	否
COUNT_ADDRINFO_PERMANENT_ERRORS	bigint(20)	否
COUNT_FCRDNS_ERRORS	bigint(20)	否
COUNT_HOST_ACL_ERRORS	bigint(20)	否
COUNT_NO_AUTH_PLUGIN_ERRORS	bigint(20)	否
COUNT_AUTH_PLUGIN_ERRORS	bigint(20)	否
COUNT_HANDSHAKE_ERRORS	bigint(20)	否
COUNT_PROXY_USER_ERRORS	bigint(20)	否
COUNT_PROXY_USER_ACL_ERRORS	bigint(20)	否
COUNT_AUTHENTICATION_ERRORS	bigint(20)	否
COUNT_SSL_ERRORS	bigint(20)	否
COUNT_MAX_USER_CONNECTIONS_ERRORS	bigint(20)	否
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	bigint(20)	否
COUNT_DEFAULT_DATABASE_ERRORS	bigint(20)	否
COUNT_INIT_CONNECT_ERRORS	bigint(20)	否
COUNT_LOCAL_ERRORS	bigint(20)	否
COUNT_UNKNOWN_ERRORS	bigint(20)	否
FIRST_SEEN	timestamp	否	0000-00-00 00:00:00
LAST_SEEN	timestamp	否	0000-00-00 00:00:00
FIRST_ERROR_SEEN	timestamp	是	0000-00-00 00:00:00
LAST_ERROR_SEEN	timestamp	是	0000-00-00 00:00:00

mutex_instances

字段	类型	空	默认
NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否
LOCKED_BY_THREAD_ID	bigint(20)	是	NULL

objects_summary_global_by_type

字段	类型	空	默认
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(64)	是	NULL
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否

performance_timers

字段	类型	空	默认
TIMER_NAME	enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')	否
TIMER_FREQUENCY	bigint(20)	是	NULL
TIMER_RESOLUTION	bigint(20)	是	NULL
TIMER_OVERHEAD	bigint(20)	是	NULL

rwlock_instances

字段	类型	空	默认
NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否
WRITE_LOCKED_BY_THREAD_ID	bigint(20)	是	NULL
READ_LOCKED_BY_COUNT	int(10)	否

session_account_connect_attrs

字段	类型	空	默认
PROCESSLIST_ID	int(11)	否
ATTR_NAME	varchar(32)	否
ATTR_VALUE	varchar(1024)	是	NULL
ORDINAL_POSITION	int(11)	是	NULL

session_connect_attrs

字段	类型	空	默认
PROCESSLIST_ID	int(11)	否
ATTR_NAME	varchar(32)	否
ATTR_VALUE	varchar(1024)	是	NULL
ORDINAL_POSITION	int(11)	是	NULL

setup_actors

字段	类型	空	默认
HOST	char(60)	否	%
USER	char(16)	否	%
ROLE	char(16)	否	%

setup_consumers

字段	类型	空	默认	链接到	注释	MIME
NAME	varchar(64)	否
ENABLED	enum('YES', 'NO')	否

setup_instruments

字段	类型	空
NAME	varchar(128)	否
ENABLED	enum('YES', 'NO')	否
TIMED	enum('YES', 'NO')	否

setup_objects

字段	类型	空	默认
OBJECT_TYPE	enum('TABLE')	否	TABLE
OBJECT_SCHEMA	varchar(64)	是	%
OBJECT_NAME	varchar(64)	否	%
ENABLED	enum('YES', 'NO')	否	YES
TIMED	enum('YES', 'NO')	否	YES

setup_timers

字段	类型	空	默认	链接到	注释	MIME
NAME	varchar(64)	否
TIMER_NAME	enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')	否

socket_instances

字段	类型	空	默认
EVENT_NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否
THREAD_ID	bigint(20)	是	NULL
SOCKET_ID	int(11)	否
IP	varchar(64)	否
PORT	int(11)	否
STATE	enum('IDLE', 'ACTIVE')	否

socket_summary_by_event_name

字段	类型	空
EVENT_NAME	varchar(128)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
COUNT_READ	bigint(20)	否
SUM_TIMER_READ	bigint(20)	否
MIN_TIMER_READ	bigint(20)	否
AVG_TIMER_READ	bigint(20)	否
MAX_TIMER_READ	bigint(20)	否
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否
COUNT_WRITE	bigint(20)	否
SUM_TIMER_WRITE	bigint(20)	否
MIN_TIMER_WRITE	bigint(20)	否
AVG_TIMER_WRITE	bigint(20)	否
MAX_TIMER_WRITE	bigint(20)	否
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否
COUNT_MISC	bigint(20)	否
SUM_TIMER_MISC	bigint(20)	否
MIN_TIMER_MISC	bigint(20)	否
AVG_TIMER_MISC	bigint(20)	否
MAX_TIMER_MISC	bigint(20)	否

socket_summary_by_instance

字段	类型	空
EVENT_NAME	varchar(128)	否
OBJECT_INSTANCE_BEGIN	bigint(20)	否
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
COUNT_READ	bigint(20)	否
SUM_TIMER_READ	bigint(20)	否
MIN_TIMER_READ	bigint(20)	否
AVG_TIMER_READ	bigint(20)	否
MAX_TIMER_READ	bigint(20)	否
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否
COUNT_WRITE	bigint(20)	否
SUM_TIMER_WRITE	bigint(20)	否
MIN_TIMER_WRITE	bigint(20)	否
AVG_TIMER_WRITE	bigint(20)	否
MAX_TIMER_WRITE	bigint(20)	否
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否
COUNT_MISC	bigint(20)	否
SUM_TIMER_MISC	bigint(20)	否
MIN_TIMER_MISC	bigint(20)	否
AVG_TIMER_MISC	bigint(20)	否
MAX_TIMER_MISC	bigint(20)	否

table_io_waits_summary_by_index_usage

字段	类型	空	默认
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(64)	是	NULL
INDEX_NAME	varchar(64)	是	NULL
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
COUNT_READ	bigint(20)	否
SUM_TIMER_READ	bigint(20)	否
MIN_TIMER_READ	bigint(20)	否
AVG_TIMER_READ	bigint(20)	否
MAX_TIMER_READ	bigint(20)	否
COUNT_WRITE	bigint(20)	否
SUM_TIMER_WRITE	bigint(20)	否
MIN_TIMER_WRITE	bigint(20)	否
AVG_TIMER_WRITE	bigint(20)	否
MAX_TIMER_WRITE	bigint(20)	否
COUNT_FETCH	bigint(20)	否
SUM_TIMER_FETCH	bigint(20)	否
MIN_TIMER_FETCH	bigint(20)	否
AVG_TIMER_FETCH	bigint(20)	否
MAX_TIMER_FETCH	bigint(20)	否
COUNT_INSERT	bigint(20)	否
SUM_TIMER_INSERT	bigint(20)	否
MIN_TIMER_INSERT	bigint(20)	否
AVG_TIMER_INSERT	bigint(20)	否
MAX_TIMER_INSERT	bigint(20)	否
COUNT_UPDATE	bigint(20)	否
SUM_TIMER_UPDATE	bigint(20)	否
MIN_TIMER_UPDATE	bigint(20)	否
AVG_TIMER_UPDATE	bigint(20)	否
MAX_TIMER_UPDATE	bigint(20)	否
COUNT_DELETE	bigint(20)	否
SUM_TIMER_DELETE	bigint(20)	否
MIN_TIMER_DELETE	bigint(20)	否
AVG_TIMER_DELETE	bigint(20)	否
MAX_TIMER_DELETE	bigint(20)	否

table_io_waits_summary_by_table

字段	类型	空	默认
OBJECT_TYPE	varchar(64)	是	NULL
OBJECT_SCHEMA	varchar(64)	是	NULL
OBJECT_NAME	varchar(64)	是	NULL
COUNT_STAR	bigint(20)	否
SUM_TIMER_WAIT	bigint(20)	否
MIN_TIMER_WAIT	bigint(20)	否
AVG_TIMER_WAIT	bigint(20)	否
MAX_TIMER_WAIT	bigint(20)	否
COUNT_READ	bigint(20)	否
SUM_TIMER_READ	bigint(20)	否
MIN_TIMER_READ	bigint(20)	否
AVG_TIMER_READ	bigint(20)	否
MAX_TIMER_READ	bigint(20)	否
COUNT_WRITE	bigint(20)	否
SUM_TIMER_WRITE	bigint(20)	否
MIN_TIMER_WRITE	bigint(20)	否
AVG_TIMER_WRITE	bigint(20)	否
MAX_TIMER_WRITE	bigint(20)	否
COUNT_FETCH	bigint(20)	否
SUM_TIMER_FETCH	bigint(20)	否
MIN_TIMER_FETCH	bigint(20)	否
AVG_TIMER_FETCH	bigint(20)	否
MAX_TIMER_FETCH	bigint(20)	否
COUNT_INSERT	bigint(20)	否
SUM_TIMER_INSERT	bigint(20)	否
MIN_TIMER_INSERT	bigint(20)	否
AVG_TIMER_INSERT	bigint(20)	否
MAX_TIMER_INSERT	bigint(20)	否
COUNT_UPDATE	bigint(20)	否
SUM_TIMER_UPDATE	bigint(20)	否
MIN_TIMER_UPDATE	bigint(20)	否
AVG_TIMER_UPDATE	bigint(20)	否
MAX_TIMER_UPDATE	bigint(20)	否
COUNT_DELETE	bigint(20)	否
SUM_TIMER_DELETE	bigint(20)	否
MIN_TIMER_DELETE	bigint(20)	否
AVG_TIMER_DELETE	bigint(20)	否
MAX_TIMER_DELETE	bigint(20)	否

table_lock_waits_summary_by_table

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

threads

字段	类型	空	默认
THREAD_ID	bigint(20)	否
NAME	varchar(128)	否
TYPE	varchar(10)	否
PROCESSLIST_ID	bigint(20)	是	NULL
PROCESSLIST_USER	varchar(16)	是	NULL
PROCESSLIST_HOST	varchar(60)	是	NULL
PROCESSLIST_DB	varchar(64)	是	NULL
PROCESSLIST_COMMAND	varchar(16)	是	NULL
PROCESSLIST_TIME	bigint(20)	是	NULL
PROCESSLIST_STATE	varchar(64)	是	NULL
PROCESSLIST_INFO	longtext	是	NULL
PARENT_THREAD_ID	bigint(20)	是	NULL
ROLE	varchar(64)	是	NULL
INSTRUMENTED	enum('YES', 'NO')	否

users

字段	类型	空	默认
USER	char(16)	是	NULL
CURRENT_CONNECTIONS	bigint(20)	否
TOTAL_CONNECTIONS	bigint(20)	否