column_stats

Table comments: Statistics on Columns

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
column_name (Primary)	varchar(64)	No
min_value	varchar(255)	Yes	NULL
max_value	varchar(255)	Yes	NULL
nulls_ratio	decimal(12,4)	Yes	NULL
avg_length	decimal(12,4)	Yes	NULL
avg_frequency	decimal(12,4)	Yes	NULL
hist_size	tinyint(3)	Yes	NULL
hist_type	enum('SINGLE_PREC_HB', 'DOUBLE_PREC_HB')	Yes	NULL
histogram	varbinary(255)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name		A	No
				table_name		A	No
				column_name	0	A	No

columns_priv

Table comments: Column privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(80)	No
Table_name (Primary)	char(64)	No
Column_name (Primary)	char(64)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP
Column_priv	set('Select', 'Insert', 'Update', 'References')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host	1	A	No
				Db	1	A	No
				User	1	A	No
				Table_name	1	A	No
				Column_name	1	A	No

db

Table comments: Database privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(80)	No
Select_priv	enum('N', 'Y')	No	N
Insert_priv	enum('N', 'Y')	No	N
Update_priv	enum('N', 'Y')	No	N
Delete_priv	enum('N', 'Y')	No	N
Create_priv	enum('N', 'Y')	No	N
Drop_priv	enum('N', 'Y')	No	N
Grant_priv	enum('N', 'Y')	No	N
References_priv	enum('N', 'Y')	No	N
Index_priv	enum('N', 'Y')	No	N
Alter_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Create_view_priv	enum('N', 'Y')	No	N
Show_view_priv	enum('N', 'Y')	No	N
Create_routine_priv	enum('N', 'Y')	No	N
Alter_routine_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Event_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host	4	A	No
				Db	4	A	No
				User	4	A	No
User	BTREE	No	No	User	4	A	No

event

Table comments: Events

Column	Type	Null	Default	Links to	Comments	MIME
db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
name (Primary)	char(64)	No
body	longblob	No
definer	char(141)	No
execute_at	datetime	Yes	NULL
interval_value	int(11)	Yes	NULL
interval_field	enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')	Yes	NULL
created	timestamp	No	CURRENT_TIMESTAMP
modified	timestamp	No	0000-00-00 00:00:00
last_executed	datetime	Yes	NULL
starts	datetime	Yes	NULL
ends	datetime	Yes	NULL
status	enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')	No	ENABLED
on_completion	enum('DROP', 'PRESERVE')	No	DROP
sql_mode	set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')	No
comment	char(64)	No
originator	int(10)	No
time_zone	char(64)	No	SYSTEM
character_set_client	char(32)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connection	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
db_collation	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
body_utf8	longblob	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db		A	No
				name	0	A	No

func

Table comments: User defined functions

Column	Type	Null	Default	Links to	Comments	MIME
name (Primary)	char(64)	No
ret	tinyint(1)	No	0
dl	char(128)	No
type	enum('function', 'aggregate')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	name	0	A	No

general_log

Table comments: General log

Column	Type	Null	Default	Links to	Comments	MIME
event_time	timestamp(6)	No	CURRENT_TIMESTAMP(6)
user_host	mediumtext	No
thread_id	bigint(21)	No
server_id	int(10)	No
command_type	varchar(64)	No
argument	mediumtext	No

gtid_slave_pos

Table comments: Replication slave GTID position

Column	Type	Null	Default	Links to	Comments	MIME
domain_id (Primary)	int(10)	No
sub_id (Primary)	bigint(20)	No
server_id	int(10)	No
seq_no	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	domain_id	0	A	No
				sub_id	0	A	No

help_category

Table comments: help categories

Column	Type	Null	Default	Links to	Comments	MIME
help_category_id (Primary)	smallint(5)	No
name	char(64)	No
parent_category_id	smallint(5)	Yes	NULL	help_category -> help_category_id
url	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_category_id	39	A	No
name	BTREE	Yes	No	name	39	A	No

help_keyword

Table comments: help keywords

Column	Type	Null	Default	Links to	Comments	MIME
help_keyword_id (Primary)	int(10)	No
name	char(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_keyword_id	464	A	No
name	BTREE	Yes	No	name	464	A	No

help_relation

Table comments: keyword-topic relation

Column	Type	Null	Default	Links to	Comments	MIME
help_topic_id (Primary)	int(10)	No		help_topic -> help_topic_id
help_keyword_id (Primary)	int(10)	No		help_keyword -> help_keyword_id

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_keyword_id		A	No
				help_topic_id	1028	A	No

help_topic

Table comments: help topics

Column	Type	Null	Default	Links to	Comments	MIME
help_topic_id (Primary)	int(10)	No
name	char(64)	No
help_category_id	smallint(5)	No		help_category -> help_category_id
description	text	No
example	text	No
url	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_topic_id	508	A	No
name	BTREE	Yes	No	name	508	A	No

host

Table comments: Host privileges; Merged with database privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No
Select_priv	enum('N', 'Y')	No	N
Insert_priv	enum('N', 'Y')	No	N
Update_priv	enum('N', 'Y')	No	N
Delete_priv	enum('N', 'Y')	No	N
Create_priv	enum('N', 'Y')	No	N
Drop_priv	enum('N', 'Y')	No	N
Grant_priv	enum('N', 'Y')	No	N
References_priv	enum('N', 'Y')	No	N
Index_priv	enum('N', 'Y')	No	N
Alter_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Create_view_priv	enum('N', 'Y')	No	N
Show_view_priv	enum('N', 'Y')	No	N
Create_routine_priv	enum('N', 'Y')	No	N
Alter_routine_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host		A	No
				Db	0	A	No

index_stats

Table comments: Statistics on Indexes

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
index_name (Primary)	varchar(64)	No
prefix_arity (Primary)	int(11)	No
avg_frequency	decimal(12,4)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name		A	No
				table_name		A	No
				index_name		A	No
				prefix_arity	0	A	No

innodb_index_stats

Column	Type	Null	Default	Links to	Comments	MIME
database_name (Primary)	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
table_name (Primary)	varchar(64)	No
index_name (Primary)	varchar(64)	No
last_update	timestamp	No	CURRENT_TIMESTAMP
stat_name (Primary)	varchar(64)	No
stat_value	bigint(20)	No
sample_size	bigint(20)	Yes	NULL
stat_description	varchar(1024)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	database_name	2	A	No
				table_name	1643	A	No
				index_name	4931	A	No
				stat_name	4931	A	No

innodb_table_stats

Column	Type	Null	Default	Links to	Comments	MIME
database_name (Primary)	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
table_name (Primary)	varchar(64)	No
last_update	timestamp	No	CURRENT_TIMESTAMP
n_rows	bigint(20)	No
clustered_index_size	bigint(20)	No
sum_of_other_index_sizes	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	database_name	6	A	No
				table_name	1355	A	No

plugin

Table comments: MySQL plugins

Column	Type	Null	Default	Links to	Comments	MIME
name (Primary)	varchar(64)	No
dl	varchar(128)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	name	0	A	No

proc

Table comments: Stored Procedures

Column	Type	Null	Default	Links to	Comments	MIME
db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
name (Primary)	char(64)	No
type (Primary)	enum('FUNCTION', 'PROCEDURE')	No
specific_name	char(64)	No
language	enum('SQL')	No	SQL
sql_data_access	enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')	No	CONTAINS_SQL
is_deterministic	enum('YES', 'NO')	No	NO
security_type	enum('INVOKER', 'DEFINER')	No	DEFINER
param_list	blob	No
returns	longblob	No
body	longblob	No
definer	char(141)	No
created	timestamp	No	CURRENT_TIMESTAMP
modified	timestamp	No	0000-00-00 00:00:00
sql_mode	set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')	No
comment	text	No
character_set_client	char(32)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connection	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
db_collation	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
body_utf8	longblob	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db		A	No
				name		A	No
				type	2	A	No

procs_priv

Table comments: Procedure privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No
User (Primary)	char(80)	No
Routine_name (Primary)	char(64)	No
Routine_type (Primary)	enum('FUNCTION', 'PROCEDURE')	No
Grantor	char(141)	No
Proc_priv	set('Execute', 'Alter Routine', 'Grant')	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host	1	A	No
				Db	1	A	No
				User	1	A	No
				Routine_name	1	A	No
				Routine_type	1	A	No
Grantor	BTREE	No	No	Grantor	1	A	No

proxies_priv

Table comments: User proxy privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
User (Primary)	char(80)	No
Proxied_host (Primary)	char(60)	No
Proxied_user (Primary)	char(80)	No
With_grant	tinyint(1)	No	0
Grantor	char(141)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host		A	No
				User		A	No
				Proxied_host		A	No
				Proxied_user	1	A	No
Grantor	BTREE	No	No	Grantor	0	A	No

roles_mapping

Table comments: Granted roles

Column	Type	Null	Default	Links to	Comments	MIME
Host	char(60)	No
User	char(80)	No
Role	char(80)	No
Admin_option	enum('N', 'Y')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
Host	BTREE	Yes	No	Host		A	No
				User		A	No
				Role	0	A	No

servers

Table comments: MySQL Foreign Servers table

Column	Type	Null	Default	Links to	Comments	MIME
Server_name (Primary)	char(64)	No
Host	char(64)	No
Db	char(64)	No		SCHEMATA -> SCHEMA_NAME
Username	char(80)	No
Password	char(64)	No
Port	int(4)	No	0
Socket	char(64)	No
Wrapper	char(64)	No
Owner	char(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Server_name	0	A	No

slow_log

Table comments: Slow log

Column	Type	Null	Default	Links to	Comments	MIME
start_time	timestamp(6)	No	CURRENT_TIMESTAMP(6)
user_host	mediumtext	No
query_time	time(6)	No
lock_time	time(6)	No
rows_sent	int(11)	No
rows_examined	int(11)	No
db	varchar(512)	No		SCHEMATA -> SCHEMA_NAME
last_insert_id	int(11)	No
insert_id	int(11)	No
server_id	int(10)	No
sql_text	mediumtext	No
thread_id	bigint(21)	No
rows_affected	int(11)	No

table_stats

Table comments: Statistics on Tables

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
cardinality	bigint(21)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name		A	No
				table_name	0	A	No

tables_priv

Table comments: Table privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(80)	No
Table_name (Primary)	char(64)	No
Grantor	char(141)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP
Table_priv	set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')	No
Column_priv	set('Select', 'Insert', 'Update', 'References')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host	1	A	No
				Db	1	A	No
				User	1	A	No
				Table_name	1	A	No
Grantor	BTREE	No	No	Grantor	1	A	No

time_zone

Table comments: Time zones

Column	Type	Null	Default	Links to	Comments	MIME
Time_zone_id (Primary)	int(10)	No
Use_leap_seconds	enum('Y', 'N')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Time_zone_id	0	A	No

time_zone_leap_second

Table comments: Leap seconds information for time zones

Column	Type	Null	Default	Links to	Comments	MIME
Transition_time (Primary)	bigint(20)	No
Correction	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Transition_time	0	A	No

time_zone_name

Table comments: Time zone names

Column	Type	Null	Default	Links to	Comments	MIME
Name (Primary)	char(64)	No
Time_zone_id	int(10)	No		time_zone -> Time_zone_id

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Name	0	A	No

time_zone_transition

Table comments: Time zone transitions

Column	Type	Null	Default	Links to	Comments	MIME
Time_zone_id (Primary)	int(10)	No		time_zone -> Time_zone_id
Transition_time (Primary)	bigint(20)	No		time_zone_leap_second -> Transition_time
Transition_type_id	int(10)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Time_zone_id		A	No
				Transition_time	0	A	No

time_zone_transition_type

Table comments: Time zone transition types

Column	Type	Null	Default	Links to	Comments	MIME
Time_zone_id (Primary)	int(10)	No		time_zone -> Time_zone_id
Transition_type_id (Primary)	int(10)	No
Offset	int(11)	No	0
Is_DST	tinyint(3)	No	0
Abbreviation	char(8)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Time_zone_id		A	No
				Transition_type_id	0	A	No

user

Table comments: Users and global privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(60)	No
User (Primary)	char(80)	No
Password	char(41)	No
Select_priv	enum('N', 'Y')	No	N
Insert_priv	enum('N', 'Y')	No	N
Update_priv	enum('N', 'Y')	No	N
Delete_priv	enum('N', 'Y')	No	N
Create_priv	enum('N', 'Y')	No	N
Drop_priv	enum('N', 'Y')	No	N
Reload_priv	enum('N', 'Y')	No	N
Shutdown_priv	enum('N', 'Y')	No	N
Process_priv	enum('N', 'Y')	No	N
File_priv	enum('N', 'Y')	No	N
Grant_priv	enum('N', 'Y')	No	N
References_priv	enum('N', 'Y')	No	N
Index_priv	enum('N', 'Y')	No	N
Alter_priv	enum('N', 'Y')	No	N
Show_db_priv	enum('N', 'Y')	No	N
Super_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Repl_slave_priv	enum('N', 'Y')	No	N
Repl_client_priv	enum('N', 'Y')	No	N
Create_view_priv	enum('N', 'Y')	No	N
Show_view_priv	enum('N', 'Y')	No	N
Create_routine_priv	enum('N', 'Y')	No	N
Alter_routine_priv	enum('N', 'Y')	No	N
Create_user_priv	enum('N', 'Y')	No	N
Event_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N
Create_tablespace_priv	enum('N', 'Y')	No	N
ssl_type	enum('', 'ANY', 'X509', 'SPECIFIED')	No
ssl_cipher	blob	No
x509_issuer	blob	No
x509_subject	blob	No
max_questions	int(11)	No	0
max_updates	int(11)	No	0
max_connections	int(11)	No	0
max_user_connections	int(11)	No	0
plugin	char(64)	No
authentication_string	text	No
password_expired	enum('N', 'Y')	No	N
is_role	enum('N', 'Y')	No	N
default_role	char(80)	No
max_statement_time	decimal(12,6)	No	0.000000

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host		A	No
				User	9	A	No