ALL_PLUGINS

ColumnTypeNullDefault Links to Comments MIME
PLUGIN_NAMEvarchar(64)No
PLUGIN_VERSIONvarchar(20)No
PLUGIN_STATUSvarchar(16)No
PLUGIN_TYPEvarchar(80)No
PLUGIN_TYPE_VERSIONvarchar(20)No
PLUGIN_LIBRARYvarchar(64)YesNULL
PLUGIN_LIBRARY_VERSIONvarchar(20)YesNULL
PLUGIN_AUTHORvarchar(64)YesNULL
PLUGIN_DESCRIPTIONlongtextYesNULL
PLUGIN_LICENSEvarchar(80)No
LOAD_OPTIONvarchar(64)No
PLUGIN_MATURITYvarchar(12)No
PLUGIN_AUTH_VERSIONvarchar(80)YesNULL

APPLICABLE_ROLES

ColumnTypeNullDefault Links to Comments MIME
GRANTEEvarchar(190)No
ROLE_NAMEvarchar(128)No
IS_GRANTABLEvarchar(3)No
IS_DEFAULTvarchar(3)YesNULL

CHARACTER_SETS

ColumnTypeNullDefault Links to Comments MIME
CHARACTER_SET_NAMEvarchar(32)No
DEFAULT_COLLATE_NAMEvarchar(32)No COLLATIONS -> COLLATION_NAME
DESCRIPTIONvarchar(60)No
MAXLENbigint(3)No0

COLLATIONS

ColumnTypeNullDefault Links to Comments MIME
COLLATION_NAMEvarchar(32)No
CHARACTER_SET_NAMEvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME
IDbigint(11)No0
IS_DEFAULTvarchar(3)No
IS_COMPILEDvarchar(3)No
SORTLENbigint(3)No0

COLLATION_CHARACTER_SET_APPLICABILITY

ColumnTypeNullDefault Links to Comments MIME
COLLATION_NAMEvarchar(32)No COLLATIONS -> COLLATION_NAME
CHARACTER_SET_NAMEvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME

COLUMNS

ColumnTypeNullDefault Links to Comments MIME
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
COLUMN_NAMEvarchar(64)No
ORDINAL_POSITIONbigint(21)No0
COLUMN_DEFAULTlongtextYesNULL
IS_NULLABLEvarchar(3)No
DATA_TYPEvarchar(64)No
CHARACTER_MAXIMUM_LENGTHbigint(21)YesNULL
CHARACTER_OCTET_LENGTHbigint(21)YesNULL
NUMERIC_PRECISIONbigint(21)YesNULL
NUMERIC_SCALEbigint(21)YesNULL
DATETIME_PRECISIONbigint(21)YesNULL
CHARACTER_SET_NAMEvarchar(32)YesNULL CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAMEvarchar(32)YesNULL COLLATIONS -> COLLATION_NAME
COLUMN_TYPElongtextNo
COLUMN_KEYvarchar(3)No
EXTRAvarchar(27)No
PRIVILEGESvarchar(80)No
COLUMN_COMMENTvarchar(1024)No

COLUMN_PRIVILEGES

ColumnTypeNullDefault Links to Comments MIME
GRANTEEvarchar(190)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
COLUMN_NAMEvarchar(64)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

ENABLED_ROLES

ColumnTypeNullDefault Links to Comments MIME
ROLE_NAMEvarchar(128)YesNULL

ENGINES

ColumnTypeNullDefault Links to Comments MIME
ENGINEvarchar(64)No
SUPPORTvarchar(8)No
COMMENTvarchar(160)No
TRANSACTIONSvarchar(3)YesNULL
XAvarchar(3)YesNULL
SAVEPOINTSvarchar(3)YesNULL

EVENTS

ColumnTypeNullDefault Links to Comments MIME
EVENT_CATALOGvarchar(64)No
EVENT_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
EVENT_NAMEvarchar(64)No
DEFINERvarchar(189)No
TIME_ZONEvarchar(64)No
EVENT_BODYvarchar(8)No
EVENT_DEFINITIONlongtextNo
EVENT_TYPEvarchar(9)No
EXECUTE_ATdatetimeYesNULL
INTERVAL_VALUEvarchar(256)YesNULL
INTERVAL_FIELDvarchar(18)YesNULL
SQL_MODEvarchar(8192)No
STARTSdatetimeYesNULL
ENDSdatetimeYesNULL
STATUSvarchar(18)No
ON_COMPLETIONvarchar(12)No
CREATEDdatetimeNo0000-00-00 00:00:00
LAST_ALTEREDdatetimeNo0000-00-00 00:00:00
LAST_EXECUTEDdatetimeYesNULL
EVENT_COMMENTvarchar(64)No
ORIGINATORbigint(10)No0
CHARACTER_SET_CLIENTvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32)No COLLATIONS -> COLLATION_NAME
DATABASE_COLLATIONvarchar(32)No COLLATIONS -> COLLATION_NAME

FILES

ColumnTypeNullDefault Links to Comments MIME
FILE_IDbigint(4)No0
FILE_NAMEvarchar(64)YesNULL
FILE_TYPEvarchar(20)No
TABLESPACE_NAMEvarchar(64)YesNULL TABLESPACES -> TABLESPACE_NAME
TABLE_CATALOGvarchar(64)No
TABLE_SCHEMAvarchar(64)YesNULL SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)YesNULL
LOGFILE_GROUP_NAMEvarchar(64)YesNULL
LOGFILE_GROUP_NUMBERbigint(4)YesNULL
ENGINEvarchar(64)No ENGINES -> ENGINE
FULLTEXT_KEYSvarchar(64)YesNULL
DELETED_ROWSbigint(4)YesNULL
UPDATE_COUNTbigint(4)YesNULL
FREE_EXTENTSbigint(4)YesNULL
TOTAL_EXTENTSbigint(4)YesNULL
EXTENT_SIZEbigint(4)No0
INITIAL_SIZEbigint(21)YesNULL
MAXIMUM_SIZEbigint(21)YesNULL
AUTOEXTEND_SIZEbigint(21)YesNULL
CREATION_TIMEdatetimeYesNULL
LAST_UPDATE_TIMEdatetimeYesNULL
LAST_ACCESS_TIMEdatetimeYesNULL
RECOVER_TIMEbigint(4)YesNULL
TRANSACTION_COUNTERbigint(4)YesNULL
VERSIONbigint(21)YesNULL
ROW_FORMATvarchar(10)YesNULL
TABLE_ROWSbigint(21)YesNULL
AVG_ROW_LENGTHbigint(21)YesNULL
DATA_LENGTHbigint(21)YesNULL
MAX_DATA_LENGTHbigint(21)YesNULL
INDEX_LENGTHbigint(21)YesNULL
DATA_FREEbigint(21)YesNULL
CREATE_TIMEdatetimeYesNULL
UPDATE_TIMEdatetimeYesNULL
CHECK_TIMEdatetimeYesNULL
CHECKSUMbigint(21)YesNULL
STATUSvarchar(20)No
EXTRAvarchar(255)YesNULL

GLOBAL_STATUS

ColumnTypeNullDefault Links to Comments MIME
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(2048)No

GLOBAL_VARIABLES

ColumnTypeNullDefault Links to Comments MIME
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(2048)No

KEY_CACHES

ColumnTypeNullDefault Links to Comments MIME
KEY_CACHE_NAMEvarchar(192)No
SEGMENTSint(3)YesNULL
SEGMENT_NUMBERint(3)YesNULL
FULL_SIZEbigint(21)No0
BLOCK_SIZEbigint(21)No0
USED_BLOCKSbigint(21)No0
UNUSED_BLOCKSbigint(21)No0
DIRTY_BLOCKSbigint(21)No0
READ_REQUESTSbigint(21)No0
READSbigint(21)No0
WRITE_REQUESTSbigint(21)No0
WRITESbigint(21)No0

KEY_COLUMN_USAGE

ColumnTypeNullDefault Links to Comments MIME
CONSTRAINT_CATALOGvarchar(512)No
CONSTRAINT_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAMEvarchar(64)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
COLUMN_NAMEvarchar(64)No
ORDINAL_POSITIONbigint(10)No0
POSITION_IN_UNIQUE_CONSTRAINTbigint(10)YesNULL
REFERENCED_TABLE_SCHEMAvarchar(64)YesNULL SCHEMATA -> SCHEMA_NAME
REFERENCED_TABLE_NAMEvarchar(64)YesNULL
REFERENCED_COLUMN_NAMEvarchar(64)YesNULL

PARAMETERS

ColumnTypeNullDefault Links to Comments MIME
SPECIFIC_CATALOGvarchar(512)No
SPECIFIC_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
SPECIFIC_NAMEvarchar(64)No
ORDINAL_POSITIONint(21)No0
PARAMETER_MODEvarchar(5)YesNULL
PARAMETER_NAMEvarchar(64)YesNULL
DATA_TYPEvarchar(64)No
CHARACTER_MAXIMUM_LENGTHint(21)YesNULL
CHARACTER_OCTET_LENGTHint(21)YesNULL
NUMERIC_PRECISIONint(21)YesNULL
NUMERIC_SCALEint(21)YesNULL
DATETIME_PRECISIONbigint(21)YesNULL
CHARACTER_SET_NAMEvarchar(64)YesNULL CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAMEvarchar(64)YesNULL COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIERlongtextNo
ROUTINE_TYPEvarchar(9)No

PARTITIONS

ColumnTypeNullDefault Links to Comments MIME
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
PARTITION_NAMEvarchar(64)YesNULL
SUBPARTITION_NAMEvarchar(64)YesNULL
PARTITION_ORDINAL_POSITIONbigint(21)YesNULL
SUBPARTITION_ORDINAL_POSITIONbigint(21)YesNULL
PARTITION_METHODvarchar(18)YesNULL
SUBPARTITION_METHODvarchar(12)YesNULL
PARTITION_EXPRESSIONlongtextYesNULL
SUBPARTITION_EXPRESSIONlongtextYesNULL
PARTITION_DESCRIPTIONlongtextYesNULL
TABLE_ROWSbigint(21)No0
AVG_ROW_LENGTHbigint(21)No0
DATA_LENGTHbigint(21)No0
MAX_DATA_LENGTHbigint(21)YesNULL
INDEX_LENGTHbigint(21)No0
DATA_FREEbigint(21)No0
CREATE_TIMEdatetimeYesNULL
UPDATE_TIMEdatetimeYesNULL
CHECK_TIMEdatetimeYesNULL
CHECKSUMbigint(21)YesNULL
PARTITION_COMMENTvarchar(80)No
NODEGROUPvarchar(12)No
TABLESPACE_NAMEvarchar(64)YesNULL TABLESPACES -> TABLESPACE_NAME

PLUGINS

ColumnTypeNullDefault Links to Comments MIME
PLUGIN_NAMEvarchar(64)No
PLUGIN_VERSIONvarchar(20)No
PLUGIN_STATUSvarchar(16)No
PLUGIN_TYPEvarchar(80)No
PLUGIN_TYPE_VERSIONvarchar(20)No
PLUGIN_LIBRARYvarchar(64)YesNULL
PLUGIN_LIBRARY_VERSIONvarchar(20)YesNULL
PLUGIN_AUTHORvarchar(64)YesNULL
PLUGIN_DESCRIPTIONlongtextYesNULL
PLUGIN_LICENSEvarchar(80)No
LOAD_OPTIONvarchar(64)No
PLUGIN_MATURITYvarchar(12)No
PLUGIN_AUTH_VERSIONvarchar(80)YesNULL

PROCESSLIST

ColumnTypeNullDefault Links to Comments MIME
IDbigint(4)No0
USERvarchar(128)No
HOSTvarchar(64)No
DBvarchar(64)YesNULL SCHEMATA -> SCHEMA_NAME
COMMANDvarchar(16)No
TIMEint(7)No0
STATEvarchar(64)YesNULL
INFOlongtextYesNULL
TIME_MSdecimal(22,3)No0.000
STAGEtinyint(2)No0
MAX_STAGEtinyint(2)No0
PROGRESSdecimal(7,3)No0.000
MEMORY_USEDint(7)No0
EXAMINED_ROWSint(7)No0
QUERY_IDbigint(4)No0
INFO_BINARYblobYesNULL
TIDbigint(4)No0

PROFILING

ColumnTypeNullDefault Links to Comments MIME
QUERY_IDint(20)No0
SEQint(20)No0
STATEvarchar(30)No
DURATIONdecimal(9,6)No0.000000
CPU_USERdecimal(9,6)YesNULL
CPU_SYSTEMdecimal(9,6)YesNULL
CONTEXT_VOLUNTARYint(20)YesNULL
CONTEXT_INVOLUNTARYint(20)YesNULL
BLOCK_OPS_INint(20)YesNULL
BLOCK_OPS_OUTint(20)YesNULL
MESSAGES_SENTint(20)YesNULL
MESSAGES_RECEIVEDint(20)YesNULL
PAGE_FAULTS_MAJORint(20)YesNULL
PAGE_FAULTS_MINORint(20)YesNULL
SWAPSint(20)YesNULL
SOURCE_FUNCTIONvarchar(30)YesNULL
SOURCE_FILEvarchar(20)YesNULL
SOURCE_LINEint(20)YesNULL

REFERENTIAL_CONSTRAINTS

ColumnTypeNullDefault Links to Comments MIME
CONSTRAINT_CATALOGvarchar(512)No
CONSTRAINT_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAMEvarchar(64)No
UNIQUE_CONSTRAINT_CATALOGvarchar(512)No
UNIQUE_CONSTRAINT_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
UNIQUE_CONSTRAINT_NAMEvarchar(64)YesNULL
MATCH_OPTIONvarchar(64)No
UPDATE_RULEvarchar(64)No
DELETE_RULEvarchar(64)No
TABLE_NAMEvarchar(64)No
REFERENCED_TABLE_NAMEvarchar(64)No

ROUTINES

ColumnTypeNullDefault Links to Comments MIME
SPECIFIC_NAMEvarchar(64)No
ROUTINE_CATALOGvarchar(512)No
ROUTINE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
ROUTINE_NAMEvarchar(64)No
ROUTINE_TYPEvarchar(9)No
DATA_TYPEvarchar(64)No
CHARACTER_MAXIMUM_LENGTHint(21)YesNULL
CHARACTER_OCTET_LENGTHint(21)YesNULL
NUMERIC_PRECISIONint(21)YesNULL
NUMERIC_SCALEint(21)YesNULL
DATETIME_PRECISIONbigint(21)YesNULL
CHARACTER_SET_NAMEvarchar(64)YesNULL CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAMEvarchar(64)YesNULL COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIERlongtextYesNULL
ROUTINE_BODYvarchar(8)No
ROUTINE_DEFINITIONlongtextYesNULL
EXTERNAL_NAMEvarchar(64)YesNULL
EXTERNAL_LANGUAGEvarchar(64)YesNULL
PARAMETER_STYLEvarchar(8)No
IS_DETERMINISTICvarchar(3)No
SQL_DATA_ACCESSvarchar(64)No
SQL_PATHvarchar(64)YesNULL
SECURITY_TYPEvarchar(7)No
CREATEDdatetimeNo0000-00-00 00:00:00
LAST_ALTEREDdatetimeNo0000-00-00 00:00:00
SQL_MODEvarchar(8192)No
ROUTINE_COMMENTlongtextNo
DEFINERvarchar(189)No
CHARACTER_SET_CLIENTvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32)No COLLATIONS -> COLLATION_NAME
DATABASE_COLLATIONvarchar(32)No COLLATIONS -> COLLATION_NAME

SCHEMATA

ColumnTypeNullDefault Links to Comments MIME
CATALOG_NAMEvarchar(512)No
SCHEMA_NAMEvarchar(64)No
DEFAULT_CHARACTER_SET_NAMEvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME
DEFAULT_COLLATION_NAMEvarchar(32)No COLLATIONS -> COLLATION_NAME
SQL_PATHvarchar(512)YesNULL

SCHEMA_PRIVILEGES

ColumnTypeNullDefault Links to Comments MIME
GRANTEEvarchar(190)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

SESSION_STATUS

ColumnTypeNullDefault Links to Comments MIME
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(2048)No

SESSION_VARIABLES

ColumnTypeNullDefault Links to Comments MIME
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(2048)No

STATISTICS

ColumnTypeNullDefault Links to Comments MIME
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
NON_UNIQUEbigint(1)No0
INDEX_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
INDEX_NAMEvarchar(64)No
SEQ_IN_INDEXbigint(2)No0
COLUMN_NAMEvarchar(64)No
COLLATIONvarchar(1)YesNULL
CARDINALITYbigint(21)YesNULL
SUB_PARTbigint(3)YesNULL
PACKEDvarchar(10)YesNULL
NULLABLEvarchar(3)No
INDEX_TYPEvarchar(16)No
COMMENTvarchar(16)YesNULL
INDEX_COMMENTvarchar(1024)No

SYSTEM_VARIABLES

ColumnTypeNullDefault Links to Comments MIME
VARIABLE_NAMEvarchar(64)No
SESSION_VALUEvarchar(2048)YesNULL
GLOBAL_VALUEvarchar(2048)YesNULL
GLOBAL_VALUE_ORIGINvarchar(64)No
DEFAULT_VALUEvarchar(2048)YesNULL
VARIABLE_SCOPEvarchar(64)No
VARIABLE_TYPEvarchar(64)No
VARIABLE_COMMENTvarchar(2048)No
NUMERIC_MIN_VALUEvarchar(21)YesNULL
NUMERIC_MAX_VALUEvarchar(21)YesNULL
NUMERIC_BLOCK_SIZEvarchar(21)YesNULL
ENUM_VALUE_LISTlongtextYesNULL
READ_ONLYvarchar(3)No
COMMAND_LINE_ARGUMENTvarchar(64)YesNULL

TABLES

ColumnTypeNullDefault Links to Comments MIME
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
TABLE_TYPEvarchar(64)No
ENGINEvarchar(64)YesNULL ENGINES -> ENGINE
VERSIONbigint(21)YesNULL
ROW_FORMATvarchar(10)YesNULL
TABLE_ROWSbigint(21)YesNULL
AVG_ROW_LENGTHbigint(21)YesNULL
DATA_LENGTHbigint(21)YesNULL
MAX_DATA_LENGTHbigint(21)YesNULL
INDEX_LENGTHbigint(21)YesNULL
DATA_FREEbigint(21)YesNULL
AUTO_INCREMENTbigint(21)YesNULL
CREATE_TIMEdatetimeYesNULL
UPDATE_TIMEdatetimeYesNULL
CHECK_TIMEdatetimeYesNULL
TABLE_COLLATIONvarchar(32)YesNULL COLLATIONS -> COLLATION_NAME
CHECKSUMbigint(21)YesNULL
CREATE_OPTIONSvarchar(2048)YesNULL
TABLE_COMMENTvarchar(2048)No

TABLESPACES

ColumnTypeNullDefault Links to Comments MIME
TABLESPACE_NAMEvarchar(64)No
ENGINEvarchar(64)No
TABLESPACE_TYPEvarchar(64)YesNULL
LOGFILE_GROUP_NAMEvarchar(64)YesNULL
EXTENT_SIZEbigint(21)YesNULL
AUTOEXTEND_SIZEbigint(21)YesNULL
MAXIMUM_SIZEbigint(21)YesNULL
NODEGROUP_IDbigint(21)YesNULL
TABLESPACE_COMMENTvarchar(2048)YesNULL

TABLE_CONSTRAINTS

ColumnTypeNullDefault Links to Comments MIME
CONSTRAINT_CATALOGvarchar(512)No
CONSTRAINT_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAMEvarchar(64)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
CONSTRAINT_TYPEvarchar(64)No

TABLE_PRIVILEGES

ColumnTypeNullDefault Links to Comments MIME
GRANTEEvarchar(190)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

TRIGGERS

ColumnTypeNullDefault Links to Comments MIME
TRIGGER_CATALOGvarchar(512)No
TRIGGER_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TRIGGER_NAMEvarchar(64)No
EVENT_MANIPULATIONvarchar(6)No
EVENT_OBJECT_CATALOGvarchar(512)No
EVENT_OBJECT_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
EVENT_OBJECT_TABLEvarchar(64)No
ACTION_ORDERbigint(4)No0
ACTION_CONDITIONlongtextYesNULL
ACTION_STATEMENTlongtextNo
ACTION_ORIENTATIONvarchar(9)No
ACTION_TIMINGvarchar(6)No
ACTION_REFERENCE_OLD_TABLEvarchar(64)YesNULL
ACTION_REFERENCE_NEW_TABLEvarchar(64)YesNULL
ACTION_REFERENCE_OLD_ROWvarchar(3)No
ACTION_REFERENCE_NEW_ROWvarchar(3)No
CREATEDdatetimeYesNULL
SQL_MODEvarchar(8192)No
DEFINERvarchar(189)No
CHARACTER_SET_CLIENTvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32)No COLLATIONS -> COLLATION_NAME
DATABASE_COLLATIONvarchar(32)No COLLATIONS -> COLLATION_NAME

USER_PRIVILEGES

ColumnTypeNullDefault Links to Comments MIME
GRANTEEvarchar(190)No
TABLE_CATALOGvarchar(512)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

VIEWS

ColumnTypeNullDefault Links to Comments MIME
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)No
VIEW_DEFINITIONlongtextNo
CHECK_OPTIONvarchar(8)No
IS_UPDATABLEvarchar(3)No
DEFINERvarchar(189)No
SECURITY_TYPEvarchar(7)No
CHARACTER_SET_CLIENTvarchar(32)No CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32)No COLLATIONS -> COLLATION_NAME
ALGORITHMvarchar(10)No

GEOMETRY_COLUMNS

ColumnTypeNullDefault Links to Comments MIME
F_TABLE_CATALOGvarchar(512)No
F_TABLE_SCHEMAvarchar(64)No
F_TABLE_NAMEvarchar(64)No
F_GEOMETRY_COLUMNvarchar(64)No
G_TABLE_CATALOGvarchar(512)No
G_TABLE_SCHEMAvarchar(64)No
G_TABLE_NAMEvarchar(64)No
G_GEOMETRY_COLUMNvarchar(64)No
STORAGE_TYPEtinyint(2)No0
GEOMETRY_TYPEint(7)No0
COORD_DIMENSIONtinyint(2)No0
MAX_PPRtinyint(2)No0
SRIDsmallint(5)No0

SPATIAL_REF_SYS

ColumnTypeNullDefault Links to Comments MIME
SRIDsmallint(5)No0
AUTH_NAMEvarchar(512)No
AUTH_SRIDint(5)No0
SRTEXTvarchar(2048)No

CLIENT_STATISTICS

ColumnTypeNullDefault Links to Comments MIME
CLIENTvarchar(64)No
TOTAL_CONNECTIONSbigint(21)No0
CONCURRENT_CONNECTIONSbigint(21)No0
CONNECTED_TIMEbigint(21)No0
BUSY_TIMEdoubleNo0
CPU_TIMEdoubleNo0
BYTES_RECEIVEDbigint(21)No0
BYTES_SENTbigint(21)No0
BINLOG_BYTES_WRITTENbigint(21)No0
ROWS_READbigint(21)No0
ROWS_SENTbigint(21)No0
ROWS_DELETEDbigint(21)No0
ROWS_INSERTEDbigint(21)No0
ROWS_UPDATEDbigint(21)No0
SELECT_COMMANDSbigint(21)No0
UPDATE_COMMANDSbigint(21)No0
OTHER_COMMANDSbigint(21)No0
COMMIT_TRANSACTIONSbigint(21)No0
ROLLBACK_TRANSACTIONSbigint(21)No0
DENIED_CONNECTIONSbigint(21)No0
LOST_CONNECTIONSbigint(21)No0
ACCESS_DENIEDbigint(21)No0
EMPTY_QUERIESbigint(21)No0
TOTAL_SSL_CONNECTIONSbigint(21)No0
MAX_STATEMENT_TIME_EXCEEDEDbigint(21)No0

INDEX_STATISTICS

ColumnTypeNullDefault Links to Comments MIME
TABLE_SCHEMAvarchar(192)No
TABLE_NAMEvarchar(192)No
INDEX_NAMEvarchar(192)No
ROWS_READbigint(21)No0

INNODB_SYS_DATAFILES

ColumnTypeNullDefault Links to Comments MIME
SPACEint(11)No0
PATHvarchar(4000)No

TABLE_STATISTICS

ColumnTypeNullDefault Links to Comments MIME
TABLE_SCHEMAvarchar(192)No
TABLE_NAMEvarchar(192)No
ROWS_READbigint(21)No0
ROWS_CHANGEDbigint(21)No0
ROWS_CHANGED_X_INDEXESbigint(21)No0

INNODB_SYS_TABLESTATS

ColumnTypeNullDefault Links to Comments MIME
TABLE_IDbigint(21)No0
NAMEvarchar(193)No
STATS_INITIALIZEDvarchar(193)No
NUM_ROWSbigint(21)No0
CLUST_INDEX_SIZEbigint(21)No0
OTHER_INDEX_SIZEbigint(21)No0
MODIFIED_COUNTERbigint(21)No0
AUTOINCbigint(21)No0
REF_COUNTint(11)No0

USER_STATISTICS

ColumnTypeNullDefault Links to Comments MIME
USERvarchar(128)No
TOTAL_CONNECTIONSint(11)No0
CONCURRENT_CONNECTIONSint(11)No0
CONNECTED_TIMEint(11)No0
BUSY_TIMEdoubleNo0
CPU_TIMEdoubleNo0
BYTES_RECEIVEDbigint(21)No0
BYTES_SENTbigint(21)No0
BINLOG_BYTES_WRITTENbigint(21)No0
ROWS_READbigint(21)No0
ROWS_SENTbigint(21)No0
ROWS_DELETEDbigint(21)No0
ROWS_INSERTEDbigint(21)No0
ROWS_UPDATEDbigint(21)No0
SELECT_COMMANDSbigint(21)No0
UPDATE_COMMANDSbigint(21)No0
OTHER_COMMANDSbigint(21)No0
COMMIT_TRANSACTIONSbigint(21)No0
ROLLBACK_TRANSACTIONSbigint(21)No0
DENIED_CONNECTIONSbigint(21)No0
LOST_CONNECTIONSbigint(21)No0
ACCESS_DENIEDbigint(21)No0
EMPTY_QUERIESbigint(21)No0
TOTAL_SSL_CONNECTIONSbigint(21)No0
MAX_STATEMENT_TIME_EXCEEDEDbigint(21)No0

INNODB_SYS_INDEXES

ColumnTypeNullDefault Links to Comments MIME
INDEX_IDbigint(21)No0
NAMEvarchar(193)No
TABLE_IDbigint(21)No0
TYPEint(11)No0
N_FIELDSint(11)No0
PAGE_NOint(11)No0
SPACEint(11)No0

XTRADB_RSEG

ColumnTypeNullDefault Links to Comments MIME
rseg_idbigint(21)No0
space_idbigint(21)No0
zip_sizebigint(21)No0
page_nobigint(21)No0
max_sizebigint(21)No0
curr_sizebigint(21)No0

INNODB_CMP_PER_INDEX

ColumnTypeNullDefault Links to Comments MIME
database_namevarchar(192)No
table_namevarchar(192)No
index_namevarchar(192)No
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_TRX

ColumnTypeNullDefault Links to Comments MIME
trx_idvarchar(18)No
trx_statevarchar(13)No
trx_starteddatetimeNo0000-00-00 00:00:00
trx_requested_lock_idvarchar(81)YesNULL
trx_wait_starteddatetimeYesNULL
trx_weightbigint(21)No0
trx_mysql_thread_idbigint(21)No0
trx_queryvarchar(1024)YesNULL
trx_operation_statevarchar(64)YesNULL
trx_tables_in_usebigint(21)No0
trx_tables_lockedbigint(21)No0
trx_lock_structsbigint(21)No0
trx_lock_memory_bytesbigint(21)No0
trx_rows_lockedbigint(21)No0
trx_rows_modifiedbigint(21)No0
trx_concurrency_ticketsbigint(21)No0
trx_isolation_levelvarchar(16)No
trx_unique_checksint(1)No0
trx_foreign_key_checksint(1)No0
trx_last_foreign_key_errorvarchar(256)YesNULL
trx_adaptive_hash_latchedint(1)No0
trx_adaptive_hash_timeoutbigint(21)No0
trx_is_read_onlyint(1)No0
trx_autocommit_non_lockingint(1)No0

CHANGED_PAGE_BITMAPS

ColumnTypeNullDefault Links to Comments MIME
dummybigint(21)No0

INNODB_FT_BEING_DELETED

ColumnTypeNullDefault Links to Comments MIME
DOC_IDbigint(21)No0

INNODB_LOCK_WAITS

ColumnTypeNullDefault Links to Comments MIME
requesting_trx_idvarchar(18)No
requested_lock_idvarchar(81)No
blocking_trx_idvarchar(18)No
blocking_lock_idvarchar(81)No

INNODB_LOCKS

ColumnTypeNullDefault Links to Comments MIME
lock_idvarchar(81)No
lock_trx_idvarchar(18)No
lock_modevarchar(32)No
lock_typevarchar(32)No
lock_tablevarchar(1024)No
lock_indexvarchar(1024)YesNULL
lock_spacebigint(21)YesNULL
lock_pagebigint(21)YesNULL
lock_recbigint(21)YesNULL
lock_datavarchar(8192)YesNULL

INNODB_TABLESPACES_ENCRYPTION

ColumnTypeNullDefault Links to Comments MIME
SPACEint(11)No0
NAMEvarchar(655)YesNULL
ENCRYPTION_SCHEMEint(11)No0
KEYSERVER_REQUESTSint(11)No0
MIN_KEY_VERSIONint(11)No0
CURRENT_KEY_VERSIONint(11)No0
KEY_ROTATION_PAGE_NUMBERbigint(21)YesNULL
KEY_ROTATION_MAX_PAGE_NUMBERbigint(21)YesNULL
CURRENT_KEY_IDint(11)No0

XTRADB_INTERNAL_HASH_TABLES

ColumnTypeNullDefault Links to Comments MIME
INTERNAL_HASH_TABLE_NAMEvarchar(100)No
TOTAL_MEMORYbigint(21)No0
CONSTANT_MEMORYbigint(21)No0
VARIABLE_MEMORYbigint(21)No0

INNODB_SYS_FIELDS

ColumnTypeNullDefault Links to Comments MIME
INDEX_IDbigint(21)No0
NAMEvarchar(193)No
POSint(11)No0

INNODB_CMPMEM_RESET

ColumnTypeNullDefault Links to Comments MIME
page_sizeint(5)No0
buffer_pool_instanceint(11)No0
pages_usedint(11)No0
pages_freeint(11)No0
relocation_opsbigint(21)No0
relocation_timeint(11)No0

INNODB_CMP

ColumnTypeNullDefault Links to Comments MIME
page_sizeint(5)No0
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_FT_INDEX_TABLE

ColumnTypeNullDefault Links to Comments MIME
WORDvarchar(255)No
FIRST_DOC_IDbigint(21)No0
LAST_DOC_IDbigint(21)No0
DOC_COUNTbigint(21)No0
DOC_IDbigint(21)No0
POSITIONbigint(21)No0

INNODB_SYS_TABLESPACES

ColumnTypeNullDefault Links to Comments MIME
SPACEint(11)No0
NAMEvarchar(655)No
FLAGint(11)No0
FILE_FORMATvarchar(10)YesNULL
ROW_FORMATvarchar(22)YesNULL
PAGE_SIZEint(11)No0
ZIP_PAGE_SIZEint(11)No0

INNODB_MUTEXES

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(4000)No
CREATE_FILEvarchar(4000)No
CREATE_LINEint(11)No0
OS_WAITSbigint(21)No0

INNODB_BUFFER_PAGE_LRU

ColumnTypeNullDefault Links to Comments MIME
POOL_IDbigint(21)No0
LRU_POSITIONbigint(21)No0
SPACEbigint(21)No0
PAGE_NUMBERbigint(21)No0
PAGE_TYPEvarchar(64)YesNULL
FLUSH_TYPEbigint(21)No0
FIX_COUNTbigint(21)No0
IS_HASHEDvarchar(3)YesNULL
NEWEST_MODIFICATIONbigint(21)No0
OLDEST_MODIFICATIONbigint(21)No0
ACCESS_TIMEbigint(21)No0
TABLE_NAMEvarchar(1024)YesNULL
INDEX_NAMEvarchar(1024)YesNULL
NUMBER_RECORDSbigint(21)No0
DATA_SIZEbigint(21)No0
COMPRESSED_SIZEbigint(21)No0
COMPRESSEDvarchar(3)YesNULL
IO_FIXvarchar(64)YesNULL
IS_OLDvarchar(3)YesNULL
FREE_PAGE_CLOCKbigint(21)No0

INNODB_SYS_FOREIGN_COLS

ColumnTypeNullDefault Links to Comments MIME
IDvarchar(193)No
FOR_COL_NAMEvarchar(193)No
REF_COL_NAMEvarchar(193)No
POSint(11)No0

INNODB_CMP_RESET

ColumnTypeNullDefault Links to Comments MIME
page_sizeint(5)No0
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_BUFFER_POOL_STATS

ColumnTypeNullDefault Links to Comments MIME
POOL_IDbigint(21)No0
POOL_SIZEbigint(21)No0
FREE_BUFFERSbigint(21)No0
DATABASE_PAGESbigint(21)No0
OLD_DATABASE_PAGESbigint(21)No0
MODIFIED_DATABASE_PAGESbigint(21)No0
PENDING_DECOMPRESSbigint(21)No0
PENDING_READSbigint(21)No0
PENDING_FLUSH_LRUbigint(21)No0
PENDING_FLUSH_LISTbigint(21)No0
PAGES_MADE_YOUNGbigint(21)No0
PAGES_NOT_MADE_YOUNGbigint(21)No0
PAGES_MADE_YOUNG_RATEdoubleNo0
PAGES_MADE_NOT_YOUNG_RATEdoubleNo0
NUMBER_PAGES_READbigint(21)No0
NUMBER_PAGES_CREATEDbigint(21)No0
NUMBER_PAGES_WRITTENbigint(21)No0
PAGES_READ_RATEdoubleNo0
PAGES_CREATE_RATEdoubleNo0
PAGES_WRITTEN_RATEdoubleNo0
NUMBER_PAGES_GETbigint(21)No0
HIT_RATEbigint(21)No0
YOUNG_MAKE_PER_THOUSAND_GETSbigint(21)No0
NOT_YOUNG_MAKE_PER_THOUSAND_GETSbigint(21)No0
NUMBER_PAGES_READ_AHEADbigint(21)No0
NUMBER_READ_AHEAD_EVICTEDbigint(21)No0
READ_AHEAD_RATEdoubleNo0
READ_AHEAD_EVICTED_RATEdoubleNo0
LRU_IO_TOTALbigint(21)No0
LRU_IO_CURRENTbigint(21)No0
UNCOMPRESS_TOTALbigint(21)No0
UNCOMPRESS_CURRENTbigint(21)No0

INNODB_FT_INDEX_CACHE

ColumnTypeNullDefault Links to Comments MIME
WORDvarchar(255)No
FIRST_DOC_IDbigint(21)No0
LAST_DOC_IDbigint(21)No0
DOC_COUNTbigint(21)No0
DOC_IDbigint(21)No0
POSITIONbigint(21)No0

INNODB_SYS_FOREIGN

ColumnTypeNullDefault Links to Comments MIME
IDvarchar(193)No
FOR_NAMEvarchar(193)No
REF_NAMEvarchar(193)No
N_COLSint(11)No0
TYPEint(11)No0

INNODB_METRICS

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(193)No
SUBSYSTEMvarchar(193)No
COUNTbigint(21)No0
MAX_COUNTbigint(21)YesNULL
MIN_COUNTbigint(21)YesNULL
AVG_COUNTdoubleYesNULL
COUNT_RESETbigint(21)No0
MAX_COUNT_RESETbigint(21)YesNULL
MIN_COUNT_RESETbigint(21)YesNULL
AVG_COUNT_RESETdoubleYesNULL
TIME_ENABLEDdatetimeYesNULL
TIME_DISABLEDdatetimeYesNULL
TIME_ELAPSEDbigint(21)YesNULL
TIME_RESETdatetimeYesNULL
STATUSvarchar(193)No
TYPEvarchar(193)No
COMMENTvarchar(193)No

INNODB_FT_DEFAULT_STOPWORD

ColumnTypeNullDefault Links to Comments MIME
valuevarchar(18)No

INNODB_CMPMEM

ColumnTypeNullDefault Links to Comments MIME
page_sizeint(5)No0
buffer_pool_instanceint(11)No0
pages_usedint(11)No0
pages_freeint(11)No0
relocation_opsbigint(21)No0
relocation_timeint(11)No0

INNODB_SYS_TABLES

ColumnTypeNullDefault Links to Comments MIME
TABLE_IDbigint(21)No0
NAMEvarchar(655)No
FLAGint(11)No0
N_COLSint(11)No0
SPACEint(11)No0
FILE_FORMATvarchar(10)YesNULL
ROW_FORMATvarchar(12)YesNULL
ZIP_PAGE_SIZEint(11)No0

INNODB_SYS_COLUMNS

ColumnTypeNullDefault Links to Comments MIME
TABLE_IDbigint(21)No0
NAMEvarchar(193)No
POSbigint(21)No0
MTYPEint(11)No0
PRTYPEint(11)No0
LENint(11)No0

INNODB_FT_CONFIG

ColumnTypeNullDefault Links to Comments MIME
KEYvarchar(193)No
VALUEvarchar(193)No

INNODB_BUFFER_PAGE

ColumnTypeNullDefault Links to Comments MIME
POOL_IDbigint(21)No0
BLOCK_IDbigint(21)No0
SPACEbigint(21)No0
PAGE_NUMBERbigint(21)No0
PAGE_TYPEvarchar(64)YesNULL
FLUSH_TYPEbigint(21)No0
FIX_COUNTbigint(21)No0
IS_HASHEDvarchar(3)YesNULL
NEWEST_MODIFICATIONbigint(21)No0
OLDEST_MODIFICATIONbigint(21)No0
ACCESS_TIMEbigint(21)No0
TABLE_NAMEvarchar(1024)YesNULL
INDEX_NAMEvarchar(1024)YesNULL
NUMBER_RECORDSbigint(21)No0
DATA_SIZEbigint(21)No0
COMPRESSED_SIZEbigint(21)No0
PAGE_STATEvarchar(64)YesNULL
IO_FIXvarchar(64)YesNULL
IS_OLDvarchar(3)YesNULL
FREE_PAGE_CLOCKbigint(21)No0

INNODB_CMP_PER_INDEX_RESET

ColumnTypeNullDefault Links to Comments MIME
database_namevarchar(192)No
table_namevarchar(192)No
index_namevarchar(192)No
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

XTRADB_READ_VIEW

ColumnTypeNullDefault Links to Comments MIME
READ_VIEW_UNDO_NUMBERbigint(21)No0
READ_VIEW_LOW_LIMIT_TRX_NUMBERvarchar(18)No
READ_VIEW_UPPER_LIMIT_TRX_IDvarchar(18)No
READ_VIEW_LOW_LIMIT_TRX_IDvarchar(18)No

INNODB_SYS_SEMAPHORE_WAITS

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(21)No0
OBJECT_NAMEvarchar(4000)YesNULL
FILEvarchar(4000)YesNULL
LINEint(11)No0
WAIT_TIMEbigint(21)No0
WAIT_OBJECTbigint(21)No0
WAIT_TYPEvarchar(16)YesNULL
HOLDER_THREAD_IDbigint(21)No0
HOLDER_FILEvarchar(4000)YesNULL
HOLDER_LINEint(11)No0
CREATED_FILEvarchar(4000)YesNULL
CREATED_LINEint(11)No0
WRITER_THREADbigint(21)No0
RESERVATION_MODEvarchar(16)YesNULL
READERSint(11)No0
WAITERS_FLAGbigint(21)No0
LOCK_WORDbigint(21)No0
LAST_READER_FILEvarchar(4000)YesNULL
LAST_READER_LINEint(11)No0
LAST_WRITER_FILEvarchar(4000)YesNULL
LAST_WRITER_LINEint(11)No0
OS_WAIT_COUNTint(11)No0

INNODB_CHANGED_PAGES

ColumnTypeNullDefault Links to Comments MIME
space_idint(11)No0
page_idint(11)No0
start_lsnbigint(21)No0
end_lsnbigint(21)No0

INNODB_FT_DELETED

ColumnTypeNullDefault Links to Comments MIME
DOC_IDbigint(21)No0

INNODB_TABLESPACES_SCRUBBING

ColumnTypeNullDefault Links to Comments MIME
SPACEbigint(21)No0
NAMEvarchar(655)YesNULL
COMPRESSEDint(11)No0
LAST_SCRUB_COMPLETEDdatetimeYesNULL
CURRENT_SCRUB_STARTEDdatetimeYesNULL
CURRENT_SCRUB_ACTIVE_THREADSint(11)YesNULL
CURRENT_SCRUB_PAGE_NUMBERbigint(21)No0
CURRENT_SCRUB_MAX_PAGE_NUMBERbigint(21)No0