表收藏夹为空。

自定义导航面板。

导航面板

以树状显示数据库导航面板导航栏使用数据库选择器替代树形列表
与主面板链接高亮当前数据库或表链接到主面板。
显示徽标在导航面板中显示图示。
徽标链接地址导航面板中图示指向的链接地址。
徽标链接目标在主窗口（`main`）或新窗口（`new`）打开目标页面。
启用高亮高亮鼠标指针所在位置的服务器。
第一层节点的最大项数每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数设置达到多少个项（表、视图、程序和事件）时将显示筛选框。
最近使用的表最近使用的表的最大数量；设为 0 为禁用。
表收藏夹收藏表的最大数量；设为 0 为禁用。
导航面板宽度设置为0以折叠导航面板。

自定义导航树。

导航树

节点中最大项数每页导航树所能显示的最大项数。
分组树中的项将导航树中的项分组（根据上面数据库与数据表页面设置的分隔符分组）。
启用表导航条展开功能是否允许在导航栏中展开导航树。
在导航树显示表在导航树是否在数据库下显示数据表节点
在导航树显示视图在导航树中是否在数据库下显示视图节点
在导航树显示函数是否显示导航树中数据库下级功能
在导航树显示进程是否在导航树中显示数据库进程
在导航树显示事件在导航树中数据库下是否显示事件节点
展开单个数据库是否自动在导航树中展开单个数据库。

服务器显示选项。

服务器

显示服务器选择在导航面板顶部显示可选的服务器。
列表显示服务器直接显示服务器列表而不使用下拉框。

数据库显示选项。

数据库

设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符将数据库分为不同层级的字符串。

表显示选项。

表

快速访问图标的目标
第二快速访问图标的目标页面
表树分隔符将表分为不同层级的字符串。
表树最大深度

将文件拖动至此

SQL 上传 ( 0 ) x -

按 Ctrl+Enter 键执行查询

崩溃扩展显示跟踪隐藏跟踪用时

没有书签

标签: 目标数据库: 共享和谐书签

总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置，使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题

崩溃扩展重新查询编辑解析性能分析书签查询失败数据库 : 查询时间 :

performance_schema

accounts

字段	类型	空	默认	注释
USER	char(128)	是	NULL	The connection's client user name for the connection, or NULL if an internal thread.
HOST	char(60)	是	NULL	The connection client's host name, or NULL if an internal thread.
CURRENT_CONNECTIONS	bigint(20)	否		Current connections for the account.
TOTAL_CONNECTIONS	bigint(20)	否		Total connections for the account.

没有已定义的索引！

cond_instances

字段	类型	空	默认	链接到	注释	媒体类型
NAME	varchar(128)	否			Client user name for the connection, or NULL if an internal thread.
OBJECT_INSTANCE_BEGIN	bigint(20)	否			Address in memory of the instrumented condition.

没有已定义的索引！

events_stages_current

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
NESTING_EVENT_ID	bigint(20)	是	NULL	EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Nesting event type. Either statement, stage or wait.

没有已定义的索引！

events_stages_history

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
NESTING_EVENT_ID	bigint(20)	是	NULL	EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Nesting event type. Either statement, stage or wait.

没有已定义的索引！

events_stages_history_long

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
NESTING_EVENT_ID	bigint(20)	是	NULL	EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Nesting event type. Either statement, stage or wait.

没有已定义的索引！

events_stages_summary_by_account_by_event_name

字段	类型	空	默认	注释
USER	char(128)	是	NULL	User. Used together with HOST and EVENT_NAME for grouping events.
HOST	char(60)	是	NULL	Host. Used together with USER and EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER and HOST for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the timed summarized events.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the timed summarized events.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the timed summarized events.

没有已定义的索引！

events_stages_summary_by_host_by_event_name

字段	类型	空	默认	注释
HOST	char(60)	是	NULL	Host. Used together with EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with HOST for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the timed summarized events.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the timed summarized events.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the timed summarized events.

没有已定义的索引！

events_stages_summary_by_thread_by_event_name

字段	类型	空	注释
THREAD_ID	bigint(20)	否	Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAME	varchar(128)	否	Event name. Used together with THREAD_ID for grouping events.
COUNT_STAR	bigint(20)	否	Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the timed summarized events.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the timed summarized events.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the timed summarized events.

没有已定义的索引！

events_stages_summary_by_user_by_event_name

字段	类型	空	默认	注释
USER	char(128)	是	NULL	User. Used together with EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the timed summarized events.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the timed summarized events.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the timed summarized events.

没有已定义的索引！

events_stages_summary_global_by_event_name

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Event name.
COUNT_STAR	bigint(20)	否	Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the timed summarized events.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the timed summarized events.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the timed summarized events.

没有已定义的索引！

events_statements_current

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
LOCK_TIME	bigint(20)	否		Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
SQL_TEXT	longtext	是	NULL	The SQL statement, or NULL if the command is not associated with an SQL statement.
DIGEST	varchar(32)	是	NULL	Statement digest.
DIGEST_TEXT	longtext	是	NULL	Statement digest text.
CURRENT_SCHEMA	varchar(64)	是	NULL	Statement's default database for the statement, or NULL if there was none.
OBJECT_TYPE	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_SCHEMA	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_NAME	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	是	NULL	Address in memory of the statement object.
MYSQL_ERRNO	int(11)	是	NULL	Error code. See MariaDB Error Codes for a full list.
RETURNED_SQLSTATE	varchar(5)	是	NULL	The SQLSTATE value.
MESSAGE_TEXT	varchar(128)	是	NULL	Statement error message. See MariaDB Error Codes.
ERRORS	bigint(20)	否		0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
WARNINGS	bigint(20)	否		Number of warnings from the diagnostics area.
ROWS_AFFECTED	bigint(20)	否		Number of rows affected the statement affected.
ROWS_SENT	bigint(20)	否		Number of rows returned.
ROWS_EXAMINED	bigint(20)	否		Number of rows read during the statement's execution.
CREATED_TMP_DISK_TABLES	bigint(20)	否		Number of on-disk temp tables created by the statement.
CREATED_TMP_TABLES	bigint(20)	否		Number of temp tables created by the statement.
SELECT_FULL_JOIN	bigint(20)	否		Number of joins performed by the statement which did not use an index.
SELECT_FULL_RANGE_JOIN	bigint(20)	否		Number of joins performed by the statement which used a range search of the first table.
SELECT_RANGE	bigint(20)	否		Number of joins performed by the statement which used a range of the first table.
SELECT_RANGE_CHECK	bigint(20)	否		Number of joins without keys performed by the statement that check for key usage after each row.
SELECT_SCAN	bigint(20)	否		Number of joins performed by the statement which used a full scan of the first table.
SORT_MERGE_PASSES	bigint(20)	否		Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the sort_buffer_size.
SORT_RANGE	bigint(20)	否		Number of sorts performed by the statement which used a range.
SORT_ROWS	bigint(20)	否		Number of rows sorted by the statement.
SORT_SCAN	bigint(20)	否		Number of sorts performed by the statement which used a full table scan.
NO_INDEX_USED	bigint(20)	否		0 if the statement performed a table scan with an index, 1 if without an index.
NO_GOOD_INDEX_USED	bigint(20)	否		0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the EXPLAIN article.
NESTING_EVENT_ID	bigint(20)	是	NULL	Reserved, currently NULL.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Reserved, currently NULL.

没有已定义的索引！

events_statements_history

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
LOCK_TIME	bigint(20)	否		Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
SQL_TEXT	longtext	是	NULL	The SQL statement, or NULL if the command is not associated with an SQL statement.
DIGEST	varchar(32)	是	NULL	Statement digest.
DIGEST_TEXT	longtext	是	NULL	Statement digest text.
CURRENT_SCHEMA	varchar(64)	是	NULL	Statement's default database for the statement, or NULL if there was none.
OBJECT_TYPE	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_SCHEMA	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_NAME	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	是	NULL	Address in memory of the statement object.
MYSQL_ERRNO	int(11)	是	NULL	Error code. See MariaDB Error Codes for a full list.
RETURNED_SQLSTATE	varchar(5)	是	NULL	The SQLSTATE value.
MESSAGE_TEXT	varchar(128)	是	NULL	Statement error message. See MariaDB Error Codes.
ERRORS	bigint(20)	否		0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
WARNINGS	bigint(20)	否		Number of warnings from the diagnostics area.
ROWS_AFFECTED	bigint(20)	否		Number of rows affected the statement affected.
ROWS_SENT	bigint(20)	否		Number of rows returned.
ROWS_EXAMINED	bigint(20)	否		Number of rows read during the statement's execution.
CREATED_TMP_DISK_TABLES	bigint(20)	否		Number of on-disk temp tables created by the statement.
CREATED_TMP_TABLES	bigint(20)	否		Number of temp tables created by the statement.
SELECT_FULL_JOIN	bigint(20)	否		Number of joins performed by the statement which did not use an index.
SELECT_FULL_RANGE_JOIN	bigint(20)	否		Number of joins performed by the statement which used a range search of the first table.
SELECT_RANGE	bigint(20)	否		Number of joins performed by the statement which used a range of the first table.
SELECT_RANGE_CHECK	bigint(20)	否		Number of joins without keys performed by the statement that check for key usage after each row.
SELECT_SCAN	bigint(20)	否		Number of joins performed by the statement which used a full scan of the first table.
SORT_MERGE_PASSES	bigint(20)	否		Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the sort_buffer_size.
SORT_RANGE	bigint(20)	否		Number of sorts performed by the statement which used a range.
SORT_ROWS	bigint(20)	否		Number of rows sorted by the statement.
SORT_SCAN	bigint(20)	否		Number of sorts performed by the statement which used a full table scan.
NO_INDEX_USED	bigint(20)	否		0 if the statement performed a table scan with an index, 1 if without an index.
NO_GOOD_INDEX_USED	bigint(20)	否		0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the EXPLAIN article.
NESTING_EVENT_ID	bigint(20)	是	NULL	Reserved, currently NULL.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Reserved, currently NULL.

没有已定义的索引！

events_statements_history_long

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
LOCK_TIME	bigint(20)	否		Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
SQL_TEXT	longtext	是	NULL	The SQL statement, or NULL if the command is not associated with an SQL statement.
DIGEST	varchar(32)	是	NULL	Statement digest.
DIGEST_TEXT	longtext	是	NULL	Statement digest text.
CURRENT_SCHEMA	varchar(64)	是	NULL	Statement's default database for the statement, or NULL if there was none.
OBJECT_TYPE	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_SCHEMA	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_NAME	varchar(64)	是	NULL	Reserved, currently NULL
OBJECT_INSTANCE_BEGIN	bigint(20)	是	NULL	Address in memory of the statement object.
MYSQL_ERRNO	int(11)	是	NULL	Error code. See MariaDB Error Codes for a full list.
RETURNED_SQLSTATE	varchar(5)	是	NULL	The SQLSTATE value.
MESSAGE_TEXT	varchar(128)	是	NULL	Statement error message. See MariaDB Error Codes.
ERRORS	bigint(20)	否		0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
WARNINGS	bigint(20)	否		Number of warnings from the diagnostics area.
ROWS_AFFECTED	bigint(20)	否		Number of rows affected the statement affected.
ROWS_SENT	bigint(20)	否		Number of rows returned.
ROWS_EXAMINED	bigint(20)	否		Number of rows read during the statement's execution.
CREATED_TMP_DISK_TABLES	bigint(20)	否		Number of on-disk temp tables created by the statement.
CREATED_TMP_TABLES	bigint(20)	否		Number of temp tables created by the statement.
SELECT_FULL_JOIN	bigint(20)	否		Number of joins performed by the statement which did not use an index.
SELECT_FULL_RANGE_JOIN	bigint(20)	否		Number of joins performed by the statement which used a range search of the first table.
SELECT_RANGE	bigint(20)	否		Number of joins performed by the statement which used a range of the first table.
SELECT_RANGE_CHECK	bigint(20)	否		Number of joins without keys performed by the statement that check for key usage after each row.
SELECT_SCAN	bigint(20)	否		Number of joins performed by the statement which used a full scan of the first table.
SORT_MERGE_PASSES	bigint(20)	否		Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the sort_buffer_size.
SORT_RANGE	bigint(20)	否		Number of sorts performed by the statement which used a range.
SORT_ROWS	bigint(20)	否		Number of rows sorted by the statement.
SORT_SCAN	bigint(20)	否		Number of sorts performed by the statement which used a full table scan.
NO_INDEX_USED	bigint(20)	否		0 if the statement performed a table scan with an index, 1 if without an index.
NO_GOOD_INDEX_USED	bigint(20)	否		0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the EXPLAIN article.
NESTING_EVENT_ID	bigint(20)	是	NULL	Reserved, currently NULL.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Reserved, currently NULL.

没有已定义的索引！

events_statements_summary_by_account_by_event_name

字段	类型	空	默认	注释
USER	char(128)	是	NULL	User. Used together with HOST and EVENT_NAME for grouping events.
HOST	char(60)	是	NULL	Host. Used together with USER and EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER and HOST for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
SUM_LOCK_TIME	bigint(20)	否		Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS	bigint(20)	否		Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS	bigint(20)	否		Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED	bigint(20)	否		Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT	bigint(20)	否		Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED	bigint(20)	否		Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否		Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES	bigint(20)	否		Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN	bigint(20)	否		Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否		Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE	bigint(20)	否		Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK	bigint(20)	否		Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN	bigint(20)	否		Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES	bigint(20)	否		Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE	bigint(20)	否		Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS	bigint(20)	否		Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN	bigint(20)	否		Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED	bigint(20)	否		Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED	bigint(20)	否		Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.

没有已定义的索引！

events_statements_summary_by_digest

字段	类型	空	默认	注释
SCHEMA_NAME	varchar(64)	是	NULL	Database name. Records are summarised together with DIGEST.
DIGEST	varchar(32)	是	NULL	Performance Schema digest. Records are summarised together with SCHEMA NAME.
DIGEST_TEXT	longtext	是	NULL	The unhashed form of the digest.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
SUM_LOCK_TIME	bigint(20)	否		Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS	bigint(20)	否		Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS	bigint(20)	否		Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED	bigint(20)	否		Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT	bigint(20)	否		Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED	bigint(20)	否		Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否		Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES	bigint(20)	否		Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN	bigint(20)	否		Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否		Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE	bigint(20)	否		Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK	bigint(20)	否		Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN	bigint(20)	否		Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES	bigint(20)	否		Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE	bigint(20)	否		Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS	bigint(20)	否		Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN	bigint(20)	否		Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED	bigint(20)	否		Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED	bigint(20)	否		Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.
FIRST_SEEN	timestamp	否	0000-00-00 00:00:00	Time at which the digest was first seen.
LAST_SEEN	timestamp	否	0000-00-00 00:00:00	Time at which the digest was most recently seen.

没有已定义的索引！

events_statements_summary_by_host_by_event_name

字段	类型	空	默认	注释
HOST	char(60)	是	NULL	Host. Used together with EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with HOST for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
SUM_LOCK_TIME	bigint(20)	否		Sum of the LOCK_TIME column in the events_statements_currentd table.
SUM_ERRORS	bigint(20)	否		Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS	bigint(20)	否		Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED	bigint(20)	否		Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT	bigint(20)	否		Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED	bigint(20)	否		Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否		Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES	bigint(20)	否		Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN	bigint(20)	否		Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否		Sum of the SELECT_FULL_RANGE_JOINW column in the events_statements_current table.
SUM_SELECT_RANGE	bigint(20)	否		Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK	bigint(20)	否		Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN	bigint(20)	否		Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES	bigint(20)	否		Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE	bigint(20)	否		Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS	bigint(20)	否		Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN	bigint(20)	否		Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED	bigint(20)	否		Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED	bigint(20)	否		Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.

没有已定义的索引！

events_statements_summary_by_thread_by_event_name

字段	类型	空	注释
THREAD_ID	bigint(20)	否	Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAME	varchar(128)	否	Event name. Used together with THREAD_ID for grouping events.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.
SUM_LOCK_TIME	bigint(20)	否	Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS	bigint(20)	否	Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS	bigint(20)	否	Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED	bigint(20)	否	Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT	bigint(20)	否	Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED	bigint(20)	否	Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否	Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES	bigint(20)	否	Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN	bigint(20)	否	Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否	Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE	bigint(20)	否	Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK	bigint(20)	否	Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN	bigint(20)	否	Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES	bigint(20)	否	Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE	bigint(20)	否	Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS	bigint(20)	否	Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN	bigint(20)	否	Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED	bigint(20)	否	Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED	bigint(20)	否	Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.

没有已定义的索引！

events_statements_summary_by_user_by_event_name

字段	类型	空	默认	注释
USER	char(128)	是	NULL	User. Used together with EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
SUM_LOCK_TIME	bigint(20)	否		Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS	bigint(20)	否		Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS	bigint(20)	否		Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED	bigint(20)	否		Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT	bigint(20)	否		Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED	bigint(20)	否		Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否		Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES	bigint(20)	否		Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN	bigint(20)	否		Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否		Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE	bigint(20)	否		Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK	bigint(20)	否		Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN	bigint(20)	否		Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES	bigint(20)	否		Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE	bigint(20)	否		Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS	bigint(20)	否		Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN	bigint(20)	否		Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED	bigint(20)	否		Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED	bigint(20)	否		Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.

没有已定义的索引！

events_statements_summary_global_by_event_name

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Event name.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.
SUM_LOCK_TIME	bigint(20)	否	Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS	bigint(20)	否	Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS	bigint(20)	否	Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED	bigint(20)	否	Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT	bigint(20)	否	Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED	bigint(20)	否	Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES	bigint(20)	否	Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES	bigint(20)	否	Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN	bigint(20)	否	Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN	bigint(20)	否	Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE	bigint(20)	否	Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK	bigint(20)	否	Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN	bigint(20)	否	Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES	bigint(20)	否	Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE	bigint(20)	否	Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS	bigint(20)	否	Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN	bigint(20)	否	Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED	bigint(20)	否	Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED	bigint(20)	否	Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.

没有已定义的索引！

events_waits_current

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
SPINS	int(10)	是	NULL	Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
OBJECT_SCHEMA	varchar(64)	是	NULL	Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
OBJECT_NAME	varchar(512)	是	NULL	File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
INDEX_NAME	varchar(64)	是	NULL	Name of the index, PRIMARY for the primary key, or NULL for no index used.
OBJECT_TYPE	varchar(64)	是	NULL	FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
OBJECT_INSTANCE_BEGIN	bigint(20)	否		Address in memory of the object.
NESTING_EVENT_ID	bigint(20)	是	NULL	EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Nesting event type. Either statement, stage or wait.
OPERATION	varchar(32)	否		Operation type, for example read, write or lock
NUMBER_OF_BYTES	bigint(20)	是	NULL	Number of bytes that the operation read or wrote, or NULL for table I/O waits.
FLAGS	int(10)	是	NULL	Reserved for use in the future.

没有已定义的索引！

events_waits_history

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
SPINS	int(10)	是	NULL	Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
OBJECT_SCHEMA	varchar(64)	是	NULL	Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
OBJECT_NAME	varchar(512)	是	NULL	File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
INDEX_NAME	varchar(64)	是	NULL	Name of the index, PRIMARY for the primary key, or NULL for no index used.
OBJECT_TYPE	varchar(64)	是	NULL	FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
OBJECT_INSTANCE_BEGIN	bigint(20)	否		Address in memory of the object.
NESTING_EVENT_ID	bigint(20)	是	NULL	EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Nesting event type. Either statement, stage or wait.
OPERATION	varchar(32)	否		Operation type, for example read, write or lock
NUMBER_OF_BYTES	bigint(20)	是	NULL	Number of bytes that the operation read or wrote, or NULL for table I/O waits.
FLAGS	int(10)	是	NULL	Reserved for use in the future.

没有已定义的索引！

events_waits_history_long

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID	bigint(20)	否		Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID	bigint(20)	是	NULL	NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME	varchar(128)	否		Event instrument name and a NAME from the setup_instruments table
SOURCE	varchar(64)	是	NULL	Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START	bigint(20)	是	NULL	Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END	bigint(20)	是	NULL	Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT	bigint(20)	是	NULL	Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
SPINS	int(10)	是	NULL	Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
OBJECT_SCHEMA	varchar(64)	是	NULL	Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
OBJECT_NAME	varchar(512)	是	NULL	File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
INDEX_NAME	varchar(64)	是	NULL	Name of the index, PRIMARY for the primary key, or NULL for no index used.
OBJECT_TYPE	varchar(64)	是	NULL	FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
OBJECT_INSTANCE_BEGIN	bigint(20)	否		Address in memory of the object.
NESTING_EVENT_ID	bigint(20)	是	NULL	EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE	enum('STATEMENT', 'STAGE', 'WAIT')	是	NULL	Nesting event type. Either statement, stage or wait.
OPERATION	varchar(32)	否		Operation type, for example read, write or lock
NUMBER_OF_BYTES	bigint(20)	是	NULL	Number of bytes that the operation read or wrote, or NULL for table I/O waits.
FLAGS	int(10)	是	NULL	Reserved for use in the future.

没有已定义的索引！

events_waits_summary_by_account_by_event_name

字段	类型	空	默认	注释
USER	char(128)	是	NULL	User. Used together with HOST and EVENT_NAME for grouping events.
HOST	char(60)	是	NULL	Host. Used together with USER and EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER and HOST for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.

没有已定义的索引！

events_waits_summary_by_host_by_event_name

字段	类型	空	默认	注释
HOST	char(60)	是	NULL	Host. Used together with EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER and HOST for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.

没有已定义的索引！

events_waits_summary_by_instance

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Event name. Used together with OBJECT_INSTANCE_BEGIN for grouping events.
OBJECT_INSTANCE_BEGIN	bigint(20)	否	If an instrument creates multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value to allow for grouping by instance.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.

没有已定义的索引！

events_waits_summary_by_thread_by_event_name

字段	类型	空	注释
THREAD_ID	bigint(20)	否	Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAME	varchar(128)	否	Event name. Used together with THREAD_ID for grouping events.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.

没有已定义的索引！

events_waits_summary_by_user_by_event_name

字段	类型	空	默认	注释
USER	char(128)	是	NULL	User. Used together with EVENT_NAME for grouping events.
EVENT_NAME	varchar(128)	否		Event name. Used together with USER for grouping events.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.

没有已定义的索引！

events_waits_summary_global_by_event_name

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Event name.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.

没有已定义的索引！

file_instances

字段	类型	空	注释
FILE_NAME	varchar(512)	否	File name.
EVENT_NAME	varchar(128)	否	Instrument name associated with the file.
OPEN_COUNT	int(10)	否	Open handles on the file. A value of greater than zero means that the file is currently open.

没有已定义的索引！

file_summary_by_event_name

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Event name.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否	Number of all read operations, including FGETS, FGETC, FREAD, and READ.
SUM_TIMER_READ	bigint(20)	否	Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否	Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否	Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否	Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否	Bytes read by read operations.
COUNT_WRITE	bigint(20)	否	Number of all write operations, including FPUTS, FPUTC, FPRINTF, VFPRINTF, FWRITE, and PWRITE.
SUM_TIMER_WRITE	bigint(20)	否	Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否	Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否	Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否	Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否	Bytes written by write operations.
COUNT_MISC	bigint(20)	否	Number of all miscellaneous operations not counted above, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
SUM_TIMER_MISC	bigint(20)	否	Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC	bigint(20)	否	Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC	bigint(20)	否	Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC	bigint(20)	否	Maximum wait time of all miscellaneous operations that are timed.

没有已定义的索引！

file_summary_by_instance

字段	类型	空	注释
FILE_NAME	varchar(512)	否	File name.
EVENT_NAME	varchar(128)	否	Event name.
OBJECT_INSTANCE_BEGIN	bigint(20)	否	Address in memory. Together with FILE_NAME and EVENT_NAME uniquely identifies a row.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否	Number of all read operations, including FGETS, FGETC, FREAD, and READ.
SUM_TIMER_READ	bigint(20)	否	Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否	Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否	Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否	Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否	Bytes read by read operations.
COUNT_WRITE	bigint(20)	否	Number of all write operations, including FPUTS, FPUTC, FPRINTF, VFPRINTF, FWRITE, and PWRITE.
SUM_TIMER_WRITE	bigint(20)	否	Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否	Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否	Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否	Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否	Bytes written by write operations.
COUNT_MISC	bigint(20)	否	Number of all miscellaneous operations not counted above, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
SUM_TIMER_MISC	bigint(20)	否	Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC	bigint(20)	否	Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC	bigint(20)	否	Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC	bigint(20)	否	Maximum wait time of all miscellaneous operations that are timed.

没有已定义的索引！

hosts

字段	类型	空	默认	注释
HOST	char(60)	是	NULL	Host name used by the client to connect, NULL for internal threads or user sessions that failed to authenticate.
CURRENT_CONNECTIONS	bigint(20)	否		Current number of the host's connections.
TOTAL_CONNECTIONS	bigint(20)	否		Total number of the host's connections

没有已定义的索引！

host_cache

字段	类型	空	默认	注释
IP	varchar(64)	否		Client IP address.
HOST	varchar(255)	是	NULL	IP's resolved DNS host name, or NULL if unknown.
HOST_VALIDATED	enum('YES', 'NO')	否		YES if the IP-to-host DNS lookup was successful, and the HOST column can be used to avoid DNS calls, or NO if unsuccessful, in which case DNS lookup is performed for each connect until either successful or a permanent error.
SUM_CONNECT_ERRORS	bigint(20)	否		Number of connection errors. Counts only protocol handshake errors for hosts that passed validation. These errors count towards max_connect_errors.
COUNT_HOST_BLOCKED_ERRORS	bigint(20)	否		Number of blocked connections because SUM_CONNECT_ERRORS exceeded the max_connect_errors system variable.
COUNT_NAMEINFO_TRANSIENT_ERRORS	bigint(20)	否		Number of transient errors during IP-to-host DNS lookups.
COUNT_NAMEINFO_PERMANENT_ERRORS	bigint(20)	否		Number of permanent errors during IP-to-host DNS lookups.
COUNT_FORMAT_ERRORS	bigint(20)	否		Number of host name format errors, for example a numeric host column.
COUNT_ADDRINFO_TRANSIENT_ERRORS	bigint(20)	否		Number of transient errors during host-to-IP reverse DNS lookups.
COUNT_ADDRINFO_PERMANENT_ERRORS	bigint(20)	否		Number of permanent errors during host-to-IP reverse DNS lookups.
COUNT_FCRDNS_ERRORS	bigint(20)	否		Number of forward-confirmed reverse DNS errors, which occur when IP-to-host DNS lookup does not match the originating IP address.
COUNT_HOST_ACL_ERRORS	bigint(20)	否		Number of errors occurring because no user from the host is permitted to log in. These attempts return error code 1130 ER_HOST_NOT_PRIVILEGED and do not proceed to username and password authentication.
COUNT_NO_AUTH_PLUGIN_ERRORS	bigint(20)	否		Number of errors due to requesting an authentication plugin that was not available. This can be due to the plugin never having been loaded, or the load attempt failing.
COUNT_AUTH_PLUGIN_ERRORS	bigint(20)	否		Number of errors reported by an authentication plugin. Plugins can increment COUNT_AUTHENTICATION_ERRORS or COUNT_HANDSHAKE_ERRORS instead, but, if specified or the error is unknown, this column is incremented.
COUNT_HANDSHAKE_ERRORS	bigint(20)	否		Number of errors detected at the wire protocol level.
COUNT_PROXY_USER_ERRORS	bigint(20)	否		Number of errors detected when a proxy user is proxied to a user that does not exist.
COUNT_PROXY_USER_ACL_ERRORS	bigint(20)	否		Number of errors detected when a proxy user is proxied to a user that exists, but the proxy user doesn't have the PROXY privilege.
COUNT_AUTHENTICATION_ERRORS	bigint(20)	否		Number of errors where authentication failed.
COUNT_SSL_ERRORS	bigint(20)	否		Number of errors due to TLS problems.
COUNT_MAX_USER_CONNECTIONS_ERRORS	bigint(20)	否		Number of errors due to the per-user quota being exceeded.
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	bigint(20)	否		Number of errors due to the per-hour quota being exceeded.
COUNT_DEFAULT_DATABASE_ERRORS	bigint(20)	否		Number of errors due to the user not having permission to access the specified default database, or it not existing.
COUNT_INIT_CONNECT_ERRORS	bigint(20)	否		Number of errors due to statements in the init_connect system variable.
COUNT_LOCAL_ERRORS	bigint(20)	否		Number of local server errors, such as out-of-memory errors, unrelated to network, authentication, or authorization.
COUNT_UNKNOWN_ERRORS	bigint(20)	否		Number of unknown errors that cannot be allocated to another column.
FIRST_SEEN	timestamp	否	0000-00-00 00:00:00	Timestamp of the first connection attempt by the IP.
LAST_SEEN	timestamp	否	0000-00-00 00:00:00	Timestamp of the most recent connection attempt by the IP.
FIRST_ERROR_SEEN	timestamp	是	0000-00-00 00:00:00	Timestamp of the first error seen from the IP.
LAST_ERROR_SEEN	timestamp	是	0000-00-00 00:00:00	Timestamp of the most recent error seen from the IP.

没有已定义的索引！

mutex_instances

字段	类型	空	默认	注释
NAME	varchar(128)	否		Instrument name associated with the mutex.
OBJECT_INSTANCE_BEGIN	bigint(20)	否		Memory address of the instrumented mutex.
LOCKED_BY_THREAD_ID	bigint(20)	是	NULL	The THREAD_ID of the locking thread if a thread has a mutex locked, otherwise NULL.

没有已定义的索引！

objects_summary_global_by_type

字段	类型	空	默认	注释
OBJECT_TYPE	varchar(64)	是	NULL	Groups records together with OBJECT_SCHEMA and OBJECT_NAME.
OBJECT_SCHEMA	varchar(64)	是	NULL	Groups records together with OBJECT_TYPE and OBJECT_NAME.
OBJECT_NAME	varchar(64)	是	NULL	Groups records together with OBJECT_SCHEMA and OBJECT_TYPE.
COUNT_STAR	bigint(20)	否		Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.

没有已定义的索引！

performance_timers

字段	类型	空	默认	注释
TIMER_NAME	enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')	否		Time name, used in the setup_timers table.
TIMER_FREQUENCY	bigint(20)	是	NULL	Number of timer units per second. Dependent on the processor speed.
TIMER_RESOLUTION	bigint(20)	是	NULL	Number of timer units by which timed values increase each time.
TIMER_OVERHEAD	bigint(20)	是	NULL	Minimum timer overhead, determined during initialization by calling the timer 20 times and selecting the smallest value. Total overhead will be at least double this, as the timer is called at the beginning and end of each timed event.

没有已定义的索引！

rwlock_instances

字段	类型	空	默认	注释
NAME	varchar(128)	否		Instrument name associated with the read write lock
OBJECT_INSTANCE_BEGIN	bigint(20)	否		Address in memory of the instrumented lock
WRITE_LOCKED_BY_THREAD_ID	bigint(20)	是	NULL	THREAD_ID of the locking thread if locked in write (exclusive) mode, otherwise NULL.
READ_LOCKED_BY_COUNT	int(10)	否		Count of current read locks held

没有已定义的索引！

session_account_connect_attrs

字段	类型	空	默认	注释
PROCESSLIST_ID	int(11)	否		Session connection identifier.
ATTR_NAME	varchar(32)	否		Attribute name.
ATTR_VALUE	varchar(1024)	是	NULL	Attribute value.
ORDINAL_POSITION	int(11)	是	NULL	Order in which attribute was added to the connection attributes.

没有已定义的索引！

session_connect_attrs

字段	类型	空	默认	注释
PROCESSLIST_ID	int(11)	否		Session connection identifier.
ATTR_NAME	varchar(32)	否		Attribute name.
ATTR_VALUE	varchar(1024)	是	NULL	Attribute value.
ORDINAL_POSITION	int(11)	是	NULL	Order in which attribute was added to the connection attributes.

没有已定义的索引！

setup_actors

字段	类型	空	默认	注释
HOST	char(60)	否	%	Host name, either a literal, or the % wildcard representing any host.
USER	char(128)	否	%	User name, either a literal or the % wildcard representing any name.
ROLE	char(128)	否	%	Unused

没有已定义的索引！

setup_consumers

字段	类型	空	默认	链接到	注释	媒体类型
NAME	varchar(64)	否			Consumer name
ENABLED	enum('YES', 'NO')	否			YES or NO for whether or not the consumer is enabled. You can modify this column to ensure that event information is added, or is not added.

没有已定义的索引！

setup_instruments

字段	类型	空	注释
NAME	varchar(128)	否	Instrument name
ENABLED	enum('YES', 'NO')	否	Whether or not the instrument is enabled. It can be disabled, and the instrument will produce no events.
TIMED	enum('YES', 'NO')	否	Whether or not the instrument is timed. It can be set, but if disabled, events produced by the instrument will have NULL values for the corresponding TIMER_START, TIMER_END, and TIMER_WAIT values.

没有已定义的索引！

setup_objects

字段	类型	空	默认	注释
OBJECT_TYPE	enum('TABLE')	否	TABLE	Type of object to instrument. Currently, only TABLE, for base table.
OBJECT_SCHEMA	varchar(64)	是	%	Schema containing the object, either the literal or % for any schema.
OBJECT_NAME	varchar(64)	否	%	Name of the instrumented object, either the literal or % for any object.
ENABLED	enum('YES', 'NO')	否	YES	Whether the object's events are instrumented or not. Can be disabled, in which case monitoring is not enabled for those objects.
TIMED	enum('YES', 'NO')	否	YES	Whether the object's events are timed or not. Can be modified.

没有已定义的索引！

setup_timers

字段	类型	空	默认	链接到	注释	媒体类型
NAME	varchar(64)	否			Type of instrument the timer is used for.
TIMER_NAME	enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')	否			Timer applying to the instrument type. Can be modified.

没有已定义的索引！

socket_instances

字段	类型	空	默认	注释
EVENT_NAME	varchar(128)	否		NAME from the setup_instruments table, and the name of the wait/io/socket/* instrument that produced the event.
OBJECT_INSTANCE_BEGIN	bigint(20)	否		Memory address of the object.
THREAD_ID	bigint(20)	是	NULL	Thread identifier that the server assigns to each socket.
SOCKET_ID	int(11)	否		The socket's internal file handle.
IP	varchar(64)	否		Client IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection.
PORT	int(11)	否		TCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.
STATE	enum('IDLE', 'ACTIVE')	否		Socket status, either IDLE if waiting to receive a request from a client, or ACTIVE

没有已定义的索引！

socket_summary_by_event_name

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Socket instrument.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否	Number of all read operations, including RECV, RECVFROM, and RECVMSG.
SUM_TIMER_READ	bigint(20)	否	Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否	Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否	Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否	Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否	Bytes read by read operations.
COUNT_WRITE	bigint(20)	否	Number of all write operations, including SEND, SENDTO, and SENDMSG.
SUM_TIMER_WRITE	bigint(20)	否	Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否	Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否	Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否	Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否	Bytes written by write operations.
COUNT_MISC	bigint(20)	否	Number of all miscellaneous operations not counted above, including CONNECT, LISTEN, ACCEPT, CLOSE, and SHUTDOWN.
SUM_TIMER_MISC	bigint(20)	否	Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC	bigint(20)	否	Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC	bigint(20)	否	Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC	bigint(20)	否	Maximum wait time of all miscellaneous operations that are timed.

没有已定义的索引！

socket_summary_by_instance

字段	类型	空	注释
EVENT_NAME	varchar(128)	否	Socket instrument.
OBJECT_INSTANCE_BEGIN	bigint(20)	否	Address in memory.
COUNT_STAR	bigint(20)	否	Number of summarized events
SUM_TIMER_WAIT	bigint(20)	否	Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否	Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否	Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否	Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否	Number of all read operations, including RECV, RECVFROM, and RECVMSG.
SUM_TIMER_READ	bigint(20)	否	Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否	Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否	Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否	Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ	bigint(20)	否	Bytes read by read operations.
COUNT_WRITE	bigint(20)	否	Number of all write operations, including SEND, SENDTO, and SENDMSG.
SUM_TIMER_WRITE	bigint(20)	否	Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否	Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否	Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否	Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE	bigint(20)	否	Bytes written by write operations.
COUNT_MISC	bigint(20)	否	Number of all miscellaneous operations not counted above, including CONNECT, LISTEN, ACCEPT, CLOSE, and SHUTDOWN.
SUM_TIMER_MISC	bigint(20)	否	Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC	bigint(20)	否	Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC	bigint(20)	否	Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC	bigint(20)	否	Maximum wait time of all miscellaneous operations that are timed.

没有已定义的索引！

table_io_waits_summary_by_index_usage

字段	类型	空	默认	注释
OBJECT_TYPE	varchar(64)	是	NULL	TABLE in the case of all indexes.
OBJECT_SCHEMA	varchar(64)	是	NULL	Schema name.
OBJECT_NAME	varchar(64)	是	NULL	Table name.
INDEX_NAME	varchar(64)	是	NULL	Index name, or PRIMARY for the primary index, NULL for no index (inserts are counted in this case).
COUNT_STAR	bigint(20)	否		Number of summarized events and the sum of the x_READ and x_WRITE columns.
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否		Number of all read operations, and the sum of the equivalent x_FETCH columns.
SUM_TIMER_READ	bigint(20)	否		Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否		Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否		Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否		Maximum wait time of all read operations that are timed.
COUNT_WRITE	bigint(20)	否		Number of all write operations, and the sum of the equivalent x_INSERT, x_UPDATE and x_DELETE columns.
SUM_TIMER_WRITE	bigint(20)	否		Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否		Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否		Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否		Maximum wait time of all write operations that are timed.
COUNT_FETCH	bigint(20)	否		Number of all fetch operations.
SUM_TIMER_FETCH	bigint(20)	否		Total wait time of all fetch operations that are timed.
MIN_TIMER_FETCH	bigint(20)	否		Minimum wait time of all fetch operations that are timed.
AVG_TIMER_FETCH	bigint(20)	否		Average wait time of all fetch operations that are timed.
MAX_TIMER_FETCH	bigint(20)	否		Maximum wait time of all fetch operations that are timed.
COUNT_INSERT	bigint(20)	否		Number of all insert operations.
SUM_TIMER_INSERT	bigint(20)	否		Total wait time of all insert operations that are timed.
MIN_TIMER_INSERT	bigint(20)	否		Minimum wait time of all insert operations that are timed.
AVG_TIMER_INSERT	bigint(20)	否		Average wait time of all insert operations that are timed.
MAX_TIMER_INSERT	bigint(20)	否		Maximum wait time of all insert operations that are timed.
COUNT_UPDATE	bigint(20)	否		Number of all update operations.
SUM_TIMER_UPDATE	bigint(20)	否		Total wait time of all update operations that are timed.
MIN_TIMER_UPDATE	bigint(20)	否		Minimum wait time of all update operations that are timed.
AVG_TIMER_UPDATE	bigint(20)	否		Average wait time of all update operations that are timed.
MAX_TIMER_UPDATE	bigint(20)	否		Maximum wait time of all update operations that are timed.
COUNT_DELETE	bigint(20)	否		Number of all delete operations.
SUM_TIMER_DELETE	bigint(20)	否		Total wait time of all delete operations that are timed.
MIN_TIMER_DELETE	bigint(20)	否		Minimum wait time of all delete operations that are timed.
AVG_TIMER_DELETE	bigint(20)	否		Average wait time of all delete operations that are timed.
MAX_TIMER_DELETE	bigint(20)	否		Maximum wait time of all delete operations that are timed.

没有已定义的索引！

table_io_waits_summary_by_table

字段	类型	空	默认	注释
OBJECT_TYPE	varchar(64)	是	NULL	Since this table records waits by table, always set to TABLE.
OBJECT_SCHEMA	varchar(64)	是	NULL	Schema name.
OBJECT_NAME	varchar(64)	是	NULL	Table name.
COUNT_STAR	bigint(20)	否		Number of summarized events and the sum of the x_READ and x_WRITE columns.
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否		Number of all read operations, and the sum of the equivalent x_FETCH columns.
SUM_TIMER_READ	bigint(20)	否		Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否		Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否		Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否		Maximum wait time of all read operations that are timed.
COUNT_WRITE	bigint(20)	否		Number of all write operations, and the sum of the equivalent x_INSERT, x_UPDATE and x_DELETE columns.
SUM_TIMER_WRITE	bigint(20)	否		Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否		Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否		Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否		Maximum wait time of all write operations that are timed.
COUNT_FETCH	bigint(20)	否		Number of all fetch operations.
SUM_TIMER_FETCH	bigint(20)	否		Total wait time of all fetch operations that are timed.
MIN_TIMER_FETCH	bigint(20)	否		Minimum wait time of all fetch operations that are timed.
AVG_TIMER_FETCH	bigint(20)	否		Average wait time of all fetch operations that are timed.
MAX_TIMER_FETCH	bigint(20)	否		Maximum wait time of all fetch operations that are timed.
COUNT_INSERT	bigint(20)	否		Number of all insert operations.
SUM_TIMER_INSERT	bigint(20)	否		Total wait time of all insert operations that are timed.
MIN_TIMER_INSERT	bigint(20)	否		Minimum wait time of all insert operations that are timed.
AVG_TIMER_INSERT	bigint(20)	否		Average wait time of all insert operations that are timed.
MAX_TIMER_INSERT	bigint(20)	否		Maximum wait time of all insert operations that are timed.
COUNT_UPDATE	bigint(20)	否		Number of all update operations.
SUM_TIMER_UPDATE	bigint(20)	否		Total wait time of all update operations that are timed.
MIN_TIMER_UPDATE	bigint(20)	否		Minimum wait time of all update operations that are timed.
AVG_TIMER_UPDATE	bigint(20)	否		Average wait time of all update operations that are timed.
MAX_TIMER_UPDATE	bigint(20)	否		Maximum wait time of all update operations that are timed.
COUNT_DELETE	bigint(20)	否		Number of all delete operations.
SUM_TIMER_DELETE	bigint(20)	否		Total wait time of all delete operations that are timed.
MIN_TIMER_DELETE	bigint(20)	否		Minimum wait time of all delete operations that are timed.
AVG_TIMER_DELETE	bigint(20)	否		Average wait time of all delete operations that are timed.
MAX_TIMER_DELETE	bigint(20)	否		Maximum wait time of all delete operations that are timed.

没有已定义的索引！

table_lock_waits_summary_by_table

字段	类型	空	默认	注释
OBJECT_TYPE	varchar(64)	是	NULL	Since this table records waits by table, always set to TABLE.
OBJECT_SCHEMA	varchar(64)	是	NULL	Schema name.
OBJECT_NAME	varchar(64)	是	NULL	Table name.
COUNT_STAR	bigint(20)	否		Number of summarized events and the sum of the x_READ and x_WRITE columns.
SUM_TIMER_WAIT	bigint(20)	否		Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT	bigint(20)	否		Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT	bigint(20)	否		Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT	bigint(20)	否		Maximum wait time of the summarized events that are timed.
COUNT_READ	bigint(20)	否		Number of all read operations, and the sum of the equivalent x_READ_NORMAL, x_READ_WITH_SHARED_LOCKS, x_READ_HIGH_PRIORITY and x_READ_NO_INSERT columns.
SUM_TIMER_READ	bigint(20)	否		Total wait time of all read operations that are timed.
MIN_TIMER_READ	bigint(20)	否		Minimum wait time of all read operations that are timed.
AVG_TIMER_READ	bigint(20)	否		Average wait time of all read operations that are timed.
MAX_TIMER_READ	bigint(20)	否		Maximum wait time of all read operations that are timed.
COUNT_WRITE	bigint(20)	否		Number of all write operations, and the sum of the equivalent x_WRITE_ALLOW_WRITE, x_WRITE_CONCURRENT_INSERT, x_WRITE_DELAYED, x_WRITE_LOW_PRIORITY and x_WRITE_NORMAL columns.
SUM_TIMER_WRITE	bigint(20)	否		Total wait time of all write operations that are timed.
MIN_TIMER_WRITE	bigint(20)	否		Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE	bigint(20)	否		Average wait time of all write operations that are timed.
MAX_TIMER_WRITE	bigint(20)	否		Maximum wait time of all write operations that are timed.
COUNT_READ_NORMAL	bigint(20)	否		Number of all internal read normal locks.
SUM_TIMER_READ_NORMAL	bigint(20)	否		Total wait time of all internal read normal locks that are timed.
MIN_TIMER_READ_NORMAL	bigint(20)	否		Minimum wait time of all internal read normal locks that are timed.
AVG_TIMER_READ_NORMAL	bigint(20)	否		Average wait time of all internal read normal locks that are timed.
MAX_TIMER_READ_NORMAL	bigint(20)	否		Maximum wait time of all internal read normal locks that are timed.
COUNT_READ_WITH_SHARED_LOCKS	bigint(20)	否		Number of all internal read with shared locks.
SUM_TIMER_READ_WITH_SHARED_LOCKS	bigint(20)	否		Total wait time of all internal read with shared locks that are timed.
MIN_TIMER_READ_WITH_SHARED_LOCKS	bigint(20)	否		Minimum wait time of all internal read with shared locks that are timed.
AVG_TIMER_READ_WITH_SHARED_LOCKS	bigint(20)	否		Average wait time of all internal read with shared locks that are timed.
MAX_TIMER_READ_WITH_SHARED_LOCKS	bigint(20)	否		Maximum wait time of all internal read with shared locks that are timed.
COUNT_READ_HIGH_PRIORITY	bigint(20)	否		Number of all internal read high priority locks.
SUM_TIMER_READ_HIGH_PRIORITY	bigint(20)	否		Total wait time of all internal read high priority locks that are timed.
MIN_TIMER_READ_HIGH_PRIORITY	bigint(20)	否		Minimum wait time of all internal read high priority locks that are timed.
AVG_TIMER_READ_HIGH_PRIORITY	bigint(20)	否		Average wait time of all internal read high priority locks that are timed.
MAX_TIMER_READ_HIGH_PRIORITY	bigint(20)	否		Maximum wait time of all internal read high priority locks that are timed.
COUNT_READ_NO_INSERT	bigint(20)	否		Number of all internal read no insert locks.
SUM_TIMER_READ_NO_INSERT	bigint(20)	否		Total wait time of all internal read no insert locks that are timed.
MIN_TIMER_READ_NO_INSERT	bigint(20)	否		Minimum wait time of all internal read no insert locks that are timed.
AVG_TIMER_READ_NO_INSERT	bigint(20)	否		Average wait time of all internal read no insert locks that are timed.
MAX_TIMER_READ_NO_INSERT	bigint(20)	否		Maximum wait time of all internal read no insert locks that are timed.
COUNT_READ_EXTERNAL	bigint(20)	否		Number of all external read locks.
SUM_TIMER_READ_EXTERNAL	bigint(20)	否		Total wait time of all external read locks that are timed.
MIN_TIMER_READ_EXTERNAL	bigint(20)	否		Minimum wait time of all external read locks that are timed.
AVG_TIMER_READ_EXTERNAL	bigint(20)	否		Average wait time of all external read locks that are timed.
MAX_TIMER_READ_EXTERNAL	bigint(20)	否		Maximum wait time of all external read locks that are timed.
COUNT_WRITE_ALLOW_WRITE	bigint(20)	否		Number of all internal read normal locks.
SUM_TIMER_WRITE_ALLOW_WRITE	bigint(20)	否		Total wait time of all internal write allow write locks that are timed.
MIN_TIMER_WRITE_ALLOW_WRITE	bigint(20)	否		Minimum wait time of all internal write allow write locks that are timed.
AVG_TIMER_WRITE_ALLOW_WRITE	bigint(20)	否		Average wait time of all internal write allow write locks that are timed.
MAX_TIMER_WRITE_ALLOW_WRITE	bigint(20)	否		Maximum wait time of all internal write allow write locks that are timed.
COUNT_WRITE_CONCURRENT_INSERT	bigint(20)	否		Number of all internal concurrent insert write locks.
SUM_TIMER_WRITE_CONCURRENT_INSERT	bigint(20)	否		Total wait time of all internal concurrent insert write locks that are timed.
MIN_TIMER_WRITE_CONCURRENT_INSERT	bigint(20)	否		Minimum wait time of all internal concurrent insert write locks that are timed.
AVG_TIMER_WRITE_CONCURRENT_INSERT	bigint(20)	否		Average wait time of all internal concurrent insert write locks that are timed.
MAX_TIMER_WRITE_CONCURRENT_INSERT	bigint(20)	否		Maximum wait time of all internal concurrent insert write locks that are timed.
COUNT_WRITE_DELAYED	bigint(20)	否		Number of all internal write delayed locks.
SUM_TIMER_WRITE_DELAYED	bigint(20)	否		Total wait time of all internal write delayed locks that are timed.
MIN_TIMER_WRITE_DELAYED	bigint(20)	否		Minimum wait time of all internal write delayed locks that are timed.
AVG_TIMER_WRITE_DELAYED	bigint(20)	否		Average wait time of all internal write delayed locks that are timed.
MAX_TIMER_WRITE_DELAYED	bigint(20)	否		Maximum wait time of all internal write delayed locks that are timed.
COUNT_WRITE_LOW_PRIORITY	bigint(20)	否		Number of all internal write low priority locks.
SUM_TIMER_WRITE_LOW_PRIORITY	bigint(20)	否		Total wait time of all internal write low priority locks that are timed.
MIN_TIMER_WRITE_LOW_PRIORITY	bigint(20)	否		Minimum wait time of all internal write low priority locks that are timed.
AVG_TIMER_WRITE_LOW_PRIORITY	bigint(20)	否		Average wait time of all internal write low priority locks that are timed.
MAX_TIMER_WRITE_LOW_PRIORITY	bigint(20)	否		Maximum wait time of all internal write low priority locks that are timed.
COUNT_WRITE_NORMAL	bigint(20)	否		Number of all internal write normal locks.
SUM_TIMER_WRITE_NORMAL	bigint(20)	否		Total wait time of all internal write normal locks that are timed.
MIN_TIMER_WRITE_NORMAL	bigint(20)	否		Minimum wait time of all internal write normal locks that are timed.
AVG_TIMER_WRITE_NORMAL	bigint(20)	否		Average wait time of all internal write normal locks that are timed.
MAX_TIMER_WRITE_NORMAL	bigint(20)	否		Maximum wait time of all internal write normal locks that are timed.
COUNT_WRITE_EXTERNAL	bigint(20)	否		Number of all external write locks.
SUM_TIMER_WRITE_EXTERNAL	bigint(20)	否		Total wait time of all external write locks that are timed.
MIN_TIMER_WRITE_EXTERNAL	bigint(20)	否		Minimum wait time of all external write locks that are timed.
AVG_TIMER_WRITE_EXTERNAL	bigint(20)	否		Average wait time of all external write locks that are timed.
MAX_TIMER_WRITE_EXTERNAL	bigint(20)	否		Maximum wait time of all external write locks that are timed.

没有已定义的索引！

threads

字段	类型	空	默认	注释
THREAD_ID	bigint(20)	否		A unique thread identifier.
NAME	varchar(128)	否		Name associated with the server's thread instrumentation code, for example thread/sql/main for the server's main() function, and thread/sql/one_connection for a user connection.
TYPE	varchar(10)	否		FOREGROUND or BACKGROUND, depending on the thread type. User connection threads are FOREGROUND, internal server threads are BACKGROUND.
PROCESSLIST_ID	bigint(20)	是	NULL	The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
PROCESSLIST_USER	varchar(128)	是	NULL	Foreground thread user, or NULL for a background thread.
PROCESSLIST_HOST	varchar(60)	是	NULL	Foreground thread host, or NULL for a background thread.
PROCESSLIST_DB	varchar(64)	是	NULL	Thread's default database, or NULL if none exists.
PROCESSLIST_COMMAND	varchar(16)	是	NULL	Type of command executed by the thread. These correspond to the the COM_xxx client/server protocol commands, and the Com_xxx status variables. See Thread Command Values.
PROCESSLIST_TIME	bigint(20)	是	NULL	Time in seconds the thread has been in its current state.
PROCESSLIST_STATE	varchar(64)	是	NULL	Action, event or state indicating what the thread is doing.
PROCESSLIST_INFO	longtext	是	NULL	Statement being executed by the thread, or NULL if a statement is not being executed. If a statement results in calling other statements, such as for a stored procedure, the innermost statement from the stored procedure is shown here.
PARENT_THREAD_ID	bigint(20)	是	NULL	THREAD_ID of the parent thread, if any. Subthreads can for example be spawned as a result of INSERT DELAYED statements.
ROLE	varchar(64)	是	NULL	Unused.
INSTRUMENTED	enum('YES', 'NO')	否		YES or NO for Whether the thread is instrumented or not. For foreground threads, the initial value is determined by whether there's a user/host match in the setup_actors table. Subthreads are again matched, while for background threads, this will be set to YES by default. To monitor events that the thread executes, INSTRUMENTED must be YES and the thread_instrumentation consumer in the setup_consumers table must also be YES.

没有已定义的索引！

users

字段	类型	空	默认	注释
USER	char(128)	是	NULL	The connection's client user name for the connection, or NULL if an internal thread.
CURRENT_CONNECTIONS	bigint(20)	否		Current connections for the user.
TOTAL_CONNECTIONS	bigint(20)	否		Total connections for the user.

没有已定义的索引！