字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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_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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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_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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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 |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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 |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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 |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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 |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!
字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体类型 |
---|---|---|---|---|---|---|
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. |
没有已定义的索引!