Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
CURRENT_CONNECTIONS | bigint(20) | No | ||
TOTAL_CONNECTIONS | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
NAME | HASH | No | No | NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ENGINE (Primary) | varchar(32) | No | ||
ENGINE_LOCK_ID (Primary) | varchar(128) | No | ||
ENGINE_TRANSACTION_ID | bigint(20) | Yes | NULL | |
THREAD_ID | bigint(20) | Yes | NULL | |
EVENT_ID | bigint(20) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
PARTITION_NAME | varchar(64) | Yes | NULL | |
SUBPARTITION_NAME | varchar(64) | Yes | NULL | |
INDEX_NAME | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | No | ||
LOCK_TYPE | varchar(32) | No | ||
LOCK_MODE | varchar(32) | No | ||
LOCK_STATUS | varchar(32) | No | ||
LOCK_DATA | varchar(8192) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | ENGINE_LOCK_ID | No | |||
ENGINE | No | |||||||
ENGINE_TRANSACTION_ID | HASH | No | No | ENGINE_TRANSACTION_ID | Yes | |||
ENGINE | No | |||||||
THREAD_ID | HASH | No | No | THREAD_ID | Yes | |||
EVENT_ID | Yes | |||||||
OBJECT_SCHEMA | HASH | No | No | OBJECT_SCHEMA | Yes | |||
OBJECT_NAME | Yes | |||||||
PARTITION_NAME | Yes | |||||||
SUBPARTITION_NAME | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ENGINE | varchar(32) | No | ||
REQUESTING_ENGINE_LOCK_ID | varchar(128) | No | ||
REQUESTING_ENGINE_TRANSACTION_ID | bigint(20) | Yes | NULL | |
REQUESTING_THREAD_ID | bigint(20) | Yes | NULL | |
REQUESTING_EVENT_ID | bigint(20) | Yes | NULL | |
REQUESTING_OBJECT_INSTANCE_BEGIN | bigint(20) | No | ||
BLOCKING_ENGINE_LOCK_ID | varchar(128) | No | ||
BLOCKING_ENGINE_TRANSACTION_ID | bigint(20) | Yes | NULL | |
BLOCKING_THREAD_ID | bigint(20) | Yes | NULL | |
BLOCKING_EVENT_ID | bigint(20) | Yes | NULL | |
BLOCKING_OBJECT_INSTANCE_BEGIN | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
REQUESTING_ENGINE_LOCK_ID | HASH | No | No | REQUESTING_ENGINE_LOCK_ID | No | |||
ENGINE | No | |||||||
BLOCKING_ENGINE_LOCK_ID | HASH | No | No | BLOCKING_ENGINE_LOCK_ID | No | |||
ENGINE | No | |||||||
REQUESTING_ENGINE_TRANSACTION_ID | HASH | No | No | REQUESTING_ENGINE_TRANSACTION_ID | Yes | |||
ENGINE | No | |||||||
BLOCKING_ENGINE_TRANSACTION_ID | HASH | No | No | BLOCKING_ENGINE_TRANSACTION_ID | Yes | |||
ENGINE | No | |||||||
REQUESTING_THREAD_ID | HASH | No | No | REQUESTING_THREAD_ID | Yes | |||
REQUESTING_EVENT_ID | Yes | |||||||
BLOCKING_THREAD_ID | HASH | No | No | BLOCKING_THREAD_ID | Yes | |||
BLOCKING_EVENT_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
ERROR_NUMBER | int(11) | Yes | NULL | |
ERROR_NAME | varchar(64) | Yes | NULL | |
SQL_STATE | varchar(5) | Yes | NULL | |
SUM_ERROR_RAISED | bigint(20) | No | ||
SUM_ERROR_HANDLED | bigint(20) | No | ||
FIRST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 | |
LAST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
ERROR_NUMBER | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
ERROR_NUMBER | int(11) | Yes | NULL | |
ERROR_NAME | varchar(64) | Yes | NULL | |
SQL_STATE | varchar(5) | Yes | NULL | |
SUM_ERROR_RAISED | bigint(20) | No | ||
SUM_ERROR_HANDLED | bigint(20) | No | ||
FIRST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 | |
LAST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
ERROR_NUMBER | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID | bigint(20) | No | ||
ERROR_NUMBER | int(11) | Yes | NULL | |
ERROR_NAME | varchar(64) | Yes | NULL | |
SQL_STATE | varchar(5) | Yes | NULL | |
SUM_ERROR_RAISED | bigint(20) | No | ||
SUM_ERROR_HANDLED | bigint(20) | No | ||
FIRST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 | |
LAST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
THREAD_ID | HASH | Yes | No | THREAD_ID | No | |||
ERROR_NUMBER | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
ERROR_NUMBER | int(11) | Yes | NULL | |
ERROR_NAME | varchar(64) | Yes | NULL | |
SQL_STATE | varchar(5) | Yes | NULL | |
SUM_ERROR_RAISED | bigint(20) | No | ||
SUM_ERROR_HANDLED | bigint(20) | No | ||
FIRST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 | |
LAST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
ERROR_NUMBER | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ERROR_NUMBER | int(11) | Yes | NULL | |
ERROR_NAME | varchar(64) | Yes | NULL | |
SQL_STATE | varchar(5) | Yes | NULL | |
SUM_ERROR_RAISED | bigint(20) | No | ||
SUM_ERROR_HANDLED | bigint(20) | No | ||
FIRST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 | |
LAST_SEEN | timestamp | Yes | 0000-00-00 00:00:00 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ERROR_NUMBER | HASH | Yes | No | ERROR_NUMBER | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
WORK_COMPLETED | bigint(20) | Yes | NULL | |
WORK_ESTIMATED | bigint(20) | Yes | NULL | |
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
WORK_COMPLETED | bigint(20) | Yes | NULL | |
WORK_ESTIMATED | bigint(20) | Yes | NULL | |
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID | bigint(20) | No | ||
EVENT_ID | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
WORK_COMPLETED | bigint(20) | Yes | NULL | |
WORK_ESTIMATED | bigint(20) | Yes | NULL | |
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
LOCK_TIME | bigint(20) | No | ||
SQL_TEXT | longtext | Yes | NULL | |
DIGEST | varchar(64) | Yes | NULL | |
DIGEST_TEXT | longtext | Yes | NULL | |
CURRENT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
MYSQL_ERRNO | int(11) | Yes | NULL | |
RETURNED_SQLSTATE | varchar(5) | Yes | NULL | |
MESSAGE_TEXT | varchar(128) | Yes | NULL | |
ERRORS | bigint(20) | No | ||
WARNINGS | bigint(20) | No | ||
ROWS_AFFECTED | bigint(20) | No | ||
ROWS_SENT | bigint(20) | No | ||
ROWS_EXAMINED | bigint(20) | No | ||
CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
CREATED_TMP_TABLES | bigint(20) | No | ||
SELECT_FULL_JOIN | bigint(20) | No | ||
SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SELECT_RANGE | bigint(20) | No | ||
SELECT_RANGE_CHECK | bigint(20) | No | ||
SELECT_SCAN | bigint(20) | No | ||
SORT_MERGE_PASSES | bigint(20) | No | ||
SORT_RANGE | bigint(20) | No | ||
SORT_ROWS | bigint(20) | No | ||
SORT_SCAN | bigint(20) | No | ||
NO_INDEX_USED | bigint(20) | No | ||
NO_GOOD_INDEX_USED | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL | |
NESTING_EVENT_LEVEL | int(11) | Yes | NULL | |
STATEMENT_ID | bigint(20) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SCHEMA_NAME | varchar(64) | Yes | NULL | |
DIGEST | varchar(64) | Yes | NULL | |
BUCKET_NUMBER | int(10) | No | ||
BUCKET_TIMER_LOW | bigint(20) | No | ||
BUCKET_TIMER_HIGH | bigint(20) | No | ||
COUNT_BUCKET | bigint(20) | No | ||
COUNT_BUCKET_AND_LOWER | bigint(20) | No | ||
BUCKET_QUANTILE | double(7,6) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
SCHEMA_NAME | HASH | Yes | No | SCHEMA_NAME | Yes | |||
DIGEST | Yes | |||||||
BUCKET_NUMBER | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
BUCKET_NUMBER (Primary) | int(10) | No | ||
BUCKET_TIMER_LOW | bigint(20) | No | ||
BUCKET_TIMER_HIGH | bigint(20) | No | ||
COUNT_BUCKET | bigint(20) | No | ||
COUNT_BUCKET_AND_LOWER | bigint(20) | No | ||
BUCKET_QUANTILE | double(7,6) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | BUCKET_NUMBER | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
LOCK_TIME | bigint(20) | No | ||
SQL_TEXT | longtext | Yes | NULL | |
DIGEST | varchar(64) | Yes | NULL | |
DIGEST_TEXT | longtext | Yes | NULL | |
CURRENT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
MYSQL_ERRNO | int(11) | Yes | NULL | |
RETURNED_SQLSTATE | varchar(5) | Yes | NULL | |
MESSAGE_TEXT | varchar(128) | Yes | NULL | |
ERRORS | bigint(20) | No | ||
WARNINGS | bigint(20) | No | ||
ROWS_AFFECTED | bigint(20) | No | ||
ROWS_SENT | bigint(20) | No | ||
ROWS_EXAMINED | bigint(20) | No | ||
CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
CREATED_TMP_TABLES | bigint(20) | No | ||
SELECT_FULL_JOIN | bigint(20) | No | ||
SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SELECT_RANGE | bigint(20) | No | ||
SELECT_RANGE_CHECK | bigint(20) | No | ||
SELECT_SCAN | bigint(20) | No | ||
SORT_MERGE_PASSES | bigint(20) | No | ||
SORT_RANGE | bigint(20) | No | ||
SORT_ROWS | bigint(20) | No | ||
SORT_SCAN | bigint(20) | No | ||
NO_INDEX_USED | bigint(20) | No | ||
NO_GOOD_INDEX_USED | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL | |
NESTING_EVENT_LEVEL | int(11) | Yes | NULL | |
STATEMENT_ID | bigint(20) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID | bigint(20) | No | ||
EVENT_ID | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
LOCK_TIME | bigint(20) | No | ||
SQL_TEXT | longtext | Yes | NULL | |
DIGEST | varchar(64) | Yes | NULL | |
DIGEST_TEXT | longtext | Yes | NULL | |
CURRENT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
MYSQL_ERRNO | int(11) | Yes | NULL | |
RETURNED_SQLSTATE | varchar(5) | Yes | NULL | |
MESSAGE_TEXT | varchar(128) | Yes | NULL | |
ERRORS | bigint(20) | No | ||
WARNINGS | bigint(20) | No | ||
ROWS_AFFECTED | bigint(20) | No | ||
ROWS_SENT | bigint(20) | No | ||
ROWS_EXAMINED | bigint(20) | No | ||
CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
CREATED_TMP_TABLES | bigint(20) | No | ||
SELECT_FULL_JOIN | bigint(20) | No | ||
SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SELECT_RANGE | bigint(20) | No | ||
SELECT_RANGE_CHECK | bigint(20) | No | ||
SELECT_SCAN | bigint(20) | No | ||
SORT_MERGE_PASSES | bigint(20) | No | ||
SORT_RANGE | bigint(20) | No | ||
SORT_ROWS | bigint(20) | No | ||
SORT_SCAN | bigint(20) | No | ||
NO_INDEX_USED | bigint(20) | No | ||
NO_GOOD_INDEX_USED | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL | |
NESTING_EVENT_LEVEL | int(11) | Yes | NULL | |
STATEMENT_ID | bigint(20) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SCHEMA_NAME | varchar(64) | Yes | NULL | |
DIGEST | varchar(64) | Yes | NULL | |
DIGEST_TEXT | longtext | Yes | NULL | |
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No | ||
FIRST_SEEN | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |
LAST_SEEN | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |
QUANTILE_95 | bigint(20) | No | ||
QUANTILE_99 | bigint(20) | No | ||
QUANTILE_999 | bigint(20) | No | ||
QUERY_SAMPLE_TEXT | longtext | Yes | NULL | |
QUERY_SAMPLE_SEEN | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |
QUERY_SAMPLE_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
SCHEMA_NAME | HASH | Yes | No | SCHEMA_NAME | Yes | |||
DIGEST | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE (Primary) | enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') | No | ||
OBJECT_SCHEMA (Primary) | varchar(64) | No | ||
OBJECT_NAME (Primary) | varchar(64) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_STATEMENTS | bigint(20) | No | ||
SUM_STATEMENTS_WAIT | bigint(20) | No | ||
MIN_STATEMENTS_WAIT | bigint(20) | No | ||
AVG_STATEMENTS_WAIT | bigint(20) | No | ||
MAX_STATEMENTS_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_TYPE | No | |||
OBJECT_SCHEMA | No | |||||||
OBJECT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
STATE | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |
TRX_ID | bigint(20) | Yes | NULL | |
GTID | varchar(64) | Yes | NULL | |
XID_FORMAT_ID | int(11) | Yes | NULL | |
XID_GTRID | varchar(130) | Yes | NULL | |
XID_BQUAL | varchar(130) | Yes | NULL | |
XA_STATE | varchar(64) | Yes | NULL | |
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
ACCESS_MODE | enum('READ ONLY', 'READ WRITE') | Yes | NULL | |
ISOLATION_LEVEL | varchar(64) | Yes | NULL | |
AUTOCOMMIT | enum('YES', 'NO') | No | ||
NUMBER_OF_SAVEPOINTS | bigint(20) | Yes | NULL | |
NUMBER_OF_ROLLBACK_TO_SAVEPOINT | bigint(20) | Yes | NULL | |
NUMBER_OF_RELEASE_SAVEPOINT | bigint(20) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
STATE | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |
TRX_ID | bigint(20) | Yes | NULL | |
GTID | varchar(64) | Yes | NULL | |
XID_FORMAT_ID | int(11) | Yes | NULL | |
XID_GTRID | varchar(130) | Yes | NULL | |
XID_BQUAL | varchar(130) | Yes | NULL | |
XA_STATE | varchar(64) | Yes | NULL | |
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
ACCESS_MODE | enum('READ ONLY', 'READ WRITE') | Yes | NULL | |
ISOLATION_LEVEL | varchar(64) | Yes | NULL | |
AUTOCOMMIT | enum('YES', 'NO') | No | ||
NUMBER_OF_SAVEPOINTS | bigint(20) | Yes | NULL | |
NUMBER_OF_ROLLBACK_TO_SAVEPOINT | bigint(20) | Yes | NULL | |
NUMBER_OF_RELEASE_SAVEPOINT | bigint(20) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID | bigint(20) | No | ||
EVENT_ID | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
STATE | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |
TRX_ID | bigint(20) | Yes | NULL | |
GTID | varchar(64) | Yes | NULL | |
XID_FORMAT_ID | int(11) | Yes | NULL | |
XID_GTRID | varchar(130) | Yes | NULL | |
XID_BQUAL | varchar(130) | Yes | NULL | |
XA_STATE | varchar(64) | Yes | NULL | |
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
ACCESS_MODE | enum('READ ONLY', 'READ WRITE') | Yes | NULL | |
ISOLATION_LEVEL | varchar(64) | Yes | NULL | |
AUTOCOMMIT | enum('YES', 'NO') | No | ||
NUMBER_OF_SAVEPOINTS | bigint(20) | Yes | NULL | |
NUMBER_OF_ROLLBACK_TO_SAVEPOINT | bigint(20) | Yes | NULL | |
NUMBER_OF_RELEASE_SAVEPOINT | bigint(20) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ_WRITE | bigint(20) | No | ||
SUM_TIMER_READ_WRITE | bigint(20) | No | ||
MIN_TIMER_READ_WRITE | bigint(20) | No | ||
AVG_TIMER_READ_WRITE | bigint(20) | No | ||
MAX_TIMER_READ_WRITE | bigint(20) | No | ||
COUNT_READ_ONLY | bigint(20) | No | ||
SUM_TIMER_READ_ONLY | bigint(20) | No | ||
MIN_TIMER_READ_ONLY | bigint(20) | No | ||
AVG_TIMER_READ_ONLY | bigint(20) | No | ||
MAX_TIMER_READ_ONLY | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ_WRITE | bigint(20) | No | ||
SUM_TIMER_READ_WRITE | bigint(20) | No | ||
MIN_TIMER_READ_WRITE | bigint(20) | No | ||
AVG_TIMER_READ_WRITE | bigint(20) | No | ||
MAX_TIMER_READ_WRITE | bigint(20) | No | ||
COUNT_READ_ONLY | bigint(20) | No | ||
SUM_TIMER_READ_ONLY | bigint(20) | No | ||
MIN_TIMER_READ_ONLY | bigint(20) | No | ||
AVG_TIMER_READ_ONLY | bigint(20) | No | ||
MAX_TIMER_READ_ONLY | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ_WRITE | bigint(20) | No | ||
SUM_TIMER_READ_WRITE | bigint(20) | No | ||
MIN_TIMER_READ_WRITE | bigint(20) | No | ||
AVG_TIMER_READ_WRITE | bigint(20) | No | ||
MAX_TIMER_READ_WRITE | bigint(20) | No | ||
COUNT_READ_ONLY | bigint(20) | No | ||
SUM_TIMER_READ_ONLY | bigint(20) | No | ||
MIN_TIMER_READ_ONLY | bigint(20) | No | ||
AVG_TIMER_READ_ONLY | bigint(20) | No | ||
MAX_TIMER_READ_ONLY | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ_WRITE | bigint(20) | No | ||
SUM_TIMER_READ_WRITE | bigint(20) | No | ||
MIN_TIMER_READ_WRITE | bigint(20) | No | ||
AVG_TIMER_READ_WRITE | bigint(20) | No | ||
MAX_TIMER_READ_WRITE | bigint(20) | No | ||
COUNT_READ_ONLY | bigint(20) | No | ||
SUM_TIMER_READ_ONLY | bigint(20) | No | ||
MIN_TIMER_READ_ONLY | bigint(20) | No | ||
AVG_TIMER_READ_ONLY | bigint(20) | No | ||
MAX_TIMER_READ_ONLY | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ_WRITE | bigint(20) | No | ||
SUM_TIMER_READ_WRITE | bigint(20) | No | ||
MIN_TIMER_READ_WRITE | bigint(20) | No | ||
AVG_TIMER_READ_WRITE | bigint(20) | No | ||
MAX_TIMER_READ_WRITE | bigint(20) | No | ||
COUNT_READ_ONLY | bigint(20) | No | ||
SUM_TIMER_READ_ONLY | bigint(20) | No | ||
MIN_TIMER_READ_ONLY | bigint(20) | No | ||
AVG_TIMER_READ_ONLY | bigint(20) | No | ||
MAX_TIMER_READ_ONLY | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
SPINS | int(10) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(512) | Yes | NULL | |
INDEX_NAME | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL | |
OPERATION | varchar(32) | No | ||
NUMBER_OF_BYTES | bigint(20) | Yes | NULL | |
FLAGS | int(10) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_ID (Primary) | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
SPINS | int(10) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(512) | Yes | NULL | |
INDEX_NAME | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL | |
OPERATION | varchar(32) | No | ||
NUMBER_OF_BYTES | bigint(20) | Yes | NULL | |
FLAGS | int(10) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_ID | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID | bigint(20) | No | ||
EVENT_ID | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
SPINS | int(10) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(512) | Yes | NULL | |
INDEX_NAME | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') | Yes | NULL | |
OPERATION | varchar(32) | No | ||
NUMBER_OF_BYTES | bigint(20) | Yes | NULL | |
FLAGS | int(10) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
EVENT_NAME | HASH | No | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FILE_NAME (Primary) | varchar(512) | No | ||
EVENT_NAME | varchar(128) | No | ||
OPEN_COUNT | int(10) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | FILE_NAME | No | |||
EVENT_NAME | HASH | No | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_WRITE | bigint(20) | No | ||
COUNT_MISC | bigint(20) | No | ||
SUM_TIMER_MISC | bigint(20) | No | ||
MIN_TIMER_MISC | bigint(20) | No | ||
AVG_TIMER_MISC | bigint(20) | No | ||
MAX_TIMER_MISC | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FILE_NAME | varchar(512) | No | ||
EVENT_NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_WRITE | bigint(20) | No | ||
COUNT_MISC | bigint(20) | No | ||
SUM_TIMER_MISC | bigint(20) | No | ||
MIN_TIMER_MISC | bigint(20) | No | ||
AVG_TIMER_MISC | bigint(20) | No | ||
MAX_TIMER_MISC | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
FILE_NAME | HASH | No | No | FILE_NAME | No | |||
EVENT_NAME | HASH | No | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
CURRENT_CONNECTIONS | bigint(20) | No | ||
TOTAL_CONNECTIONS | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
IP (Primary) | varchar(64) | No | ||
HOST | varchar(255) | Yes | NULL | |
HOST_VALIDATED | enum('YES', 'NO') | No | ||
SUM_CONNECT_ERRORS | bigint(20) | No | ||
COUNT_HOST_BLOCKED_ERRORS | bigint(20) | No | ||
COUNT_NAMEINFO_TRANSIENT_ERRORS | bigint(20) | No | ||
COUNT_NAMEINFO_PERMANENT_ERRORS | bigint(20) | No | ||
COUNT_FORMAT_ERRORS | bigint(20) | No | ||
COUNT_ADDRINFO_TRANSIENT_ERRORS | bigint(20) | No | ||
COUNT_ADDRINFO_PERMANENT_ERRORS | bigint(20) | No | ||
COUNT_FCRDNS_ERRORS | bigint(20) | No | ||
COUNT_HOST_ACL_ERRORS | bigint(20) | No | ||
COUNT_NO_AUTH_PLUGIN_ERRORS | bigint(20) | No | ||
COUNT_AUTH_PLUGIN_ERRORS | bigint(20) | No | ||
COUNT_HANDSHAKE_ERRORS | bigint(20) | No | ||
COUNT_PROXY_USER_ERRORS | bigint(20) | No | ||
COUNT_PROXY_USER_ACL_ERRORS | bigint(20) | No | ||
COUNT_AUTHENTICATION_ERRORS | bigint(20) | No | ||
COUNT_SSL_ERRORS | bigint(20) | No | ||
COUNT_MAX_USER_CONNECTIONS_ERRORS | bigint(20) | No | ||
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS | bigint(20) | No | ||
COUNT_DEFAULT_DATABASE_ERRORS | bigint(20) | No | ||
COUNT_INIT_CONNECT_ERRORS | bigint(20) | No | ||
COUNT_LOCAL_ERRORS | bigint(20) | No | ||
COUNT_UNKNOWN_ERRORS | bigint(20) | No | ||
FIRST_SEEN | timestamp | No | 0000-00-00 00:00:00 | |
LAST_SEEN | timestamp | No | 0000-00-00 00:00:00 | |
FIRST_ERROR_SEEN | timestamp | Yes | 0000-00-00 00:00:00 | |
LAST_ERROR_SEEN | timestamp | Yes | 0000-00-00 00:00:00 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | IP | No | |||
HOST | HASH | No | No | HOST | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
KEY_ID | varchar(255) | No | ||
KEY_OWNER | varchar(255) | Yes | NULL | |
BACKEND_KEY_ID | varchar(255) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SERVER_UUID | char(36) | No | ||
LOCAL | json | No | ||
REPLICATION | json | No | ||
STORAGE_ENGINES | json | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_ALLOC | bigint(20) | No | ||
COUNT_FREE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_ALLOC | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_FREE | bigint(20) | No | ||
LOW_COUNT_USED | bigint(20) | No | ||
CURRENT_COUNT_USED | bigint(20) | No | ||
HIGH_COUNT_USED | bigint(20) | No | ||
LOW_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
CURRENT_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
HIGH_NUMBER_OF_BYTES_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_ALLOC | bigint(20) | No | ||
COUNT_FREE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_ALLOC | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_FREE | bigint(20) | No | ||
LOW_COUNT_USED | bigint(20) | No | ||
CURRENT_COUNT_USED | bigint(20) | No | ||
HIGH_COUNT_USED | bigint(20) | No | ||
LOW_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
CURRENT_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
HIGH_NUMBER_OF_BYTES_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_ALLOC | bigint(20) | No | ||
COUNT_FREE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_ALLOC | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_FREE | bigint(20) | No | ||
LOW_COUNT_USED | bigint(20) | No | ||
CURRENT_COUNT_USED | bigint(20) | No | ||
HIGH_COUNT_USED | bigint(20) | No | ||
LOW_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
CURRENT_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
HIGH_NUMBER_OF_BYTES_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
COUNT_ALLOC | bigint(20) | No | ||
COUNT_FREE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_ALLOC | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_FREE | bigint(20) | No | ||
LOW_COUNT_USED | bigint(20) | No | ||
CURRENT_COUNT_USED | bigint(20) | No | ||
HIGH_COUNT_USED | bigint(20) | No | ||
LOW_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
CURRENT_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
HIGH_NUMBER_OF_BYTES_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_ALLOC | bigint(20) | No | ||
COUNT_FREE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_ALLOC | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_FREE | bigint(20) | No | ||
LOW_COUNT_USED | bigint(20) | No | ||
CURRENT_COUNT_USED | bigint(20) | No | ||
HIGH_COUNT_USED | bigint(20) | No | ||
LOW_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
CURRENT_NUMBER_OF_BYTES_USED | bigint(20) | No | ||
HIGH_NUMBER_OF_BYTES_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | varchar(64) | No | ||
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
COLUMN_NAME | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
LOCK_TYPE | varchar(32) | No | ||
LOCK_DURATION | varchar(32) | No | ||
LOCK_STATUS | varchar(32) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
OWNER_THREAD_ID | bigint(20) | Yes | NULL | |
OWNER_EVENT_ID | bigint(20) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
OBJECT_TYPE | HASH | No | No | OBJECT_TYPE | No | |||
OBJECT_SCHEMA | Yes | |||||||
OBJECT_NAME | Yes | |||||||
COLUMN_NAME | Yes | |||||||
OWNER_THREAD_ID | HASH | No | No | OWNER_THREAD_ID | Yes | |||
OWNER_EVENT_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
LOCKED_BY_THREAD_ID | bigint(20) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
NAME | HASH | No | No | NAME | No | |||
LOCKED_BY_THREAD_ID | HASH | No | No | LOCKED_BY_THREAD_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
OBJECT | HASH | Yes | No | OBJECT_TYPE | Yes | |||
OBJECT_SCHEMA | Yes | |||||||
OBJECT_NAME | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TIMER_NAME | enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND') | No | ||
TIMER_FREQUENCY | bigint(20) | Yes | NULL | |
TIMER_RESOLUTION | bigint(20) | Yes | NULL | |
TIMER_OVERHEAD | bigint(20) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
STATEMENT_ID | bigint(20) | No | ||
STATEMENT_NAME | varchar(64) | Yes | NULL | |
SQL_TEXT | longtext | No | ||
OWNER_THREAD_ID | bigint(20) | No | ||
OWNER_EVENT_ID | bigint(20) | No | ||
OWNER_OBJECT_TYPE | enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') | Yes | NULL | |
OWNER_OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OWNER_OBJECT_NAME | varchar(64) | Yes | NULL | |
TIMER_PREPARE | bigint(20) | No | ||
COUNT_REPREPARE | bigint(20) | No | ||
COUNT_EXECUTE | bigint(20) | No | ||
SUM_TIMER_EXECUTE | bigint(20) | No | ||
MIN_TIMER_EXECUTE | bigint(20) | No | ||
AVG_TIMER_EXECUTE | bigint(20) | No | ||
MAX_TIMER_EXECUTE | bigint(20) | No | ||
SUM_LOCK_TIME | bigint(20) | No | ||
SUM_ERRORS | bigint(20) | No | ||
SUM_WARNINGS | bigint(20) | No | ||
SUM_ROWS_AFFECTED | bigint(20) | No | ||
SUM_ROWS_SENT | bigint(20) | No | ||
SUM_ROWS_EXAMINED | bigint(20) | No | ||
SUM_CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
SUM_CREATED_TMP_TABLES | bigint(20) | No | ||
SUM_SELECT_FULL_JOIN | bigint(20) | No | ||
SUM_SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SUM_SELECT_RANGE | bigint(20) | No | ||
SUM_SELECT_RANGE_CHECK | bigint(20) | No | ||
SUM_SELECT_SCAN | bigint(20) | No | ||
SUM_SORT_MERGE_PASSES | bigint(20) | No | ||
SUM_SORT_RANGE | bigint(20) | No | ||
SUM_SORT_ROWS | bigint(20) | No | ||
SUM_SORT_SCAN | bigint(20) | No | ||
SUM_NO_INDEX_USED | bigint(20) | No | ||
SUM_NO_GOOD_INDEX_USED | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
OWNER_THREAD_ID | HASH | Yes | No | OWNER_THREAD_ID | No | |||
OWNER_EVENT_ID | No | |||||||
STATEMENT_ID | HASH | No | No | STATEMENT_ID | No | |||
STATEMENT_NAME | HASH | No | No | STATEMENT_NAME | Yes | |||
OWNER_OBJECT_TYPE | HASH | No | No | OWNER_OBJECT_TYPE | Yes | |||
OWNER_OBJECT_SCHEMA | Yes | |||||||
OWNER_OBJECT_NAME | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME (Primary) | char(64) | No | ||
DESIRED_DELAY | int(11) | No | ||
PRIVILEGE_CHECKS_USER | text | Yes | NULL | User name for the security context of the applier. |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | CHANNEL_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME | char(64) | No | ||
FILTER_NAME | char(64) | No | ||
FILTER_RULE | longtext | No | ||
CONFIGURED_BY | enum('STARTUP_OPTIONS', 'CHANGE_REPLICATION_FILTER', 'STARTUP_OPTIONS_FOR_CHANNEL', 'CHANGE_REPLICATION_FILTER_FOR_CHANNEL') | No | ||
ACTIVE_SINCE | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |
COUNTER | bigint(20) | No | 0 |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FILTER_NAME | char(64) | No | ||
FILTER_RULE | longtext | No | ||
CONFIGURED_BY | enum('STARTUP_OPTIONS', 'CHANGE_REPLICATION_FILTER') | No | ||
ACTIVE_SINCE | timestamp(6) | No | 0000-00-00 00:00:00.000000 |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME (Primary) | char(64) | No | ||
SERVICE_STATE | enum('ON', 'OFF') | No | ||
REMAINING_DELAY | int(10) | Yes | NULL | |
COUNT_TRANSACTIONS_RETRIES | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | CHANNEL_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME (Primary) | char(64) | No | ||
THREAD_ID | bigint(20) | Yes | NULL | |
SERVICE_STATE | enum('ON', 'OFF') | No | ||
LAST_ERROR_NUMBER | int(11) | No | ||
LAST_ERROR_MESSAGE | varchar(1024) | No | ||
LAST_ERROR_TIMESTAMP | timestamp(6) | No | ||
LAST_PROCESSED_TRANSACTION | char(57) | Yes | NULL | |
LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | timestamp(6) | No | ||
LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | timestamp(6) | No | ||
LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP | timestamp(6) | No | ||
LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP | timestamp(6) | No | ||
PROCESSING_TRANSACTION | char(57) | Yes | NULL | |
PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | timestamp(6) | No | ||
PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | timestamp(6) | No | ||
PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP | timestamp(6) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | CHANNEL_NAME | No | |||
THREAD_ID | HASH | No | No | THREAD_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME (Primary) | char(64) | No | ||
WORKER_ID (Primary) | bigint(20) | No | ||
THREAD_ID | bigint(20) | Yes | NULL | |
SERVICE_STATE | enum('ON', 'OFF') | No | ||
LAST_ERROR_NUMBER | int(11) | No | ||
LAST_ERROR_MESSAGE | varchar(1024) | No | ||
LAST_ERROR_TIMESTAMP | timestamp(6) | No | ||
LAST_APPLIED_TRANSACTION | char(57) | Yes | NULL | |
LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | timestamp(6) | No | ||
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | timestamp(6) | No | ||
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP | timestamp(6) | No | ||
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP | timestamp(6) | No | ||
APPLYING_TRANSACTION | char(57) | Yes | NULL | |
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | timestamp(6) | No | ||
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | timestamp(6) | No | ||
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP | timestamp(6) | No | ||
LAST_APPLIED_TRANSACTION_RETRIES_COUNT | bigint(20) | No | ||
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER | int(11) | No | ||
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE | varchar(1024) | Yes | NULL | |
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP | timestamp(6) | No | ||
APPLYING_TRANSACTION_RETRIES_COUNT | bigint(20) | No | ||
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER | int(11) | No | ||
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE | varchar(1024) | Yes | NULL | |
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP | timestamp(6) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | CHANNEL_NAME | No | |||
WORKER_ID | No | |||||||
THREAD_ID | HASH | No | No | THREAD_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME (Primary) | char(64) | No | ||
HOST | char(255) | No | ||
PORT | int(11) | No | ||
USER | char(32) | No | ||
NETWORK_INTERFACE | char(60) | No | ||
AUTO_POSITION | enum('1', '0') | No | ||
SSL_ALLOWED | enum('YES', 'NO', 'IGNORED') | No | ||
SSL_CA_FILE | varchar(512) | No | ||
SSL_CA_PATH | varchar(512) | No | ||
SSL_CERTIFICATE | varchar(512) | No | ||
SSL_CIPHER | varchar(512) | No | ||
SSL_KEY | varchar(512) | No | ||
SSL_VERIFY_SERVER_CERTIFICATE | enum('YES', 'NO') | No | ||
SSL_CRL_FILE | varchar(255) | No | ||
SSL_CRL_PATH | varchar(255) | No | ||
CONNECTION_RETRY_INTERVAL | int(11) | No | ||
CONNECTION_RETRY_COUNT | bigint(20) | No | ||
HEARTBEAT_INTERVAL | double(10,3) | No | Number of seconds after which a heartbeat will be sent . | |
TLS_VERSION | varchar(255) | No | ||
PUBLIC_KEY_PATH | varchar(512) | No | ||
GET_PUBLIC_KEY | enum('YES', 'NO') | No | ||
NETWORK_NAMESPACE | varchar(64) | No | ||
COMPRESSION_ALGORITHM | char(64) | No | Compression algorithm used for data transfer between master and slave. | |
ZSTD_COMPRESSION_LEVEL | int(11) | No | Compression level associated with zstd compression algorithm. |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | CHANNEL_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME (Primary) | char(64) | No | ||
GROUP_NAME | char(36) | No | ||
SOURCE_UUID | char(36) | No | ||
THREAD_ID | bigint(20) | Yes | NULL | |
SERVICE_STATE | enum('ON', 'OFF', 'CONNECTING') | No | ||
COUNT_RECEIVED_HEARTBEATS | bigint(20) | No | 0 | |
LAST_HEARTBEAT_TIMESTAMP | timestamp(6) | No | Shows when the most recent heartbeat signal was received. | |
RECEIVED_TRANSACTION_SET | longtext | No | ||
LAST_ERROR_NUMBER | int(11) | No | ||
LAST_ERROR_MESSAGE | varchar(1024) | No | ||
LAST_ERROR_TIMESTAMP | timestamp(6) | No | ||
LAST_QUEUED_TRANSACTION | char(57) | Yes | NULL | |
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | timestamp(6) | No | ||
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | timestamp(6) | No | ||
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP | timestamp(6) | No | ||
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP | timestamp(6) | No | ||
QUEUEING_TRANSACTION | char(57) | Yes | NULL | |
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | timestamp(6) | No | ||
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | timestamp(6) | No | ||
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP | timestamp(6) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | CHANNEL_NAME | No | |||
THREAD_ID | HASH | No | No | THREAD_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME | char(64) | No | ||
MEMBER_ID | char(36) | No | ||
MEMBER_HOST | char(255) | No | ||
MEMBER_PORT | int(11) | Yes | NULL | |
MEMBER_STATE | char(64) | No | ||
MEMBER_ROLE | char(64) | No | ||
MEMBER_VERSION | char(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHANNEL_NAME | char(64) | No | ||
VIEW_ID | char(60) | No | ||
MEMBER_ID | char(36) | No | ||
COUNT_TRANSACTIONS_IN_QUEUE | bigint(20) | No | ||
COUNT_TRANSACTIONS_CHECKED | bigint(20) | No | ||
COUNT_CONFLICTS_DETECTED | bigint(20) | No | ||
COUNT_TRANSACTIONS_ROWS_VALIDATING | bigint(20) | No | ||
TRANSACTIONS_COMMITTED_ALL_MEMBERS | longtext | No | ||
LAST_CONFLICT_FREE_TRANSACTION | text | No | ||
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE | bigint(20) | No | ||
COUNT_TRANSACTIONS_REMOTE_APPLIED | bigint(20) | No | ||
COUNT_TRANSACTIONS_LOCAL_PROPOSED | bigint(20) | No | ||
COUNT_TRANSACTIONS_LOCAL_ROLLBACK | bigint(20) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
WRITE_LOCKED_BY_THREAD_ID | bigint(20) | Yes | NULL | |
READ_LOCKED_BY_COUNT | int(10) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
NAME | HASH | No | No | NAME | No | |||
WRITE_LOCKED_BY_THREAD_ID | HASH | No | No | WRITE_LOCKED_BY_THREAD_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
PROCESSLIST_ID (Primary) | bigint(20) | No | ||
ATTR_NAME (Primary) | varchar(32) | No | ||
ATTR_VALUE | varchar(1024) | Yes | NULL | |
ORDINAL_POSITION | int(11) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | PROCESSLIST_ID | No | |||
ATTR_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
PROCESSLIST_ID (Primary) | bigint(20) | No | ||
ATTR_NAME (Primary) | varchar(32) | No | ||
ATTR_VALUE | varchar(1024) | Yes | NULL | |
ORDINAL_POSITION | int(11) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | PROCESSLIST_ID | No | |||
ATTR_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST (Primary) | char(255) | No | % | |
USER (Primary) | char(32) | No | % | |
ROLE (Primary) | char(32) | No | % | |
ENABLED | enum('YES', 'NO') | No | YES | |
HISTORY | enum('YES', 'NO') | No | YES |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | HOST | No | |||
USER | No | |||||||
ROLE | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME (Primary) | varchar(64) | No | ||
ENABLED | enum('YES', 'NO') | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME (Primary) | varchar(128) | No | ||
ENABLED | enum('YES', 'NO') | No | ||
TIMED | enum('YES', 'NO') | Yes | NULL | |
PROPERTIES | set('singleton', 'progress', 'user', 'global_statistics', 'mutable') | No | ||
VOLATILITY | int(11) | No | ||
DOCUMENTATION | longtext | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') | No | TABLE | |
OBJECT_SCHEMA | varchar(64) | Yes | % | |
OBJECT_NAME | varchar(64) | No | % | |
ENABLED | enum('YES', 'NO') | No | YES | |
TIMED | enum('YES', 'NO') | No | YES |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
OBJECT | HASH | Yes | No | OBJECT_TYPE | No | |||
OBJECT_SCHEMA | Yes | |||||||
OBJECT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME (Primary) | varchar(128) | No | ||
ENABLED | enum('YES', 'NO') | No | ||
HISTORY | enum('YES', 'NO') | No | ||
PROPERTIES | set('singleton', 'user') | No | ||
VOLATILITY | int(11) | No | ||
DOCUMENTATION | longtext | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
THREAD_ID | bigint(20) | Yes | NULL | |
SOCKET_ID | int(11) | No | ||
IP | varchar(64) | No | ||
PORT | int(11) | No | ||
STATE | enum('IDLE', 'ACTIVE') | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
THREAD_ID | HASH | No | No | THREAD_ID | Yes | |||
SOCKET_ID | HASH | No | No | SOCKET_ID | No | |||
IP | HASH | No | No | IP | No | |||
PORT | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME (Primary) | varchar(128) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_WRITE | bigint(20) | No | ||
COUNT_MISC | bigint(20) | No | ||
SUM_TIMER_MISC | bigint(20) | No | ||
MIN_TIMER_MISC | bigint(20) | No | ||
AVG_TIMER_MISC | bigint(20) | No | ||
MAX_TIMER_MISC | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_NAME | varchar(128) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
SUM_NUMBER_OF_BYTES_WRITE | bigint(20) | No | ||
COUNT_MISC | bigint(20) | No | ||
SUM_TIMER_MISC | bigint(20) | No | ||
MIN_TIMER_MISC | bigint(20) | No | ||
AVG_TIMER_MISC | bigint(20) | No | ||
MAX_TIMER_MISC | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
EVENT_NAME | HASH | No | No | EVENT_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
HOST | char(255) | Yes | NULL | |
VARIABLE_NAME | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
ACCOUNT | HASH | Yes | No | USER | Yes | |||
HOST | Yes | |||||||
VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST | char(255) | Yes | NULL | |
VARIABLE_NAME | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
HOST | HASH | Yes | No | HOST | Yes | |||
VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
VARIABLE_NAME | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes | |||
VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | varchar(64) | No | ||
OBJECT_SCHEMA | varchar(64) | No | ||
OBJECT_NAME | varchar(64) | No | ||
OBJECT_INSTANCE_BEGIN (Primary) | bigint(20) | No | ||
OWNER_THREAD_ID | bigint(20) | Yes | NULL | |
OWNER_EVENT_ID | bigint(20) | Yes | NULL | |
INTERNAL_LOCK | varchar(64) | Yes | NULL | |
EXTERNAL_LOCK | varchar(64) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | OBJECT_INSTANCE_BEGIN | No | |||
OBJECT_TYPE | HASH | No | No | OBJECT_TYPE | No | |||
OBJECT_SCHEMA | No | |||||||
OBJECT_NAME | No | |||||||
OWNER_THREAD_ID | HASH | No | No | OWNER_THREAD_ID | Yes | |||
OWNER_EVENT_ID | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
INDEX_NAME | varchar(64) | Yes | NULL | |
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
COUNT_FETCH | bigint(20) | No | ||
SUM_TIMER_FETCH | bigint(20) | No | ||
MIN_TIMER_FETCH | bigint(20) | No | ||
AVG_TIMER_FETCH | bigint(20) | No | ||
MAX_TIMER_FETCH | bigint(20) | No | ||
COUNT_INSERT | bigint(20) | No | ||
SUM_TIMER_INSERT | bigint(20) | No | ||
MIN_TIMER_INSERT | bigint(20) | No | ||
AVG_TIMER_INSERT | bigint(20) | No | ||
MAX_TIMER_INSERT | bigint(20) | No | ||
COUNT_UPDATE | bigint(20) | No | ||
SUM_TIMER_UPDATE | bigint(20) | No | ||
MIN_TIMER_UPDATE | bigint(20) | No | ||
AVG_TIMER_UPDATE | bigint(20) | No | ||
MAX_TIMER_UPDATE | bigint(20) | No | ||
COUNT_DELETE | bigint(20) | No | ||
SUM_TIMER_DELETE | bigint(20) | No | ||
MIN_TIMER_DELETE | bigint(20) | No | ||
AVG_TIMER_DELETE | bigint(20) | No | ||
MAX_TIMER_DELETE | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
OBJECT | HASH | Yes | No | OBJECT_TYPE | Yes | |||
OBJECT_SCHEMA | Yes | |||||||
OBJECT_NAME | Yes | |||||||
INDEX_NAME | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
COUNT_FETCH | bigint(20) | No | ||
SUM_TIMER_FETCH | bigint(20) | No | ||
MIN_TIMER_FETCH | bigint(20) | No | ||
AVG_TIMER_FETCH | bigint(20) | No | ||
MAX_TIMER_FETCH | bigint(20) | No | ||
COUNT_INSERT | bigint(20) | No | ||
SUM_TIMER_INSERT | bigint(20) | No | ||
MIN_TIMER_INSERT | bigint(20) | No | ||
AVG_TIMER_INSERT | bigint(20) | No | ||
MAX_TIMER_INSERT | bigint(20) | No | ||
COUNT_UPDATE | bigint(20) | No | ||
SUM_TIMER_UPDATE | bigint(20) | No | ||
MIN_TIMER_UPDATE | bigint(20) | No | ||
AVG_TIMER_UPDATE | bigint(20) | No | ||
MAX_TIMER_UPDATE | bigint(20) | No | ||
COUNT_DELETE | bigint(20) | No | ||
SUM_TIMER_DELETE | bigint(20) | No | ||
MIN_TIMER_DELETE | bigint(20) | No | ||
AVG_TIMER_DELETE | bigint(20) | No | ||
MAX_TIMER_DELETE | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
OBJECT | HASH | Yes | No | OBJECT_TYPE | Yes | |||
OBJECT_SCHEMA | Yes | |||||||
OBJECT_NAME | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
COUNT_STAR | bigint(20) | No | ||
SUM_TIMER_WAIT | bigint(20) | No | ||
MIN_TIMER_WAIT | bigint(20) | No | ||
AVG_TIMER_WAIT | bigint(20) | No | ||
MAX_TIMER_WAIT | bigint(20) | No | ||
COUNT_READ | bigint(20) | No | ||
SUM_TIMER_READ | bigint(20) | No | ||
MIN_TIMER_READ | bigint(20) | No | ||
AVG_TIMER_READ | bigint(20) | No | ||
MAX_TIMER_READ | bigint(20) | No | ||
COUNT_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE | bigint(20) | No | ||
COUNT_READ_NORMAL | bigint(20) | No | ||
SUM_TIMER_READ_NORMAL | bigint(20) | No | ||
MIN_TIMER_READ_NORMAL | bigint(20) | No | ||
AVG_TIMER_READ_NORMAL | bigint(20) | No | ||
MAX_TIMER_READ_NORMAL | bigint(20) | No | ||
COUNT_READ_WITH_SHARED_LOCKS | bigint(20) | No | ||
SUM_TIMER_READ_WITH_SHARED_LOCKS | bigint(20) | No | ||
MIN_TIMER_READ_WITH_SHARED_LOCKS | bigint(20) | No | ||
AVG_TIMER_READ_WITH_SHARED_LOCKS | bigint(20) | No | ||
MAX_TIMER_READ_WITH_SHARED_LOCKS | bigint(20) | No | ||
COUNT_READ_HIGH_PRIORITY | bigint(20) | No | ||
SUM_TIMER_READ_HIGH_PRIORITY | bigint(20) | No | ||
MIN_TIMER_READ_HIGH_PRIORITY | bigint(20) | No | ||
AVG_TIMER_READ_HIGH_PRIORITY | bigint(20) | No | ||
MAX_TIMER_READ_HIGH_PRIORITY | bigint(20) | No | ||
COUNT_READ_NO_INSERT | bigint(20) | No | ||
SUM_TIMER_READ_NO_INSERT | bigint(20) | No | ||
MIN_TIMER_READ_NO_INSERT | bigint(20) | No | ||
AVG_TIMER_READ_NO_INSERT | bigint(20) | No | ||
MAX_TIMER_READ_NO_INSERT | bigint(20) | No | ||
COUNT_READ_EXTERNAL | bigint(20) | No | ||
SUM_TIMER_READ_EXTERNAL | bigint(20) | No | ||
MIN_TIMER_READ_EXTERNAL | bigint(20) | No | ||
AVG_TIMER_READ_EXTERNAL | bigint(20) | No | ||
MAX_TIMER_READ_EXTERNAL | bigint(20) | No | ||
COUNT_WRITE_ALLOW_WRITE | bigint(20) | No | ||
SUM_TIMER_WRITE_ALLOW_WRITE | bigint(20) | No | ||
MIN_TIMER_WRITE_ALLOW_WRITE | bigint(20) | No | ||
AVG_TIMER_WRITE_ALLOW_WRITE | bigint(20) | No | ||
MAX_TIMER_WRITE_ALLOW_WRITE | bigint(20) | No | ||
COUNT_WRITE_CONCURRENT_INSERT | bigint(20) | No | ||
SUM_TIMER_WRITE_CONCURRENT_INSERT | bigint(20) | No | ||
MIN_TIMER_WRITE_CONCURRENT_INSERT | bigint(20) | No | ||
AVG_TIMER_WRITE_CONCURRENT_INSERT | bigint(20) | No | ||
MAX_TIMER_WRITE_CONCURRENT_INSERT | bigint(20) | No | ||
COUNT_WRITE_LOW_PRIORITY | bigint(20) | No | ||
SUM_TIMER_WRITE_LOW_PRIORITY | bigint(20) | No | ||
MIN_TIMER_WRITE_LOW_PRIORITY | bigint(20) | No | ||
AVG_TIMER_WRITE_LOW_PRIORITY | bigint(20) | No | ||
MAX_TIMER_WRITE_LOW_PRIORITY | bigint(20) | No | ||
COUNT_WRITE_NORMAL | bigint(20) | No | ||
SUM_TIMER_WRITE_NORMAL | bigint(20) | No | ||
MIN_TIMER_WRITE_NORMAL | bigint(20) | No | ||
AVG_TIMER_WRITE_NORMAL | bigint(20) | No | ||
MAX_TIMER_WRITE_NORMAL | bigint(20) | No | ||
COUNT_WRITE_EXTERNAL | bigint(20) | No | ||
SUM_TIMER_WRITE_EXTERNAL | bigint(20) | No | ||
MIN_TIMER_WRITE_EXTERNAL | bigint(20) | No | ||
AVG_TIMER_WRITE_EXTERNAL | bigint(20) | No | ||
MAX_TIMER_WRITE_EXTERNAL | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
OBJECT | HASH | Yes | No | OBJECT_TYPE | Yes | |||
OBJECT_SCHEMA | Yes | |||||||
OBJECT_NAME | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
NAME | varchar(128) | No | ||
TYPE | varchar(10) | No | ||
PROCESSLIST_ID | bigint(20) | Yes | NULL | |
PROCESSLIST_USER | varchar(32) | Yes | NULL | |
PROCESSLIST_HOST | varchar(255) | Yes | NULL | |
PROCESSLIST_DB | varchar(64) | Yes | NULL | |
PROCESSLIST_COMMAND | varchar(16) | Yes | NULL | |
PROCESSLIST_TIME | bigint(20) | Yes | NULL | |
PROCESSLIST_STATE | varchar(64) | Yes | NULL | |
PROCESSLIST_INFO | longtext | Yes | NULL | |
PARENT_THREAD_ID | bigint(20) | Yes | NULL | |
ROLE | varchar(64) | Yes | NULL | |
INSTRUMENTED | enum('YES', 'NO') | No | ||
HISTORY | enum('YES', 'NO') | No | ||
CONNECTION_TYPE | varchar(16) | Yes | NULL | |
THREAD_OS_ID | bigint(20) | Yes | NULL | |
RESOURCE_GROUP | varchar(64) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
PROCESSLIST_ID | HASH | No | No | PROCESSLIST_ID | Yes | |||
THREAD_OS_ID | HASH | No | No | THREAD_OS_ID | Yes | |||
NAME | HASH | No | No | NAME | No | |||
PROCESSLIST_ACCOUNT | HASH | No | No | PROCESSLIST_USER | Yes | |||
PROCESSLIST_HOST | Yes | |||||||
PROCESSLIST_HOST | HASH | No | No | PROCESSLIST_HOST | Yes | |||
RESOURCE_GROUP | HASH | No | No | RESOURCE_GROUP | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER | char(32) | Yes | NULL | |
CURRENT_CONNECTIONS | bigint(20) | No | ||
TOTAL_CONNECTIONS | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
USER | HASH | Yes | No | USER | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
UDF_NAME (Primary) | varchar(64) | No | ||
UDF_RETURN_TYPE | varchar(20) | No | ||
UDF_TYPE | varchar(20) | No | ||
UDF_LIBRARY | varchar(1024) | Yes | NULL | |
UDF_USAGE_COUNT | bigint(20) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | UDF_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | longblob | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID (Primary) | bigint(20) | No | ||
VARIABLE_NAME (Primary) | varchar(64) | No | ||
VARIABLE_VALUE | varchar(1024) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | HASH | Yes | No | THREAD_ID | No | |||
VARIABLE_NAME | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VARIABLE_NAME | varchar(64) | No | ||
VARIABLE_SOURCE | enum('COMPILED', 'GLOBAL', 'SERVER', 'EXPLICIT', 'EXTRA', 'USER', 'LOGIN', 'COMMAND_LINE', 'PERSISTED', 'DYNAMIC') | Yes | COMPILED | |
VARIABLE_PATH | varchar(1024) | Yes | NULL | |
MIN_VALUE | varchar(64) | Yes | NULL | |
MAX_VALUE | varchar(64) | Yes | NULL | |
SET_TIME | timestamp(6) | Yes | NULL | |
SET_USER | char(32) | Yes | NULL | |
SET_HOST | char(255) | Yes | NULL |
No index defined!