information_schema

ALL_PLUGINS

Column Type Null Default Comments
PLUGIN_NAME varchar(64) No
PLUGIN_VERSION varchar(20) No
PLUGIN_STATUS varchar(16) 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) No
LOAD_OPTION varchar(64) No
PLUGIN_MATURITY varchar(12) No
PLUGIN_AUTH_VERSION varchar(80) Yes NULL

APPLICABLE_ROLES

Column Type Null Default Comments
GRANTEE varchar(190) No
ROLE_NAME varchar(128) No
IS_GRANTABLE varchar(3) No
IS_DEFAULT varchar(3) Yes NULL

CHARACTER_SETS

Column Type Null Default Comments
CHARACTER_SET_NAME varchar(32) No
DEFAULT_COLLATE_NAME varchar(32) No
DESCRIPTION varchar(60) No
MAXLEN bigint(3) No 0

CHECK_CONSTRAINTS

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
TABLE_NAME varchar(64) No
CHECK_CLAUSE varchar(64) No

CLIENT_STATISTICS

Column Type Null Default Comments
CLIENT varchar(64) No
TOTAL_CONNECTIONS bigint(21) No 0
CONCURRENT_CONNECTIONS bigint(21) No 0
CONNECTED_TIME bigint(21) No 0
BUSY_TIME double No 0
CPU_TIME double No 0
BYTES_RECEIVED bigint(21) No 0
BYTES_SENT bigint(21) No 0
BINLOG_BYTES_WRITTEN bigint(21) No 0
ROWS_READ bigint(21) No 0
ROWS_SENT bigint(21) No 0
ROWS_DELETED bigint(21) No 0
ROWS_INSERTED bigint(21) No 0
ROWS_UPDATED bigint(21) No 0
SELECT_COMMANDS bigint(21) No 0
UPDATE_COMMANDS bigint(21) No 0
OTHER_COMMANDS bigint(21) No 0
COMMIT_TRANSACTIONS bigint(21) No 0
ROLLBACK_TRANSACTIONS bigint(21) No 0
DENIED_CONNECTIONS bigint(21) No 0
LOST_CONNECTIONS bigint(21) No 0
ACCESS_DENIED bigint(21) No 0
EMPTY_QUERIES bigint(21) No 0
TOTAL_SSL_CONNECTIONS bigint(21) No 0
MAX_STATEMENT_TIME_EXCEEDED bigint(21) No 0

COLLATIONS

Column Type Null Default Comments
COLLATION_NAME varchar(32) No
CHARACTER_SET_NAME varchar(32) No
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 Comments
COLLATION_NAME varchar(32) No
CHARACTER_SET_NAME varchar(32) No

COLUMNS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
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
COLLATION_NAME varchar(32) Yes NULL
COLUMN_TYPE longtext No
COLUMN_KEY varchar(3) No
EXTRA varchar(30) No
PRIVILEGES varchar(80) No
COLUMN_COMMENT varchar(1024) No
IS_GENERATED varchar(6) No
GENERATION_EXPRESSION longtext Yes NULL

COLUMN_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(190) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

ENABLED_ROLES

Column Type Null Default Comments
ROLE_NAME varchar(128) Yes NULL

ENGINES

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

EVENTS

Column Type Null Default Comments
EVENT_CATALOG varchar(64) No
EVENT_SCHEMA varchar(64) No
EVENT_NAME varchar(64) No
DEFINER varchar(189) 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
COLLATION_CONNECTION varchar(32) No
DATABASE_COLLATION varchar(32) No

FILES

Column Type Null Default Comments
FILE_ID bigint(4) No 0
FILE_NAME varchar(512) Yes NULL
FILE_TYPE varchar(20) No
TABLESPACE_NAME varchar(64) Yes NULL
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) Yes NULL
TABLE_NAME varchar(64) Yes NULL
LOGFILE_GROUP_NAME varchar(64) Yes NULL
LOGFILE_GROUP_NUMBER bigint(4) Yes NULL
ENGINE varchar(64) No
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

GEOMETRY_COLUMNS

Column Type Null Default Comments
F_TABLE_CATALOG varchar(512) No
F_TABLE_SCHEMA varchar(64) No
F_TABLE_NAME varchar(64) No
F_GEOMETRY_COLUMN varchar(64) No
G_TABLE_CATALOG varchar(512) No
G_TABLE_SCHEMA varchar(64) No
G_TABLE_NAME varchar(64) No
G_GEOMETRY_COLUMN varchar(64) No
STORAGE_TYPE tinyint(2) No 0
GEOMETRY_TYPE int(7) No 0
COORD_DIMENSION tinyint(2) No 0
MAX_PPR tinyint(2) No 0
SRID smallint(5) No 0

GLOBAL_STATUS

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(2048) No

GLOBAL_VARIABLES

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(2048) No

INDEX_STATISTICS

Column Type Null Default Comments
TABLE_SCHEMA varchar(192) No
TABLE_NAME varchar(192) No
INDEX_NAME varchar(192) No
ROWS_READ bigint(21) No 0

INNODB_BUFFER_PAGE

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

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

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

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

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

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

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

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

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

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

INNODB_FT_CONFIG

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

INNODB_FT_DEFAULT_STOPWORD

Column Type Null Default Comments
value varchar(18) No

INNODB_FT_DELETED

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

INNODB_FT_INDEX_CACHE

Column Type Null Default Comments
WORD varchar(337) 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_INDEX_TABLE

Column Type Null Default Comments
WORD varchar(337) 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_LOCKS

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

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

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

Column Type Null Default Comments
NAME varchar(4000) No
CREATE_FILE varchar(4000) No
CREATE_LINE int(11) No 0
OS_WAITS bigint(21) No 0

INNODB_SYS_COLUMNS

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

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

INNODB_SYS_FIELDS

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

INNODB_SYS_FOREIGN

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

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

INNODB_SYS_INDEXES

Column Type Null Default Comments
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
MERGE_THRESHOLD int(11) No 0

INNODB_SYS_SEMAPHORE_WAITS

Column Type Null Default Comments
THREAD_ID bigint(21) No 0
OBJECT_NAME varchar(4000) Yes NULL
FILE varchar(4000) Yes NULL
LINE int(11) No 0
WAIT_TIME bigint(21) No 0
WAIT_OBJECT bigint(21) No 0
WAIT_TYPE varchar(16) Yes NULL
HOLDER_THREAD_ID bigint(21) No 0
HOLDER_FILE varchar(4000) Yes NULL
HOLDER_LINE int(11) No 0
CREATED_FILE varchar(4000) Yes NULL
CREATED_LINE int(11) No 0
WRITER_THREAD bigint(21) No 0
RESERVATION_MODE varchar(16) Yes NULL
READERS int(11) No 0
WAITERS_FLAG bigint(21) No 0
LOCK_WORD bigint(21) No 0
LAST_WRITER_FILE varchar(4000) Yes NULL
LAST_WRITER_LINE int(11) No 0
OS_WAIT_COUNT int(11) No 0

INNODB_SYS_TABLES

Column Type Null Default Comments
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
ROW_FORMAT varchar(12) Yes NULL
ZIP_PAGE_SIZE int(11) No 0
SPACE_TYPE varchar(10) Yes NULL

INNODB_SYS_TABLESPACES

Column Type Null Default Comments
SPACE int(11) No 0
NAME varchar(655) No
FLAG int(11) No 0
ROW_FORMAT varchar(22) Yes NULL
PAGE_SIZE int(11) No 0
ZIP_PAGE_SIZE int(11) No 0
SPACE_TYPE varchar(10) Yes NULL
FS_BLOCK_SIZE int(11) No 0
FILE_SIZE bigint(21) No 0
ALLOCATED_SIZE bigint(21) No 0

INNODB_SYS_TABLESTATS

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

Column Type Null Default Comments
TABLE_ID bigint(21) No 0
POS int(11) No 0
BASE_POS int(11) No 0

INNODB_TABLESPACES_ENCRYPTION

Column Type Null Default Comments
SPACE int(11) No 0
NAME varchar(655) Yes NULL
ENCRYPTION_SCHEME int(11) No 0
KEYSERVER_REQUESTS int(11) No 0
MIN_KEY_VERSION int(11) No 0
CURRENT_KEY_VERSION int(11) No 0
KEY_ROTATION_PAGE_NUMBER bigint(21) Yes NULL
KEY_ROTATION_MAX_PAGE_NUMBER bigint(21) Yes NULL
CURRENT_KEY_ID int(11) No 0
ROTATING_OR_FLUSHING int(1) No 0

INNODB_TABLESPACES_SCRUBBING

Column Type Null Default Comments
SPACE bigint(21) No 0
NAME varchar(655) Yes NULL
COMPRESSED int(1) No 0
LAST_SCRUB_COMPLETED datetime Yes NULL
CURRENT_SCRUB_STARTED datetime Yes NULL
CURRENT_SCRUB_ACTIVE_THREADS int(11) Yes NULL
CURRENT_SCRUB_PAGE_NUMBER bigint(21) No 0
CURRENT_SCRUB_MAX_PAGE_NUMBER bigint(21) No 0
ON_SSD int(1) No 0

INNODB_TRX

Column Type Null Default Comments
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_is_read_only int(1) No 0
trx_autocommit_non_locking int(1) No 0

KEY_CACHES

Column Type Null Default Comments
KEY_CACHE_NAME varchar(192) No
SEGMENTS int(3) Yes NULL
SEGMENT_NUMBER int(3) Yes NULL
FULL_SIZE bigint(21) No 0
BLOCK_SIZE bigint(21) No 0
USED_BLOCKS bigint(21) No 0
UNUSED_BLOCKS bigint(21) No 0
DIRTY_BLOCKS bigint(21) No 0
READ_REQUESTS bigint(21) No 0
READS bigint(21) No 0
WRITE_REQUESTS bigint(21) No 0
WRITES bigint(21) No 0

KEY_COLUMN_USAGE

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
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
REFERENCED_TABLE_NAME varchar(64) Yes NULL
REFERENCED_COLUMN_NAME varchar(64) Yes NULL

OPTIMIZER_TRACE

Column Type Null Default Comments
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 Comments
SPECIFIC_CATALOG varchar(512) No
SPECIFIC_SCHEMA varchar(64) No
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 int(21) Yes NULL
NUMERIC_SCALE int(21) Yes NULL
DATETIME_PRECISION bigint(21) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
DTD_IDENTIFIER longtext No
ROUTINE_TYPE varchar(9) No

PARTITIONS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
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

PLUGINS

Column Type Null Default Comments
PLUGIN_NAME varchar(64) No
PLUGIN_VERSION varchar(20) No
PLUGIN_STATUS varchar(16) 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) No
LOAD_OPTION varchar(64) No
PLUGIN_MATURITY varchar(12) No
PLUGIN_AUTH_VERSION varchar(80) Yes NULL

PROCESSLIST

Column Type Null Default Comments
ID bigint(4) No 0
USER varchar(128) No
HOST varchar(64) No
DB varchar(64) Yes NULL
COMMAND varchar(16) No
TIME int(7) No 0
STATE varchar(64) Yes NULL
INFO longtext Yes NULL
TIME_MS decimal(22,3) No 0.000
STAGE tinyint(2) No 0
MAX_STAGE tinyint(2) No 0
PROGRESS decimal(7,3) No 0.000
MEMORY_USED bigint(7) No 0
MAX_MEMORY_USED bigint(7) No 0
EXAMINED_ROWS int(7) No 0
QUERY_ID bigint(4) No 0
INFO_BINARY blob Yes NULL
TID bigint(4) No 0

PROFILING

Column Type Null Default Comments
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 Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
UNIQUE_CONSTRAINT_CATALOG varchar(512) No
UNIQUE_CONSTRAINT_SCHEMA varchar(64) No
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 Comments
SPECIFIC_NAME varchar(64) No
ROUTINE_CATALOG varchar(512) No
ROUTINE_SCHEMA varchar(64) No
ROUTINE_NAME varchar(64) No
ROUTINE_TYPE varchar(13) No
DATA_TYPE varchar(64) No
CHARACTER_MAXIMUM_LENGTH int(21) Yes NULL
CHARACTER_OCTET_LENGTH int(21) Yes NULL
NUMERIC_PRECISION int(21) Yes NULL
NUMERIC_SCALE int(21) Yes NULL
DATETIME_PRECISION bigint(21) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
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(189) No
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No
DATABASE_COLLATION varchar(32) No

SCHEMATA

Column Type Null Default Comments
CATALOG_NAME varchar(512) No
SCHEMA_NAME varchar(64) No
DEFAULT_CHARACTER_SET_NAME varchar(32) No
DEFAULT_COLLATION_NAME varchar(32) No
SQL_PATH varchar(512) Yes NULL

SCHEMA_PRIVILEGES

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

SESSION_STATUS

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(2048) No

SESSION_VARIABLES

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(2048) No

SPATIAL_REF_SYS

Column Type Null Default Comments
SRID smallint(5) No 0
AUTH_NAME varchar(512) No
AUTH_SRID int(5) No 0
SRTEXT varchar(2048) No

STATISTICS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
NON_UNIQUE bigint(1) No 0
INDEX_SCHEMA varchar(64) No
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

SYSTEM_VARIABLES

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
SESSION_VALUE varchar(2048) Yes NULL
GLOBAL_VALUE varchar(2048) Yes NULL
GLOBAL_VALUE_ORIGIN varchar(64) No
DEFAULT_VALUE varchar(2048) Yes NULL
VARIABLE_SCOPE varchar(64) No
VARIABLE_TYPE varchar(64) No
VARIABLE_COMMENT varchar(2048) No
NUMERIC_MIN_VALUE varchar(21) Yes NULL
NUMERIC_MAX_VALUE varchar(21) Yes NULL
NUMERIC_BLOCK_SIZE varchar(21) Yes NULL
ENUM_VALUE_LIST longtext Yes NULL
READ_ONLY varchar(3) No
COMMAND_LINE_ARGUMENT varchar(64) Yes NULL

TABLES

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
TABLE_TYPE varchar(64) No
ENGINE varchar(64) 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
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
CHECKSUM bigint(21) Yes NULL
CREATE_OPTIONS varchar(2048) Yes NULL
TABLE_COMMENT varchar(2048) No
MAX_INDEX_LENGTH bigint(21) Yes NULL
TEMPORARY varchar(1) Yes NULL

TABLESPACES

Column Type Null Default Comments
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 Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
CONSTRAINT_TYPE varchar(64) No

TABLE_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(190) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

TABLE_STATISTICS

Column Type Null Default Comments
TABLE_SCHEMA varchar(192) No
TABLE_NAME varchar(192) No
ROWS_READ bigint(21) No 0
ROWS_CHANGED bigint(21) No 0
ROWS_CHANGED_X_INDEXES bigint(21) No 0

TRIGGERS

Column Type Null Default Comments
TRIGGER_CATALOG varchar(512) No
TRIGGER_SCHEMA varchar(64) No
TRIGGER_NAME varchar(64) No
EVENT_MANIPULATION varchar(6) No
EVENT_OBJECT_CATALOG varchar(512) No
EVENT_OBJECT_SCHEMA varchar(64) No
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(2) Yes NULL
SQL_MODE varchar(8192) No
DEFINER varchar(189) No
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No
DATABASE_COLLATION varchar(32) No

USER_PRIVILEGES

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

USER_STATISTICS

Column Type Null Default Comments
USER varchar(128) No
TOTAL_CONNECTIONS int(11) No 0
CONCURRENT_CONNECTIONS int(11) No 0
CONNECTED_TIME int(11) No 0
BUSY_TIME double No 0
CPU_TIME double No 0
BYTES_RECEIVED bigint(21) No 0
BYTES_SENT bigint(21) No 0
BINLOG_BYTES_WRITTEN bigint(21) No 0
ROWS_READ bigint(21) No 0
ROWS_SENT bigint(21) No 0
ROWS_DELETED bigint(21) No 0
ROWS_INSERTED bigint(21) No 0
ROWS_UPDATED bigint(21) No 0
SELECT_COMMANDS bigint(21) No 0
UPDATE_COMMANDS bigint(21) No 0
OTHER_COMMANDS bigint(21) No 0
COMMIT_TRANSACTIONS bigint(21) No 0
ROLLBACK_TRANSACTIONS bigint(21) No 0
DENIED_CONNECTIONS bigint(21) No 0
LOST_CONNECTIONS bigint(21) No 0
ACCESS_DENIED bigint(21) No 0
EMPTY_QUERIES bigint(21) No 0
TOTAL_SSL_CONNECTIONS bigint(21) No 0
MAX_STATEMENT_TIME_EXCEEDED bigint(21) No 0

user_variables

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(2048) Yes NULL
VARIABLE_TYPE varchar(64) No
CHARACTER_SET_NAME varchar(32) Yes NULL

VIEWS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
VIEW_DEFINITION longtext No
CHECK_OPTION varchar(8) No
IS_UPDATABLE varchar(3) No
DEFINER varchar(189) No
SECURITY_TYPE varchar(7) No
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No
ALGORITHM varchar(10) No