CHARACTER_SETS

Column	Type	Null	Default	Links to	Comments	MIME
CHARACTER_SET_NAME	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
DEFAULT_COLLATE_NAME	varchar(32)	No		COLLATIONS -> COLLATION_NAME
DESCRIPTION	varchar(60)	No
MAXLEN	bigint(3)	No	0

COLLATIONS

Column	Type	Null	Default	Links to	Comments	MIME
COLLATION_NAME	varchar(32)	No
CHARACTER_SET_NAME	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
ID	bigint(11)	No	0
IS_DEFAULT	varchar(3)	No
IS_COMPILED	varchar(3)	No
SORTLEN	bigint(3)	No	0

COLLATION_CHARACTER_SET_APPLICABILITY

Column	Type	Null	Default	Links to	Comments	MIME
COLLATION_NAME	varchar(32)	No		COLLATIONS -> COLLATION_NAME
CHARACTER_SET_NAME	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME

COLUMNS

Column	Type	Null	Default	Links to	Comments	MIME
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
COLUMN_NAME	varchar(64)	No
ORDINAL_POSITION	bigint(21)	No	0
COLUMN_DEFAULT	longtext	Yes	NULL
IS_NULLABLE	varchar(3)	No
DATA_TYPE	varchar(64)	No
CHARACTER_MAXIMUM_LENGTH	bigint(21)	Yes	NULL
CHARACTER_OCTET_LENGTH	bigint(21)	Yes	NULL
NUMERIC_PRECISION	bigint(21)	Yes	NULL
NUMERIC_SCALE	bigint(21)	Yes	NULL
DATETIME_PRECISION	bigint(21)	Yes	NULL
CHARACTER_SET_NAME	varchar(32)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAME	varchar(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
COLUMN_TYPE	longtext	No
COLUMN_KEY	varchar(3)	No
EXTRA	varchar(30)	No
PRIVILEGES	varchar(80)	No
COLUMN_COMMENT	varchar(1024)	No

COLUMN_PRIVILEGES

Column	Type	Null	Default	Links to	Comments	MIME
GRANTEE	varchar(81)	No
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
COLUMN_NAME	varchar(64)	No
PRIVILEGE_TYPE	varchar(64)	No
IS_GRANTABLE	varchar(3)	No

ENGINES

Column	Type	Null	Default	Comments	MIME
ENGINE	varchar(64)	No
SUPPORT	varchar(8)	No
COMMENT	varchar(80)	No
TRANSACTIONS	varchar(3)	Yes	NULL
XA	varchar(3)	Yes	NULL
SAVEPOINTS	varchar(3)	Yes	NULL

EVENTS

Column	Type	Null	Default	Links to	Comments	MIME
EVENT_CATALOG	varchar(64)	No
EVENT_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
EVENT_NAME	varchar(64)	No
DEFINER	varchar(77)	No
TIME_ZONE	varchar(64)	No
EVENT_BODY	varchar(8)	No
EVENT_DEFINITION	longtext	No
EVENT_TYPE	varchar(9)	No
EXECUTE_AT	datetime	Yes	NULL
INTERVAL_VALUE	varchar(256)	Yes	NULL
INTERVAL_FIELD	varchar(18)	Yes	NULL
SQL_MODE	varchar(8192)	No
STARTS	datetime	Yes	NULL
ENDS	datetime	Yes	NULL
STATUS	varchar(18)	No
ON_COMPLETION	varchar(12)	No
CREATED	datetime	No	0000-00-00 00:00:00
LAST_ALTERED	datetime	No	0000-00-00 00:00:00
LAST_EXECUTED	datetime	Yes	NULL
EVENT_COMMENT	varchar(64)	No
ORIGINATOR	bigint(10)	No	0
CHARACTER_SET_CLIENT	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	No		COLLATIONS -> COLLATION_NAME
DATABASE_COLLATION	varchar(32)	No		COLLATIONS -> COLLATION_NAME

FILES

Column	Type	Null	Default	Links to	Comments	MIME
FILE_ID	bigint(4)	No	0
FILE_NAME	varchar(64)	Yes	NULL
FILE_TYPE	varchar(20)	No
TABLESPACE_NAME	varchar(64)	Yes	NULL	TABLESPACES -> TABLESPACE_NAME
TABLE_CATALOG	varchar(64)	No
TABLE_SCHEMA	varchar(64)	Yes	NULL	SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	Yes	NULL
LOGFILE_GROUP_NAME	varchar(64)	Yes	NULL
LOGFILE_GROUP_NUMBER	bigint(4)	Yes	NULL
ENGINE	varchar(64)	No		ENGINES -> ENGINE
FULLTEXT_KEYS	varchar(64)	Yes	NULL
DELETED_ROWS	bigint(4)	Yes	NULL
UPDATE_COUNT	bigint(4)	Yes	NULL
FREE_EXTENTS	bigint(4)	Yes	NULL
TOTAL_EXTENTS	bigint(4)	Yes	NULL
EXTENT_SIZE	bigint(4)	No	0
INITIAL_SIZE	bigint(21)	Yes	NULL
MAXIMUM_SIZE	bigint(21)	Yes	NULL
AUTOEXTEND_SIZE	bigint(21)	Yes	NULL
CREATION_TIME	datetime	Yes	NULL
LAST_UPDATE_TIME	datetime	Yes	NULL
LAST_ACCESS_TIME	datetime	Yes	NULL
RECOVER_TIME	bigint(4)	Yes	NULL
TRANSACTION_COUNTER	bigint(4)	Yes	NULL
VERSION	bigint(21)	Yes	NULL
ROW_FORMAT	varchar(10)	Yes	NULL
TABLE_ROWS	bigint(21)	Yes	NULL
AVG_ROW_LENGTH	bigint(21)	Yes	NULL
DATA_LENGTH	bigint(21)	Yes	NULL
MAX_DATA_LENGTH	bigint(21)	Yes	NULL
INDEX_LENGTH	bigint(21)	Yes	NULL
DATA_FREE	bigint(21)	Yes	NULL
CREATE_TIME	datetime	Yes	NULL
UPDATE_TIME	datetime	Yes	NULL
CHECK_TIME	datetime	Yes	NULL
CHECKSUM	bigint(21)	Yes	NULL
STATUS	varchar(20)	No
EXTRA	varchar(255)	Yes	NULL

GLOBAL_STATUS

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

GLOBAL_VARIABLES

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

KEY_COLUMN_USAGE

Column	Type	Null	Default	Links to	Comments	MIME
CONSTRAINT_CATALOG	varchar(512)	No
CONSTRAINT_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAME	varchar(64)	No
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
COLUMN_NAME	varchar(64)	No
ORDINAL_POSITION	bigint(10)	No	0
POSITION_IN_UNIQUE_CONSTRAINT	bigint(10)	Yes	NULL
REFERENCED_TABLE_SCHEMA	varchar(64)	Yes	NULL	SCHEMATA -> SCHEMA_NAME
REFERENCED_TABLE_NAME	varchar(64)	Yes	NULL
REFERENCED_COLUMN_NAME	varchar(64)	Yes	NULL

OPTIMIZER_TRACE

Column	Type	Null	Default	Comments	MIME
QUERY	longtext	No
TRACE	longtext	No
MISSING_BYTES_BEYOND_MAX_MEM_SIZE	int(20)	No	0
INSUFFICIENT_PRIVILEGES	tinyint(1)	No	0

PARAMETERS

Column	Type	Null	Default	Links to	Comments	MIME
SPECIFIC_CATALOG	varchar(512)	No
SPECIFIC_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
SPECIFIC_NAME	varchar(64)	No
ORDINAL_POSITION	int(21)	No	0
PARAMETER_MODE	varchar(5)	Yes	NULL
PARAMETER_NAME	varchar(64)	Yes	NULL
DATA_TYPE	varchar(64)	No
CHARACTER_MAXIMUM_LENGTH	int(21)	Yes	NULL
CHARACTER_OCTET_LENGTH	int(21)	Yes	NULL
NUMERIC_PRECISION	bigint(21)	Yes	NULL
NUMERIC_SCALE	int(21)	Yes	NULL
DATETIME_PRECISION	bigint(21)	Yes	NULL
CHARACTER_SET_NAME	varchar(64)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAME	varchar(64)	Yes	NULL	COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIER	longtext	No
ROUTINE_TYPE	varchar(9)	No

PARTITIONS

Column	Type	Null	Default	Links to	Comments	MIME
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
PARTITION_NAME	varchar(64)	Yes	NULL
SUBPARTITION_NAME	varchar(64)	Yes	NULL
PARTITION_ORDINAL_POSITION	bigint(21)	Yes	NULL
SUBPARTITION_ORDINAL_POSITION	bigint(21)	Yes	NULL
PARTITION_METHOD	varchar(18)	Yes	NULL
SUBPARTITION_METHOD	varchar(12)	Yes	NULL
PARTITION_EXPRESSION	longtext	Yes	NULL
SUBPARTITION_EXPRESSION	longtext	Yes	NULL
PARTITION_DESCRIPTION	longtext	Yes	NULL
TABLE_ROWS	bigint(21)	No	0
AVG_ROW_LENGTH	bigint(21)	No	0
DATA_LENGTH	bigint(21)	No	0
MAX_DATA_LENGTH	bigint(21)	Yes	NULL
INDEX_LENGTH	bigint(21)	No	0
DATA_FREE	bigint(21)	No	0
CREATE_TIME	datetime	Yes	NULL
UPDATE_TIME	datetime	Yes	NULL
CHECK_TIME	datetime	Yes	NULL
CHECKSUM	bigint(21)	Yes	NULL
PARTITION_COMMENT	varchar(80)	No
NODEGROUP	varchar(12)	No
TABLESPACE_NAME	varchar(64)	Yes	NULL	TABLESPACES -> TABLESPACE_NAME

PLUGINS

Column	Type	Null	Default	Comments	MIME
PLUGIN_NAME	varchar(64)	No
PLUGIN_VERSION	varchar(20)	No
PLUGIN_STATUS	varchar(10)	No
PLUGIN_TYPE	varchar(80)	No
PLUGIN_TYPE_VERSION	varchar(20)	No
PLUGIN_LIBRARY	varchar(64)	Yes	NULL
PLUGIN_LIBRARY_VERSION	varchar(20)	Yes	NULL
PLUGIN_AUTHOR	varchar(64)	Yes	NULL
PLUGIN_DESCRIPTION	longtext	Yes	NULL
PLUGIN_LICENSE	varchar(80)	Yes	NULL
LOAD_OPTION	varchar(64)	No

PROCESSLIST

Column	Type	Null	Default	Links to	Comments	MIME
ID	bigint(21)	No	0
USER	varchar(16)	No
HOST	varchar(64)	No
DB	varchar(64)	Yes	NULL	SCHEMATA -> SCHEMA_NAME
COMMAND	varchar(16)	No
TIME	int(7)	No	0
STATE	varchar(64)	Yes	NULL
INFO	longtext	Yes	NULL

PROFILING

Column	Type	Null	Default	Comments	MIME
QUERY_ID	int(20)	No	0
SEQ	int(20)	No	0
STATE	varchar(30)	No
DURATION	decimal(9,6)	No	0.000000
CPU_USER	decimal(9,6)	Yes	NULL
CPU_SYSTEM	decimal(9,6)	Yes	NULL
CONTEXT_VOLUNTARY	int(20)	Yes	NULL
CONTEXT_INVOLUNTARY	int(20)	Yes	NULL
BLOCK_OPS_IN	int(20)	Yes	NULL
BLOCK_OPS_OUT	int(20)	Yes	NULL
MESSAGES_SENT	int(20)	Yes	NULL
MESSAGES_RECEIVED	int(20)	Yes	NULL
PAGE_FAULTS_MAJOR	int(20)	Yes	NULL
PAGE_FAULTS_MINOR	int(20)	Yes	NULL
SWAPS	int(20)	Yes	NULL
SOURCE_FUNCTION	varchar(30)	Yes	NULL
SOURCE_FILE	varchar(20)	Yes	NULL
SOURCE_LINE	int(20)	Yes	NULL

REFERENTIAL_CONSTRAINTS

Column	Type	Null	Default	Links to	Comments	MIME
CONSTRAINT_CATALOG	varchar(512)	No
CONSTRAINT_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAME	varchar(64)	No
UNIQUE_CONSTRAINT_CATALOG	varchar(512)	No
UNIQUE_CONSTRAINT_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
UNIQUE_CONSTRAINT_NAME	varchar(64)	Yes	NULL
MATCH_OPTION	varchar(64)	No
UPDATE_RULE	varchar(64)	No
DELETE_RULE	varchar(64)	No
TABLE_NAME	varchar(64)	No
REFERENCED_TABLE_NAME	varchar(64)	No

ROUTINES

Column	Type	Null	Default	Links to	Comments	MIME
SPECIFIC_NAME	varchar(64)	No
ROUTINE_CATALOG	varchar(512)	No
ROUTINE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
ROUTINE_NAME	varchar(64)	No
ROUTINE_TYPE	varchar(9)	No
DATA_TYPE	varchar(64)	No
CHARACTER_MAXIMUM_LENGTH	int(21)	Yes	NULL
CHARACTER_OCTET_LENGTH	int(21)	Yes	NULL
NUMERIC_PRECISION	bigint(21)	Yes	NULL
NUMERIC_SCALE	int(21)	Yes	NULL
DATETIME_PRECISION	bigint(21)	Yes	NULL
CHARACTER_SET_NAME	varchar(64)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAME	varchar(64)	Yes	NULL	COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIER	longtext	Yes	NULL
ROUTINE_BODY	varchar(8)	No
ROUTINE_DEFINITION	longtext	Yes	NULL
EXTERNAL_NAME	varchar(64)	Yes	NULL
EXTERNAL_LANGUAGE	varchar(64)	Yes	NULL
PARAMETER_STYLE	varchar(8)	No
IS_DETERMINISTIC	varchar(3)	No
SQL_DATA_ACCESS	varchar(64)	No
SQL_PATH	varchar(64)	Yes	NULL
SECURITY_TYPE	varchar(7)	No
CREATED	datetime	No	0000-00-00 00:00:00
LAST_ALTERED	datetime	No	0000-00-00 00:00:00
SQL_MODE	varchar(8192)	No
ROUTINE_COMMENT	longtext	No
DEFINER	varchar(77)	No
CHARACTER_SET_CLIENT	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	No		COLLATIONS -> COLLATION_NAME
DATABASE_COLLATION	varchar(32)	No		COLLATIONS -> COLLATION_NAME

SCHEMATA

Column	Type	Null	Default	Links to	Comments	MIME
CATALOG_NAME	varchar(512)	No
SCHEMA_NAME	varchar(64)	No
DEFAULT_CHARACTER_SET_NAME	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
DEFAULT_COLLATION_NAME	varchar(32)	No		COLLATIONS -> COLLATION_NAME
SQL_PATH	varchar(512)	Yes	NULL

SCHEMA_PRIVILEGES

Column	Type	Null	Default	Links to	Comments	MIME
GRANTEE	varchar(81)	No
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
PRIVILEGE_TYPE	varchar(64)	No
IS_GRANTABLE	varchar(3)	No

SESSION_STATUS

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

SESSION_VARIABLES

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

STATISTICS

Column	Type	Null	Default	Links to	Comments	MIME
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
NON_UNIQUE	bigint(1)	No	0
INDEX_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
INDEX_NAME	varchar(64)	No
SEQ_IN_INDEX	bigint(2)	No	0
COLUMN_NAME	varchar(64)	No
COLLATION	varchar(1)	Yes	NULL
CARDINALITY	bigint(21)	Yes	NULL
SUB_PART	bigint(3)	Yes	NULL
PACKED	varchar(10)	Yes	NULL
NULLABLE	varchar(3)	No
INDEX_TYPE	varchar(16)	No
COMMENT	varchar(16)	Yes	NULL
INDEX_COMMENT	varchar(1024)	No

TABLES

Column	Type	Null	Default	Links to	Comments	MIME
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
TABLE_TYPE	varchar(64)	No
ENGINE	varchar(64)	Yes	NULL	ENGINES -> ENGINE
VERSION	bigint(21)	Yes	NULL
ROW_FORMAT	varchar(10)	Yes	NULL
TABLE_ROWS	bigint(21)	Yes	NULL
AVG_ROW_LENGTH	bigint(21)	Yes	NULL
DATA_LENGTH	bigint(21)	Yes	NULL
MAX_DATA_LENGTH	bigint(21)	Yes	NULL
INDEX_LENGTH	bigint(21)	Yes	NULL
DATA_FREE	bigint(21)	Yes	NULL
AUTO_INCREMENT	bigint(21)	Yes	NULL
CREATE_TIME	datetime	Yes	NULL
UPDATE_TIME	datetime	Yes	NULL
CHECK_TIME	datetime	Yes	NULL
TABLE_COLLATION	varchar(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
CHECKSUM	bigint(21)	Yes	NULL
CREATE_OPTIONS	varchar(255)	Yes	NULL
TABLE_COMMENT	varchar(2048)	No

TABLESPACES

Column	Type	Null	Default	Comments	MIME
TABLESPACE_NAME	varchar(64)	No
ENGINE	varchar(64)	No
TABLESPACE_TYPE	varchar(64)	Yes	NULL
LOGFILE_GROUP_NAME	varchar(64)	Yes	NULL
EXTENT_SIZE	bigint(21)	Yes	NULL
AUTOEXTEND_SIZE	bigint(21)	Yes	NULL
MAXIMUM_SIZE	bigint(21)	Yes	NULL
NODEGROUP_ID	bigint(21)	Yes	NULL
TABLESPACE_COMMENT	varchar(2048)	Yes	NULL

TABLE_CONSTRAINTS

Column	Type	Null	Default	Links to	Comments	MIME
CONSTRAINT_CATALOG	varchar(512)	No
CONSTRAINT_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAME	varchar(64)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
CONSTRAINT_TYPE	varchar(64)	No

TABLE_PRIVILEGES

Column	Type	Null	Default	Links to	Comments	MIME
GRANTEE	varchar(81)	No
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
PRIVILEGE_TYPE	varchar(64)	No
IS_GRANTABLE	varchar(3)	No

TRIGGERS

Column	Type	Null	Default	Links to	Comments	MIME
TRIGGER_CATALOG	varchar(512)	No
TRIGGER_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TRIGGER_NAME	varchar(64)	No
EVENT_MANIPULATION	varchar(6)	No
EVENT_OBJECT_CATALOG	varchar(512)	No
EVENT_OBJECT_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
EVENT_OBJECT_TABLE	varchar(64)	No
ACTION_ORDER	bigint(4)	No	0
ACTION_CONDITION	longtext	Yes	NULL
ACTION_STATEMENT	longtext	No
ACTION_ORIENTATION	varchar(9)	No
ACTION_TIMING	varchar(6)	No
ACTION_REFERENCE_OLD_TABLE	varchar(64)	Yes	NULL
ACTION_REFERENCE_NEW_TABLE	varchar(64)	Yes	NULL
ACTION_REFERENCE_OLD_ROW	varchar(3)	No
ACTION_REFERENCE_NEW_ROW	varchar(3)	No
CREATED	datetime	Yes	NULL
SQL_MODE	varchar(8192)	No
DEFINER	varchar(77)	No
CHARACTER_SET_CLIENT	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	No		COLLATIONS -> COLLATION_NAME
DATABASE_COLLATION	varchar(32)	No		COLLATIONS -> COLLATION_NAME

USER_PRIVILEGES

Column	Type	Null	Default	Comments	MIME
GRANTEE	varchar(81)	No
TABLE_CATALOG	varchar(512)	No
PRIVILEGE_TYPE	varchar(64)	No
IS_GRANTABLE	varchar(3)	No

VIEWS

Column	Type	Null	Default	Links to	Comments	MIME
TABLE_CATALOG	varchar(512)	No
TABLE_SCHEMA	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
TABLE_NAME	varchar(64)	No
VIEW_DEFINITION	longtext	No
CHECK_OPTION	varchar(8)	No
IS_UPDATABLE	varchar(3)	No
DEFINER	varchar(77)	No
SECURITY_TYPE	varchar(7)	No
CHARACTER_SET_CLIENT	varchar(32)	No		CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTION	varchar(32)	No		COLLATIONS -> COLLATION_NAME

INNODB_LOCKS

Column	Type	Null	Default	Comments	MIME
lock_id	varchar(81)	No
lock_trx_id	varchar(18)	No
lock_mode	varchar(32)	No
lock_type	varchar(32)	No
lock_table	varchar(1024)	No
lock_index	varchar(1024)	Yes	NULL
lock_space	bigint(21)	Yes	NULL
lock_page	bigint(21)	Yes	NULL
lock_rec	bigint(21)	Yes	NULL
lock_data	varchar(8192)	Yes	NULL

INNODB_TRX

Column	Type	Null	Default	Comments	MIME
trx_id	varchar(18)	No
trx_state	varchar(13)	No
trx_started	datetime	No	0000-00-00 00:00:00
trx_requested_lock_id	varchar(81)	Yes	NULL
trx_wait_started	datetime	Yes	NULL
trx_weight	bigint(21)	No	0
trx_mysql_thread_id	bigint(21)	No	0
trx_query	varchar(1024)	Yes	NULL
trx_operation_state	varchar(64)	Yes	NULL
trx_tables_in_use	bigint(21)	No	0
trx_tables_locked	bigint(21)	No	0
trx_lock_structs	bigint(21)	No	0
trx_lock_memory_bytes	bigint(21)	No	0
trx_rows_locked	bigint(21)	No	0
trx_rows_modified	bigint(21)	No	0
trx_concurrency_tickets	bigint(21)	No	0
trx_isolation_level	varchar(16)	No
trx_unique_checks	int(1)	No	0
trx_foreign_key_checks	int(1)	No	0
trx_last_foreign_key_error	varchar(256)	Yes	NULL
trx_adaptive_hash_latched	int(1)	No	0
trx_adaptive_hash_timeout	bigint(21)	No	0
trx_is_read_only	int(1)	No	0
trx_autocommit_non_locking	int(1)	No	0

INNODB_SYS_DATAFILES

Column	Type	Null	Default	Comments	MIME
SPACE	int(11)	No	0
PATH	varchar(4000)	No

INNODB_LOCK_WAITS

Column	Type	Null	Default	Comments	MIME
requesting_trx_id	varchar(18)	No
requested_lock_id	varchar(81)	No
blocking_trx_id	varchar(18)	No
blocking_lock_id	varchar(81)	No

INNODB_SYS_TABLESTATS

Column	Type	Null	Default	Comments	MIME
TABLE_ID	bigint(21)	No	0
NAME	varchar(193)	No
STATS_INITIALIZED	varchar(193)	No
NUM_ROWS	bigint(21)	No	0
CLUST_INDEX_SIZE	bigint(21)	No	0
OTHER_INDEX_SIZE	bigint(21)	No	0
MODIFIED_COUNTER	bigint(21)	No	0
AUTOINC	bigint(21)	No	0
REF_COUNT	int(11)	No	0

INNODB_CMP

Column	Type	Null	Default	Comments	MIME
page_size	int(5)	No	0
compress_ops	int(11)	No	0
compress_ops_ok	int(11)	No	0
compress_time	int(11)	No	0
uncompress_ops	int(11)	No	0
uncompress_time	int(11)	No	0

INNODB_METRICS

Column	Type	Null	Default	Comments	MIME
NAME	varchar(193)	No
SUBSYSTEM	varchar(193)	No
COUNT	bigint(21)	No	0
MAX_COUNT	bigint(21)	Yes	NULL
MIN_COUNT	bigint(21)	Yes	NULL
AVG_COUNT	double	Yes	NULL
COUNT_RESET	bigint(21)	No	0
MAX_COUNT_RESET	bigint(21)	Yes	NULL
MIN_COUNT_RESET	bigint(21)	Yes	NULL
AVG_COUNT_RESET	double	Yes	NULL
TIME_ENABLED	datetime	Yes	NULL
TIME_DISABLED	datetime	Yes	NULL
TIME_ELAPSED	bigint(21)	Yes	NULL
TIME_RESET	datetime	Yes	NULL
STATUS	varchar(193)	No
TYPE	varchar(193)	No
COMMENT	varchar(193)	No

INNODB_CMP_RESET

Column	Type	Null	Default	Comments	MIME
page_size	int(5)	No	0
compress_ops	int(11)	No	0
compress_ops_ok	int(11)	No	0
compress_time	int(11)	No	0
uncompress_ops	int(11)	No	0
uncompress_time	int(11)	No	0

INNODB_CMP_PER_INDEX

Column	Type	Null	Default	Comments	MIME
database_name	varchar(192)	No
table_name	varchar(192)	No
index_name	varchar(192)	No
compress_ops	int(11)	No	0
compress_ops_ok	int(11)	No	0
compress_time	int(11)	No	0
uncompress_ops	int(11)	No	0
uncompress_time	int(11)	No	0

INNODB_CMPMEM_RESET

Column	Type	Null	Default	Comments	MIME
page_size	int(5)	No	0
buffer_pool_instance	int(11)	No	0
pages_used	int(11)	No	0
pages_free	int(11)	No	0
relocation_ops	bigint(21)	No	0
relocation_time	int(11)	No	0

INNODB_FT_DELETED

Column	Type	Null	Default	Comments	MIME
DOC_ID	bigint(21)	No	0

INNODB_BUFFER_PAGE_LRU

Column	Type	Null	Default	Comments	MIME
POOL_ID	bigint(21)	No	0
LRU_POSITION	bigint(21)	No	0
SPACE	bigint(21)	No	0
PAGE_NUMBER	bigint(21)	No	0
PAGE_TYPE	varchar(64)	Yes	NULL
FLUSH_TYPE	bigint(21)	No	0
FIX_COUNT	bigint(21)	No	0
IS_HASHED	varchar(3)	Yes	NULL
NEWEST_MODIFICATION	bigint(21)	No	0
OLDEST_MODIFICATION	bigint(21)	No	0
ACCESS_TIME	bigint(21)	No	0
TABLE_NAME	varchar(1024)	Yes	NULL
INDEX_NAME	varchar(1024)	Yes	NULL
NUMBER_RECORDS	bigint(21)	No	0
DATA_SIZE	bigint(21)	No	0
COMPRESSED_SIZE	bigint(21)	No	0
COMPRESSED	varchar(3)	Yes	NULL
IO_FIX	varchar(64)	Yes	NULL
IS_OLD	varchar(3)	Yes	NULL
FREE_PAGE_CLOCK	bigint(21)	No	0

INNODB_SYS_FOREIGN

Column	Type	Null	Default	Comments	MIME
ID	varchar(193)	No
FOR_NAME	varchar(193)	No
REF_NAME	varchar(193)	No
N_COLS	int(11)	No	0
TYPE	int(11)	No	0

INNODB_SYS_COLUMNS

Column	Type	Null	Default	Comments	MIME
TABLE_ID	bigint(21)	No	0
NAME	varchar(193)	No
POS	bigint(21)	No	0
MTYPE	int(11)	No	0
PRTYPE	int(11)	No	0
LEN	int(11)	No	0

INNODB_SYS_INDEXES

Column	Type	Null	Default	Comments	MIME
INDEX_ID	bigint(21)	No	0
NAME	varchar(193)	No
TABLE_ID	bigint(21)	No	0
TYPE	int(11)	No	0
N_FIELDS	int(11)	No	0
PAGE_NO	int(11)	No	0
SPACE	int(11)	No	0

INNODB_FT_DEFAULT_STOPWORD

Column	Type	Null	Default	Comments	MIME
value	varchar(18)	No

INNODB_SYS_FIELDS

Column	Type	Null	Default	Comments	MIME
INDEX_ID	bigint(21)	No	0
NAME	varchar(193)	No
POS	int(11)	No	0

INNODB_CMP_PER_INDEX_RESET

Column	Type	Null	Default	Comments	MIME
database_name	varchar(192)	No
table_name	varchar(192)	No
index_name	varchar(192)	No
compress_ops	int(11)	No	0
compress_ops_ok	int(11)	No	0
compress_time	int(11)	No	0
uncompress_ops	int(11)	No	0
uncompress_time	int(11)	No	0

INNODB_BUFFER_PAGE

Column	Type	Null	Default	Comments	MIME
POOL_ID	bigint(21)	No	0
BLOCK_ID	bigint(21)	No	0
SPACE	bigint(21)	No	0
PAGE_NUMBER	bigint(21)	No	0
PAGE_TYPE	varchar(64)	Yes	NULL
FLUSH_TYPE	bigint(21)	No	0
FIX_COUNT	bigint(21)	No	0
IS_HASHED	varchar(3)	Yes	NULL
NEWEST_MODIFICATION	bigint(21)	No	0
OLDEST_MODIFICATION	bigint(21)	No	0
ACCESS_TIME	bigint(21)	No	0
TABLE_NAME	varchar(1024)	Yes	NULL
INDEX_NAME	varchar(1024)	Yes	NULL
NUMBER_RECORDS	bigint(21)	No	0
DATA_SIZE	bigint(21)	No	0
COMPRESSED_SIZE	bigint(21)	No	0
PAGE_STATE	varchar(64)	Yes	NULL
IO_FIX	varchar(64)	Yes	NULL
IS_OLD	varchar(3)	Yes	NULL
FREE_PAGE_CLOCK	bigint(21)	No	0

INNODB_CMPMEM

Column	Type	Null	Default	Comments	MIME
page_size	int(5)	No	0
buffer_pool_instance	int(11)	No	0
pages_used	int(11)	No	0
pages_free	int(11)	No	0
relocation_ops	bigint(21)	No	0
relocation_time	int(11)	No	0

INNODB_FT_INDEX_TABLE

Column	Type	Null	Default	Comments	MIME
WORD	varchar(255)	No
FIRST_DOC_ID	bigint(21)	No	0
LAST_DOC_ID	bigint(21)	No	0
DOC_COUNT	bigint(21)	No	0
DOC_ID	bigint(21)	No	0
POSITION	bigint(21)	No	0

INNODB_FT_BEING_DELETED

Column	Type	Null	Default	Comments	MIME
DOC_ID	bigint(21)	No	0

INNODB_SYS_TABLESPACES

Column	Type	Null	Default	Comments	MIME
SPACE	int(11)	No	0
NAME	varchar(655)	No
FLAG	int(11)	No	0
FILE_FORMAT	varchar(10)	Yes	NULL
ROW_FORMAT	varchar(22)	Yes	NULL
PAGE_SIZE	int(11)	No	0
ZIP_PAGE_SIZE	int(11)	No	0

INNODB_FT_INDEX_CACHE

Column	Type	Null	Default	Comments	MIME
WORD	varchar(255)	No
FIRST_DOC_ID	bigint(21)	No	0
LAST_DOC_ID	bigint(21)	No	0
DOC_COUNT	bigint(21)	No	0
DOC_ID	bigint(21)	No	0
POSITION	bigint(21)	No	0

INNODB_SYS_FOREIGN_COLS

Column	Type	Null	Default	Comments	MIME
ID	varchar(193)	No
FOR_COL_NAME	varchar(193)	No
REF_COL_NAME	varchar(193)	No
POS	int(11)	No	0

INNODB_SYS_TABLES

Column	Type	Null	Default	Comments	MIME
TABLE_ID	bigint(21)	No	0
NAME	varchar(655)	No
FLAG	int(11)	No	0
N_COLS	int(11)	No	0
SPACE	int(11)	No	0
FILE_FORMAT	varchar(10)	Yes	NULL
ROW_FORMAT	varchar(12)	Yes	NULL
ZIP_PAGE_SIZE	int(11)	No	0

INNODB_BUFFER_POOL_STATS

Column	Type	Null	Default	Comments	MIME
POOL_ID	bigint(21)	No	0
POOL_SIZE	bigint(21)	No	0
FREE_BUFFERS	bigint(21)	No	0
DATABASE_PAGES	bigint(21)	No	0
OLD_DATABASE_PAGES	bigint(21)	No	0
MODIFIED_DATABASE_PAGES	bigint(21)	No	0
PENDING_DECOMPRESS	bigint(21)	No	0
PENDING_READS	bigint(21)	No	0
PENDING_FLUSH_LRU	bigint(21)	No	0
PENDING_FLUSH_LIST	bigint(21)	No	0
PAGES_MADE_YOUNG	bigint(21)	No	0
PAGES_NOT_MADE_YOUNG	bigint(21)	No	0
PAGES_MADE_YOUNG_RATE	double	No	0
PAGES_MADE_NOT_YOUNG_RATE	double	No	0
NUMBER_PAGES_READ	bigint(21)	No	0
NUMBER_PAGES_CREATED	bigint(21)	No	0
NUMBER_PAGES_WRITTEN	bigint(21)	No	0
PAGES_READ_RATE	double	No	0
PAGES_CREATE_RATE	double	No	0
PAGES_WRITTEN_RATE	double	No	0
NUMBER_PAGES_GET	bigint(21)	No	0
HIT_RATE	bigint(21)	No	0
YOUNG_MAKE_PER_THOUSAND_GETS	bigint(21)	No	0
NOT_YOUNG_MAKE_PER_THOUSAND_GETS	bigint(21)	No	0
NUMBER_PAGES_READ_AHEAD	bigint(21)	No	0
NUMBER_READ_AHEAD_EVICTED	bigint(21)	No	0
READ_AHEAD_RATE	double	No	0
READ_AHEAD_EVICTED_RATE	double	No	0
LRU_IO_TOTAL	bigint(21)	No	0
LRU_IO_CURRENT	bigint(21)	No	0
UNCOMPRESS_TOTAL	bigint(21)	No	0
UNCOMPRESS_CURRENT	bigint(21)	No	0

INNODB_FT_CONFIG

Column	Type	Null	Default	Comments	MIME
KEY	varchar(193)	No
VALUE	varchar(193)	No