Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

performance_schema

accounts

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
CURRENT_CONNECTIONS	bigint(20)	No
TOTAL_CONNECTIONS	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
ACCOUNT	HASH	Yes	No	USER			Yes
ACCOUNT	HASH	Yes	No	HOST			Yes

cond_instances

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN			No
NAME	HASH	No	No	NAME			No

data_locks

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	ENGINE_LOCK_ID	No
PRIMARY	HASH	Yes	No	ENGINE	No
ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE_TRANSACTION_ID	Yes
ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE	No
THREAD_ID	HASH	No	No	THREAD_ID	Yes
THREAD_ID	HASH	No	No	EVENT_ID	Yes
OBJECT_SCHEMA	HASH	No	No	OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes
				PARTITION_NAME	Yes
				SUBPARTITION_NAME	Yes

data_lock_waits

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
REQUESTING_ENGINE_LOCK_ID	HASH	No	No	REQUESTING_ENGINE_LOCK_ID	No
REQUESTING_ENGINE_LOCK_ID	HASH	No	No	ENGINE	No
BLOCKING_ENGINE_LOCK_ID	HASH	No	No	BLOCKING_ENGINE_LOCK_ID	No
BLOCKING_ENGINE_LOCK_ID	HASH	No	No	ENGINE	No
REQUESTING_ENGINE_TRANSACTION_ID	HASH	No	No	REQUESTING_ENGINE_TRANSACTION_ID	Yes
REQUESTING_ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE	No
BLOCKING_ENGINE_TRANSACTION_ID	HASH	No	No	BLOCKING_ENGINE_TRANSACTION_ID	Yes
BLOCKING_ENGINE_TRANSACTION_ID	HASH	No	No	ENGINE	No
REQUESTING_THREAD_ID	HASH	No	No	REQUESTING_THREAD_ID	Yes
REQUESTING_THREAD_ID	HASH	No	No	REQUESTING_EVENT_ID	Yes
BLOCKING_THREAD_ID	HASH	No	No	BLOCKING_THREAD_ID	Yes
BLOCKING_THREAD_ID	HASH	No	No	BLOCKING_EVENT_ID	Yes

events_errors_summary_by_account_by_error

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				ERROR_NUMBER	Yes

events_errors_summary_by_host_by_error

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	ERROR_NUMBER			Yes

events_errors_summary_by_thread_by_error

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
THREAD_ID	HASH	Yes	No	THREAD_ID			No
THREAD_ID	HASH	Yes	No	ERROR_NUMBER			Yes

events_errors_summary_by_user_by_error

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	ERROR_NUMBER			Yes

events_errors_summary_global_by_error

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
ERROR_NUMBER	HASH	Yes	No	ERROR_NUMBER			Yes

events_stages_current

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_stages_history

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_stages_history_long

Column	Type	Null	Default
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!

events_stages_summary_by_account_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_stages_summary_by_host_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_stages_summary_by_thread_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_stages_summary_by_user_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_stages_summary_global_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_statements_current

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_statements_histogram_by_digest

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
SCHEMA_NAME	HASH	Yes	No	SCHEMA_NAME	Yes
				DIGEST	Yes
				BUCKET_NUMBER	No

events_statements_histogram_global

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	BUCKET_NUMBER			No

events_statements_history

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_statements_history_long

Column	Type	Null	Default
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!

events_statements_summary_by_account_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_statements_summary_by_digest

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
SCHEMA_NAME	HASH	Yes	No	SCHEMA_NAME			Yes
SCHEMA_NAME	HASH	Yes	No	DIGEST			Yes

events_statements_summary_by_host_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_statements_summary_by_program

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_TYPE	No
				OBJECT_SCHEMA	No
				OBJECT_NAME	No

events_statements_summary_by_thread_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_statements_summary_by_user_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_statements_summary_global_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_transactions_current

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_transactions_history

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_transactions_history_long

Column	Type	Null	Default
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!

events_transactions_summary_by_account_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_transactions_summary_by_host_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_transactions_summary_by_thread_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_transactions_summary_by_user_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_transactions_summary_global_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_waits_current

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_waits_history

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_ID			No

events_waits_history_long

Column	Type	Null	Default
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!

events_waits_summary_by_account_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

events_waits_summary_by_host_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

events_waits_summary_by_instance

Column	Type	Null
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

Indexes

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

events_waits_summary_by_thread_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

events_waits_summary_by_user_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

events_waits_summary_global_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

file_instances

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	FILE_NAME			No
EVENT_NAME	HASH	No	No	EVENT_NAME			No

file_summary_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

file_summary_by_instance

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
FILE_NAME	HASH	No	No	FILE_NAME	No
EVENT_NAME	HASH	No	No	EVENT_NAME	No

global_status

Column	Type	Null	Default	Comments
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

global_variables

Column	Type	Null	Default	Comments
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

hosts

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes

host_cache

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	IP			No
HOST	HASH	No	No	HOST			Yes

keyring_keys

Column	Type	Null	Default
KEY_ID	varchar(255)	No
KEY_OWNER	varchar(255)	Yes	NULL
BACKEND_KEY_ID	varchar(255)	Yes	NULL

No index defined!

log_status

Column	Type	Null
SERVER_UUID	char(36)	No
LOCAL	json	No
REPLICATION	json	No
STORAGE_ENGINES	json	No

No index defined!

memory_summary_by_account_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				EVENT_NAME	No

memory_summary_by_host_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	EVENT_NAME			No

memory_summary_by_thread_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	EVENT_NAME			No

memory_summary_by_user_by_event_name

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	EVENT_NAME			No

memory_summary_global_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

metadata_locks

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
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_THREAD_ID	HASH	No	No	OWNER_EVENT_ID	Yes

mutex_instances

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

Indexes

Keyname	Type	Unique	Packed	Column	Null
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

objects_summary_global_by_type

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes

performance_timers

Column	Type	Null	Default
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!

persisted_variables

Column	Type	Null	Default	Comments
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

prepared_statements_instances

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	OBJECT_INSTANCE_BEGIN	No
OWNER_THREAD_ID	HASH	Yes	No	OWNER_THREAD_ID	No
OWNER_THREAD_ID	HASH	Yes	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

replication_applier_configuration

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.

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No

replication_applier_filters

Column	Type	Null	Default
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!

replication_applier_global_filters

Column	Type	Null	Default
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!

replication_applier_status

Column	Type	Null	Default
CHANNEL_NAME (Primary)	char(64)	No
SERVICE_STATE	enum('ON', 'OFF')	No
REMAINING_DELAY	int(10)	Yes	NULL
COUNT_TRANSACTIONS_RETRIES	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No

replication_applier_status_by_coordinator

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No
THREAD_ID	HASH	No	No	THREAD_ID			Yes

replication_applier_status_by_worker

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	CHANNEL_NAME	No
PRIMARY	HASH	Yes	No	WORKER_ID	No
THREAD_ID	HASH	No	No	THREAD_ID	Yes

replication_connection_configuration

Column	Type	Null	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.

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No

replication_connection_status

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	CHANNEL_NAME			No
THREAD_ID	HASH	No	No	THREAD_ID			Yes

replication_group_members

Column	Type	Null	Default
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!

replication_group_member_stats

Column	Type	Null
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!

rwlock_instances

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
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

session_account_connect_attrs

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	PROCESSLIST_ID			No
PRIMARY	HASH	Yes	No	ATTR_NAME			No

session_connect_attrs

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	PROCESSLIST_ID			No
PRIMARY	HASH	Yes	No	ATTR_NAME			No

session_status

Column	Type	Null	Default	Comments
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

session_variables

Column	Type	Null	Default	Comments
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

setup_actors

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
PRIMARY	HASH	Yes	No	HOST	No
				USER	No
				ROLE	No

setup_consumers

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	NAME			No

setup_instruments

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	NAME			No

setup_objects

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	No
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	No

setup_threads

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	NAME			No

socket_instances

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
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
IP	HASH	No	No	PORT	No

socket_summary_by_event_name

Column	Type	Null
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	EVENT_NAME			No

socket_summary_by_instance

Column	Type	Null
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

Indexes

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

status_by_account

Column	Type	Null	Default
USER	char(32)	Yes	NULL
HOST	char(255)	Yes	NULL
VARIABLE_NAME	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Null
ACCOUNT	HASH	Yes	No	USER	Yes
				HOST	Yes
				VARIABLE_NAME	No

status_by_host

Column	Type	Null	Default
HOST	char(255)	Yes	NULL
VARIABLE_NAME	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
HOST	HASH	Yes	No	HOST			Yes
HOST	HASH	Yes	No	VARIABLE_NAME			No

status_by_thread

Column	Type	Null	Default
THREAD_ID (Primary)	bigint(20)	No
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

status_by_user

Column	Type	Null	Default
USER	char(32)	Yes	NULL
VARIABLE_NAME	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes
USER	HASH	Yes	No	VARIABLE_NAME			No

table_handles

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
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_THREAD_ID	HASH	No	No	OWNER_EVENT_ID	Yes

table_io_waits_summary_by_index_usage

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes
				INDEX_NAME	Yes

table_io_waits_summary_by_table

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes

table_lock_waits_summary_by_table

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
OBJECT	HASH	Yes	No	OBJECT_TYPE	Yes
				OBJECT_SCHEMA	Yes
				OBJECT_NAME	Yes

threads

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Null
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_ACCOUNT	HASH	No	No	PROCESSLIST_HOST	Yes
PROCESSLIST_HOST	HASH	No	No	PROCESSLIST_HOST	Yes
RESOURCE_GROUP	HASH	No	No	RESOURCE_GROUP	Yes

users

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
USER	HASH	Yes	No	USER			Yes

user_defined_functions

Column	Type	Null	Default
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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	UDF_NAME			No

user_variables_by_thread

Column	Type	Null	Default
THREAD_ID (Primary)	bigint(20)	No
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	longblob	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

variables_by_thread

Column	Type	Null	Default
THREAD_ID (Primary)	bigint(20)	No
VARIABLE_NAME (Primary)	varchar(64)	No
VARIABLE_VALUE	varchar(1024)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	HASH	Yes	No	THREAD_ID			No
PRIMARY	HASH	Yes	No	VARIABLE_NAME			No

variables_info

Column	Type	Null	Default
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!

phpMyAdmin Demo Server: Git information missing!