NG大舞台

column_stats

Table comments: Statistics on Columns

Column	Type	Null	Default	Links to	Comments

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

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	29	A	No

db

Table comments: Database privileges

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host	2	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

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

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

gtid_slave_pos

Table comments: Replication slave GTID position

Column	Type	Null	Default	Links to	Comments

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

Indexes

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

help_keyword

Table comments: help keywords

Column	Type	Null	Default	Links to	Comments

Indexes

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

help_relation

Table comments: keyword-topic relation

Column	Type	Null	Default	Links to	Comments

Indexes

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

help_topic

Table comments: help topics

Column	Type	Null	Default	Links to	Comments

Indexes

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

host

Table comments: Host privileges; Merged with database privileges

Column	Type	Null	Default	Links to	Comments

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

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	database_name	4	A	No
				table_name	55	A	No
				index_name	55	A	No
				stat_name	111	A	No

innodb_table_stats

Column	Type	Null	Default	Links to	Comments

Indexes

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

ndb_binlog_index

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	epoch		A	No
				orig_server_id		A	No
				orig_epoch	0	A	No

plugin

Table comments: MySQL plugins

Column	Type	Null	Default	Links to	Comments

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

Indexes

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

procs_priv

Table comments: Procedure privileges

Column	Type	Null	Default	Links to	Comments

Indexes

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

proxies_priv

Table comments: User proxy privileges

Column	Type	Null	Default	Links to	Comments

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		A	No

roles_mapping

Table comments: Granted roles

Column	Type	Null	Default	Links to	Comments

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

Indexes

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

slave_master_info

Table comments: Master Information

Column	Type	Null	Default	Links to	Comments

Indexes

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

slave_relay_log_info

Table comments: Relay Log Information

Column	Type	Null	Default	Links to	Comments

Indexes

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

slave_worker_info

Table comments: Worker Information

Column	Type	Null	Default	Links to	Comments

Indexes

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

slow_log

Table comments: Slow log

Column	Type	Null	Default	Links to	Comments

table_stats

Table comments: Statistics on Tables

Column	Type	Null	Default	Links to	Comments

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

Indexes

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

time_zone

Table comments: Time zones

Column	Type	Null	Default	Links to	Comments

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

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

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

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

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

Indexes

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