column_stats

Table comments: Statistics on Columns

ColumnTypeNullDefault Links to Comments MIME
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No
column_name (Primary)varchar(64)No
min_valuevarchar(255)YesNULL
max_valuevarchar(255)YesNULL
nulls_ratiodecimal(12,4)YesNULL
avg_lengthdecimal(12,4)YesNULL
avg_frequencydecimal(12,4)YesNULL
hist_sizetinyint(3)YesNULL
hist_typeenum('SINGLE_PREC_HB', 'DOUBLE_PREC_HB')YesNULL
histogramvarbinary(255)YesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_nameANo
table_nameANo
column_name0ANo

columns_priv

Table comments: Column privileges

ColumnTypeNullDefault 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
TimestamptimestampNoCURRENT_TIMESTAMP
Column_privset('Select', 'Insert', 'Update', 'References')No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHost1ANo
Db1ANo
User1ANo
Table_name1ANo
Column_name1ANo

db

Table comments: Database privileges

ColumnTypeNullDefault Links to Comments MIME
Host (Primary)char(60)No
Db (Primary)char(64)No SCHEMATA -> SCHEMA_NAME
User (Primary)char(80)No
Select_privenum('N', 'Y')NoN
Insert_privenum('N', 'Y')NoN
Update_privenum('N', 'Y')NoN
Delete_privenum('N', 'Y')NoN
Create_privenum('N', 'Y')NoN
Drop_privenum('N', 'Y')NoN
Grant_privenum('N', 'Y')NoN
References_privenum('N', 'Y')NoN
Index_privenum('N', 'Y')NoN
Alter_privenum('N', 'Y')NoN
Create_tmp_table_privenum('N', 'Y')NoN
Lock_tables_privenum('N', 'Y')NoN
Create_view_privenum('N', 'Y')NoN
Show_view_privenum('N', 'Y')NoN
Create_routine_privenum('N', 'Y')NoN
Alter_routine_privenum('N', 'Y')NoN
Execute_privenum('N', 'Y')NoN
Event_privenum('N', 'Y')NoN
Trigger_privenum('N', 'Y')NoN

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHost4ANo
Db4ANo
User4ANo
UserBTREENoNoUser4ANo

event

Table comments: Events

ColumnTypeNullDefault Links to Comments MIME
db (Primary)char(64)No SCHEMATA -> SCHEMA_NAME
name (Primary)char(64)No
bodylongblobNo
definerchar(141)No
execute_atdatetimeYesNULL
interval_valueint(11)YesNULL
interval_fieldenum('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')YesNULL
createdtimestampNoCURRENT_TIMESTAMP
modifiedtimestampNo0000-00-00 00:00:00
last_executeddatetimeYesNULL
startsdatetimeYesNULL
endsdatetimeYesNULL
statusenum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')NoENABLED
on_completionenum('DROP', 'PRESERVE')NoDROP
sql_modeset('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
commentchar(64)No
originatorint(10)No
time_zonechar(64)NoSYSTEM
character_set_clientchar(32)YesNULL CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connectionchar(32)YesNULL COLLATIONS -> COLLATION_NAME
db_collationchar(32)YesNULL COLLATIONS -> COLLATION_NAME
body_utf8longblobYesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodbANo
name0ANo

func

Table comments: User defined functions

ColumnTypeNullDefault Links to Comments MIME
name (Primary)char(64)No
rettinyint(1)No0
dlchar(128)No
typeenum('function', 'aggregate')No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoname0ANo

general_log

Table comments: General log

ColumnTypeNullDefault Links to Comments MIME
event_timetimestamp(6)NoCURRENT_TIMESTAMP(6)
user_hostmediumtextNo
thread_idbigint(21)No
server_idint(10)No
command_typevarchar(64)No
argumentmediumtextNo

gtid_slave_pos

Table comments: Replication slave GTID position

ColumnTypeNullDefault Links to Comments MIME
domain_id (Primary)int(10)No
sub_id (Primary)bigint(20)No
server_idint(10)No
seq_nobigint(20)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodomain_id0ANo
sub_id0ANo

help_category

Table comments: help categories

ColumnTypeNullDefault Links to Comments MIME
help_category_id (Primary)smallint(5)No
namechar(64)No
parent_category_idsmallint(5)YesNULL help_category -> help_category_id
urltextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_category_id39ANo
nameBTREEYesNoname39ANo

help_keyword

Table comments: help keywords

ColumnTypeNullDefault Links to Comments MIME
help_keyword_id (Primary)int(10)No
namechar(64)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_keyword_id464ANo
nameBTREEYesNoname464ANo

help_relation

Table comments: keyword-topic relation

ColumnTypeNullDefault 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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_keyword_idANo
help_topic_id1028ANo

help_topic

Table comments: help topics

ColumnTypeNullDefault Links to Comments MIME
help_topic_id (Primary)int(10)No
namechar(64)No
help_category_idsmallint(5)No help_category -> help_category_id
descriptiontextNo
exampletextNo
urltextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_topic_id508ANo
nameBTREEYesNoname508ANo

host

Table comments: Host privileges; Merged with database privileges

ColumnTypeNullDefault Links to Comments MIME
Host (Primary)char(60)No
Db (Primary)char(64)No
Select_privenum('N', 'Y')NoN
Insert_privenum('N', 'Y')NoN
Update_privenum('N', 'Y')NoN
Delete_privenum('N', 'Y')NoN
Create_privenum('N', 'Y')NoN
Drop_privenum('N', 'Y')NoN
Grant_privenum('N', 'Y')NoN
References_privenum('N', 'Y')NoN
Index_privenum('N', 'Y')NoN
Alter_privenum('N', 'Y')NoN
Create_tmp_table_privenum('N', 'Y')NoN
Lock_tables_privenum('N', 'Y')NoN
Create_view_privenum('N', 'Y')NoN
Show_view_privenum('N', 'Y')NoN
Create_routine_privenum('N', 'Y')NoN
Alter_routine_privenum('N', 'Y')NoN
Execute_privenum('N', 'Y')NoN
Trigger_privenum('N', 'Y')NoN

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
Db0ANo

index_stats

Table comments: Statistics on Indexes

ColumnTypeNullDefault 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_frequencydecimal(12,4)YesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_nameANo
table_nameANo
index_nameANo
prefix_arity0ANo

innodb_index_stats

ColumnTypeNullDefault 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_updatetimestampNoCURRENT_TIMESTAMP
stat_name (Primary)varchar(64)No
stat_valuebigint(20)No
sample_sizebigint(20)YesNULL
stat_descriptionvarchar(1024)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodatabase_name2ANo
table_name2798ANo
index_name5597ANo
stat_name5597ANo

innodb_table_stats

ColumnTypeNullDefault Links to Comments MIME
database_name (Primary)varchar(64)No SCHEMATA -> SCHEMA_NAME
table_name (Primary)varchar(64)No
last_updatetimestampNoCURRENT_TIMESTAMP
n_rowsbigint(20)No
clustered_index_sizebigint(20)No
sum_of_other_index_sizesbigint(20)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodatabase_name6ANo
table_name1313ANo

plugin

Table comments: MySQL plugins

ColumnTypeNullDefault Links to Comments MIME
name (Primary)varchar(64)No
dlvarchar(128)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoname0ANo

proc

Table comments: Stored Procedures

ColumnTypeNullDefault Links to Comments MIME
db (Primary)char(64)No SCHEMATA -> SCHEMA_NAME
name (Primary)char(64)No
type (Primary)enum('FUNCTION', 'PROCEDURE')No
specific_namechar(64)No
languageenum('SQL')NoSQL
sql_data_accessenum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')NoCONTAINS_SQL
is_deterministicenum('YES', 'NO')NoNO
security_typeenum('INVOKER', 'DEFINER')NoDEFINER
param_listblobNo
returnslongblobNo
bodylongblobNo
definerchar(141)No
createdtimestampNoCURRENT_TIMESTAMP
modifiedtimestampNo0000-00-00 00:00:00
sql_modeset('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
commenttextNo
character_set_clientchar(32)YesNULL CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connectionchar(32)YesNULL COLLATIONS -> COLLATION_NAME
db_collationchar(32)YesNULL COLLATIONS -> COLLATION_NAME
body_utf8longblobYesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodbANo
nameANo
type2ANo

procs_priv

Table comments: Procedure privileges

ColumnTypeNullDefault 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
Grantorchar(141)No
Proc_privset('Execute', 'Alter Routine', 'Grant')No
TimestamptimestampNoCURRENT_TIMESTAMP

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHost1ANo
Db1ANo
User1ANo
Routine_name1ANo
Routine_type1ANo
GrantorBTREENoNoGrantor1ANo

proxies_priv

Table comments: User proxy privileges

ColumnTypeNullDefault 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_granttinyint(1)No0
Grantorchar(141)No
TimestamptimestampNoCURRENT_TIMESTAMP

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
UserANo
Proxied_hostANo
Proxied_user1ANo
GrantorBTREENoNoGrantor0ANo

roles_mapping

Table comments: Granted roles

ColumnTypeNullDefault Links to Comments MIME
Hostchar(60)No
Userchar(80)No
Rolechar(80)No
Admin_optionenum('N', 'Y')NoN

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
HostBTREEYesNoHostANo
UserANo
Role0ANo

servers

Table comments: MySQL Foreign Servers table

ColumnTypeNullDefault Links to Comments MIME
Server_name (Primary)char(64)No
Hostchar(64)No
Dbchar(64)No SCHEMATA -> SCHEMA_NAME
Usernamechar(80)No
Passwordchar(64)No
Portint(4)No0
Socketchar(64)No
Wrapperchar(64)No
Ownerchar(64)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoServer_name0ANo

slow_log

Table comments: Slow log

ColumnTypeNullDefault Links to Comments MIME
start_timetimestamp(6)NoCURRENT_TIMESTAMP(6)
user_hostmediumtextNo
query_timetime(6)No
lock_timetime(6)No
rows_sentint(11)No
rows_examinedint(11)No
dbvarchar(512)No SCHEMATA -> SCHEMA_NAME
last_insert_idint(11)No
insert_idint(11)No
server_idint(10)No
sql_textmediumtextNo
thread_idbigint(21)No
rows_affectedint(11)No

table_stats

Table comments: Statistics on Tables

ColumnTypeNullDefault Links to Comments MIME
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No
cardinalitybigint(21)YesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_nameANo
table_name0ANo

tables_priv

Table comments: Table privileges

ColumnTypeNullDefault 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
Grantorchar(141)No
TimestamptimestampNoCURRENT_TIMESTAMP
Table_privset('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')No
Column_privset('Select', 'Insert', 'Update', 'References')No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHost1ANo
Db1ANo
User1ANo
Table_name1ANo
GrantorBTREENoNoGrantor1ANo

time_zone

Table comments: Time zones

ColumnTypeNullDefault Links to Comments MIME
Time_zone_id (Primary)int(10)No
Use_leap_secondsenum('Y', 'N')NoN

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTime_zone_id0ANo

time_zone_leap_second

Table comments: Leap seconds information for time zones

ColumnTypeNullDefault Links to Comments MIME
Transition_time (Primary)bigint(20)No
Correctionint(11)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTransition_time0ANo

time_zone_name

Table comments: Time zone names

ColumnTypeNullDefault Links to Comments MIME
Name (Primary)char(64)No
Time_zone_idint(10)No time_zone -> Time_zone_id

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoName0ANo

time_zone_transition

Table comments: Time zone transitions

ColumnTypeNullDefault 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_idint(10)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTime_zone_idANo
Transition_time0ANo

time_zone_transition_type

Table comments: Time zone transition types

ColumnTypeNullDefault Links to Comments MIME
Time_zone_id (Primary)int(10)No time_zone -> Time_zone_id
Transition_type_id (Primary)int(10)No
Offsetint(11)No0
Is_DSTtinyint(3)No0
Abbreviationchar(8)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTime_zone_idANo
Transition_type_id0ANo

user

Table comments: Users and global privileges

ColumnTypeNullDefault Links to Comments MIME
Host (Primary)char(60)No
User (Primary)char(80)No
Passwordchar(41)No
Select_privenum('N', 'Y')NoN
Insert_privenum('N', 'Y')NoN
Update_privenum('N', 'Y')NoN
Delete_privenum('N', 'Y')NoN
Create_privenum('N', 'Y')NoN
Drop_privenum('N', 'Y')NoN
Reload_privenum('N', 'Y')NoN
Shutdown_privenum('N', 'Y')NoN
Process_privenum('N', 'Y')NoN
File_privenum('N', 'Y')NoN
Grant_privenum('N', 'Y')NoN
References_privenum('N', 'Y')NoN
Index_privenum('N', 'Y')NoN
Alter_privenum('N', 'Y')NoN
Show_db_privenum('N', 'Y')NoN
Super_privenum('N', 'Y')NoN
Create_tmp_table_privenum('N', 'Y')NoN
Lock_tables_privenum('N', 'Y')NoN
Execute_privenum('N', 'Y')NoN
Repl_slave_privenum('N', 'Y')NoN
Repl_client_privenum('N', 'Y')NoN
Create_view_privenum('N', 'Y')NoN
Show_view_privenum('N', 'Y')NoN
Create_routine_privenum('N', 'Y')NoN
Alter_routine_privenum('N', 'Y')NoN
Create_user_privenum('N', 'Y')NoN
Event_privenum('N', 'Y')NoN
Trigger_privenum('N', 'Y')NoN
Create_tablespace_privenum('N', 'Y')NoN
ssl_typeenum('', 'ANY', 'X509', 'SPECIFIED')No
ssl_cipherblobNo
x509_issuerblobNo
x509_subjectblobNo
max_questionsint(11)No0
max_updatesint(11)No0
max_connectionsint(11)No0
max_user_connectionsint(11)No0
pluginchar(64)No
authentication_stringtextNo
password_expiredenum('N', 'Y')NoN
is_roleenum('N', 'Y')NoN
default_rolechar(80)No
max_statement_timedecimal(12,6)No0.000000

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
User9ANo