ALL_PLUGINS

字段类型默认 链接到 注释 MIME
PLUGIN_NAMEvarchar(64)
PLUGIN_VERSIONvarchar(20)
PLUGIN_STATUSvarchar(16)
PLUGIN_TYPEvarchar(80)
PLUGIN_TYPE_VERSIONvarchar(20)
PLUGIN_LIBRARYvarchar(64)NULL
PLUGIN_LIBRARY_VERSIONvarchar(20)NULL
PLUGIN_AUTHORvarchar(64)NULL
PLUGIN_DESCRIPTIONlongtextNULL
PLUGIN_LICENSEvarchar(80)
LOAD_OPTIONvarchar(64)
PLUGIN_MATURITYvarchar(12)
PLUGIN_AUTH_VERSIONvarchar(80)NULL

APPLICABLE_ROLES

字段类型默认 链接到 注释 MIME
GRANTEEvarchar(190)
ROLE_NAMEvarchar(128)
IS_GRANTABLEvarchar(3)
IS_DEFAULTvarchar(3)NULL

CHARACTER_SETS

字段类型默认 链接到 注释 MIME
CHARACTER_SET_NAMEvarchar(32)
DEFAULT_COLLATE_NAMEvarchar(32) COLLATIONS -> COLLATION_NAME
DESCRIPTIONvarchar(60)
MAXLENbigint(3)0

COLLATIONS

字段类型默认 链接到 注释 MIME
COLLATION_NAMEvarchar(32)
CHARACTER_SET_NAMEvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME
IDbigint(11)0
IS_DEFAULTvarchar(3)
IS_COMPILEDvarchar(3)
SORTLENbigint(3)0

COLLATION_CHARACTER_SET_APPLICABILITY

字段类型默认 链接到 注释 MIME
COLLATION_NAMEvarchar(32) COLLATIONS -> COLLATION_NAME
CHARACTER_SET_NAMEvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME

COLUMNS

字段类型默认 链接到 注释 MIME
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
COLUMN_NAMEvarchar(64)
ORDINAL_POSITIONbigint(21)0
COLUMN_DEFAULTlongtextNULL
IS_NULLABLEvarchar(3)
DATA_TYPEvarchar(64)
CHARACTER_MAXIMUM_LENGTHbigint(21)NULL
CHARACTER_OCTET_LENGTHbigint(21)NULL
NUMERIC_PRECISIONbigint(21)NULL
NUMERIC_SCALEbigint(21)NULL
DATETIME_PRECISIONbigint(21)NULL
CHARACTER_SET_NAMEvarchar(32)NULL CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAMEvarchar(32)NULL COLLATIONS -> COLLATION_NAME
COLUMN_TYPElongtext
COLUMN_KEYvarchar(3)
EXTRAvarchar(27)
PRIVILEGESvarchar(80)
COLUMN_COMMENTvarchar(1024)

COLUMN_PRIVILEGES

字段类型默认 链接到 注释 MIME
GRANTEEvarchar(190)
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
COLUMN_NAMEvarchar(64)
PRIVILEGE_TYPEvarchar(64)
IS_GRANTABLEvarchar(3)

ENABLED_ROLES

字段类型默认 链接到 注释 MIME
ROLE_NAMEvarchar(128)NULL

ENGINES

字段类型默认 链接到 注释 MIME
ENGINEvarchar(64)
SUPPORTvarchar(8)
COMMENTvarchar(160)
TRANSACTIONSvarchar(3)NULL
XAvarchar(3)NULL
SAVEPOINTSvarchar(3)NULL

EVENTS

字段类型默认 链接到 注释 MIME
EVENT_CATALOGvarchar(64)
EVENT_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
EVENT_NAMEvarchar(64)
DEFINERvarchar(189)
TIME_ZONEvarchar(64)
EVENT_BODYvarchar(8)
EVENT_DEFINITIONlongtext
EVENT_TYPEvarchar(9)
EXECUTE_ATdatetimeNULL
INTERVAL_VALUEvarchar(256)NULL
INTERVAL_FIELDvarchar(18)NULL
SQL_MODEvarchar(8192)
STARTSdatetimeNULL
ENDSdatetimeNULL
STATUSvarchar(18)
ON_COMPLETIONvarchar(12)
CREATEDdatetime0000-00-00 00:00:00
LAST_ALTEREDdatetime0000-00-00 00:00:00
LAST_EXECUTEDdatetimeNULL
EVENT_COMMENTvarchar(64)
ORIGINATORbigint(10)0
CHARACTER_SET_CLIENTvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32) COLLATIONS -> COLLATION_NAME
DATABASE_COLLATIONvarchar(32) COLLATIONS -> COLLATION_NAME

FILES

字段类型默认 链接到 注释 MIME
FILE_IDbigint(4)0
FILE_NAMEvarchar(64)NULL
FILE_TYPEvarchar(20)
TABLESPACE_NAMEvarchar(64)NULL TABLESPACES -> TABLESPACE_NAME
TABLE_CATALOGvarchar(64)
TABLE_SCHEMAvarchar(64)NULL SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)NULL
LOGFILE_GROUP_NAMEvarchar(64)NULL
LOGFILE_GROUP_NUMBERbigint(4)NULL
ENGINEvarchar(64) ENGINES -> ENGINE
FULLTEXT_KEYSvarchar(64)NULL
DELETED_ROWSbigint(4)NULL
UPDATE_COUNTbigint(4)NULL
FREE_EXTENTSbigint(4)NULL
TOTAL_EXTENTSbigint(4)NULL
EXTENT_SIZEbigint(4)0
INITIAL_SIZEbigint(21)NULL
MAXIMUM_SIZEbigint(21)NULL
AUTOEXTEND_SIZEbigint(21)NULL
CREATION_TIMEdatetimeNULL
LAST_UPDATE_TIMEdatetimeNULL
LAST_ACCESS_TIMEdatetimeNULL
RECOVER_TIMEbigint(4)NULL
TRANSACTION_COUNTERbigint(4)NULL
VERSIONbigint(21)NULL
ROW_FORMATvarchar(10)NULL
TABLE_ROWSbigint(21)NULL
AVG_ROW_LENGTHbigint(21)NULL
DATA_LENGTHbigint(21)NULL
MAX_DATA_LENGTHbigint(21)NULL
INDEX_LENGTHbigint(21)NULL
DATA_FREEbigint(21)NULL
CREATE_TIMEdatetimeNULL
UPDATE_TIMEdatetimeNULL
CHECK_TIMEdatetimeNULL
CHECKSUMbigint(21)NULL
STATUSvarchar(20)
EXTRAvarchar(255)NULL

GLOBAL_STATUS

字段类型默认 链接到 注释 MIME
VARIABLE_NAMEvarchar(64)
VARIABLE_VALUEvarchar(2048)

GLOBAL_VARIABLES

字段类型默认 链接到 注释 MIME
VARIABLE_NAMEvarchar(64)
VARIABLE_VALUEvarchar(2048)

KEY_CACHES

字段类型默认 链接到 注释 MIME
KEY_CACHE_NAMEvarchar(192)
SEGMENTSint(3)NULL
SEGMENT_NUMBERint(3)NULL
FULL_SIZEbigint(21)0
BLOCK_SIZEbigint(21)0
USED_BLOCKSbigint(21)0
UNUSED_BLOCKSbigint(21)0
DIRTY_BLOCKSbigint(21)0
READ_REQUESTSbigint(21)0
READSbigint(21)0
WRITE_REQUESTSbigint(21)0
WRITESbigint(21)0

KEY_COLUMN_USAGE

字段类型默认 链接到 注释 MIME
CONSTRAINT_CATALOGvarchar(512)
CONSTRAINT_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAMEvarchar(64)
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
COLUMN_NAMEvarchar(64)
ORDINAL_POSITIONbigint(10)0
POSITION_IN_UNIQUE_CONSTRAINTbigint(10)NULL
REFERENCED_TABLE_SCHEMAvarchar(64)NULL SCHEMATA -> SCHEMA_NAME
REFERENCED_TABLE_NAMEvarchar(64)NULL
REFERENCED_COLUMN_NAMEvarchar(64)NULL

PARAMETERS

字段类型默认 链接到 注释 MIME
SPECIFIC_CATALOGvarchar(512)
SPECIFIC_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
SPECIFIC_NAMEvarchar(64)
ORDINAL_POSITIONint(21)0
PARAMETER_MODEvarchar(5)NULL
PARAMETER_NAMEvarchar(64)NULL
DATA_TYPEvarchar(64)
CHARACTER_MAXIMUM_LENGTHint(21)NULL
CHARACTER_OCTET_LENGTHint(21)NULL
NUMERIC_PRECISIONint(21)NULL
NUMERIC_SCALEint(21)NULL
DATETIME_PRECISIONbigint(21)NULL
CHARACTER_SET_NAMEvarchar(64)NULL CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAMEvarchar(64)NULL COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIERlongtext
ROUTINE_TYPEvarchar(9)

PARTITIONS

字段类型默认 链接到 注释 MIME
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
PARTITION_NAMEvarchar(64)NULL
SUBPARTITION_NAMEvarchar(64)NULL
PARTITION_ORDINAL_POSITIONbigint(21)NULL
SUBPARTITION_ORDINAL_POSITIONbigint(21)NULL
PARTITION_METHODvarchar(18)NULL
SUBPARTITION_METHODvarchar(12)NULL
PARTITION_EXPRESSIONlongtextNULL
SUBPARTITION_EXPRESSIONlongtextNULL
PARTITION_DESCRIPTIONlongtextNULL
TABLE_ROWSbigint(21)0
AVG_ROW_LENGTHbigint(21)0
DATA_LENGTHbigint(21)0
MAX_DATA_LENGTHbigint(21)NULL
INDEX_LENGTHbigint(21)0
DATA_FREEbigint(21)0
CREATE_TIMEdatetimeNULL
UPDATE_TIMEdatetimeNULL
CHECK_TIMEdatetimeNULL
CHECKSUMbigint(21)NULL
PARTITION_COMMENTvarchar(80)
NODEGROUPvarchar(12)
TABLESPACE_NAMEvarchar(64)NULL TABLESPACES -> TABLESPACE_NAME

PLUGINS

字段类型默认 链接到 注释 MIME
PLUGIN_NAMEvarchar(64)
PLUGIN_VERSIONvarchar(20)
PLUGIN_STATUSvarchar(16)
PLUGIN_TYPEvarchar(80)
PLUGIN_TYPE_VERSIONvarchar(20)
PLUGIN_LIBRARYvarchar(64)NULL
PLUGIN_LIBRARY_VERSIONvarchar(20)NULL
PLUGIN_AUTHORvarchar(64)NULL
PLUGIN_DESCRIPTIONlongtextNULL
PLUGIN_LICENSEvarchar(80)
LOAD_OPTIONvarchar(64)
PLUGIN_MATURITYvarchar(12)
PLUGIN_AUTH_VERSIONvarchar(80)NULL

PROCESSLIST

字段类型默认 链接到 注释 MIME
IDbigint(4)0
USERvarchar(128)
HOSTvarchar(64)
DBvarchar(64)NULL SCHEMATA -> SCHEMA_NAME
COMMANDvarchar(16)
TIMEint(7)0
STATEvarchar(64)NULL
INFOlongtextNULL
TIME_MSdecimal(22,3)0.000
STAGEtinyint(2)0
MAX_STAGEtinyint(2)0
PROGRESSdecimal(7,3)0.000
MEMORY_USEDint(7)0
EXAMINED_ROWSint(7)0
QUERY_IDbigint(4)0
INFO_BINARYblobNULL
TIDbigint(4)0

PROFILING

字段类型默认 链接到 注释 MIME
QUERY_IDint(20)0
SEQint(20)0
STATEvarchar(30)
DURATIONdecimal(9,6)0.000000
CPU_USERdecimal(9,6)NULL
CPU_SYSTEMdecimal(9,6)NULL
CONTEXT_VOLUNTARYint(20)NULL
CONTEXT_INVOLUNTARYint(20)NULL
BLOCK_OPS_INint(20)NULL
BLOCK_OPS_OUTint(20)NULL
MESSAGES_SENTint(20)NULL
MESSAGES_RECEIVEDint(20)NULL
PAGE_FAULTS_MAJORint(20)NULL
PAGE_FAULTS_MINORint(20)NULL
SWAPSint(20)NULL
SOURCE_FUNCTIONvarchar(30)NULL
SOURCE_FILEvarchar(20)NULL
SOURCE_LINEint(20)NULL

REFERENTIAL_CONSTRAINTS

字段类型默认 链接到 注释 MIME
CONSTRAINT_CATALOGvarchar(512)
CONSTRAINT_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAMEvarchar(64)
UNIQUE_CONSTRAINT_CATALOGvarchar(512)
UNIQUE_CONSTRAINT_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
UNIQUE_CONSTRAINT_NAMEvarchar(64)NULL
MATCH_OPTIONvarchar(64)
UPDATE_RULEvarchar(64)
DELETE_RULEvarchar(64)
TABLE_NAMEvarchar(64)
REFERENCED_TABLE_NAMEvarchar(64)

ROUTINES

字段类型默认 链接到 注释 MIME
SPECIFIC_NAMEvarchar(64)
ROUTINE_CATALOGvarchar(512)
ROUTINE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
ROUTINE_NAMEvarchar(64)
ROUTINE_TYPEvarchar(9)
DATA_TYPEvarchar(64)
CHARACTER_MAXIMUM_LENGTHint(21)NULL
CHARACTER_OCTET_LENGTHint(21)NULL
NUMERIC_PRECISIONint(21)NULL
NUMERIC_SCALEint(21)NULL
DATETIME_PRECISIONbigint(21)NULL
CHARACTER_SET_NAMEvarchar(64)NULL CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_NAMEvarchar(64)NULL COLLATIONS -> COLLATION_NAME
DTD_IDENTIFIERlongtextNULL
ROUTINE_BODYvarchar(8)
ROUTINE_DEFINITIONlongtextNULL
EXTERNAL_NAMEvarchar(64)NULL
EXTERNAL_LANGUAGEvarchar(64)NULL
PARAMETER_STYLEvarchar(8)
IS_DETERMINISTICvarchar(3)
SQL_DATA_ACCESSvarchar(64)
SQL_PATHvarchar(64)NULL
SECURITY_TYPEvarchar(7)
CREATEDdatetime0000-00-00 00:00:00
LAST_ALTEREDdatetime0000-00-00 00:00:00
SQL_MODEvarchar(8192)
ROUTINE_COMMENTlongtext
DEFINERvarchar(189)
CHARACTER_SET_CLIENTvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32) COLLATIONS -> COLLATION_NAME
DATABASE_COLLATIONvarchar(32) COLLATIONS -> COLLATION_NAME

SCHEMATA

字段类型默认 链接到 注释 MIME
CATALOG_NAMEvarchar(512)
SCHEMA_NAMEvarchar(64)
DEFAULT_CHARACTER_SET_NAMEvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME
DEFAULT_COLLATION_NAMEvarchar(32) COLLATIONS -> COLLATION_NAME
SQL_PATHvarchar(512)NULL

SCHEMA_PRIVILEGES

字段类型默认 链接到 注释 MIME
GRANTEEvarchar(190)
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
PRIVILEGE_TYPEvarchar(64)
IS_GRANTABLEvarchar(3)

SESSION_STATUS

字段类型默认 链接到 注释 MIME
VARIABLE_NAMEvarchar(64)
VARIABLE_VALUEvarchar(2048)

SESSION_VARIABLES

字段类型默认 链接到 注释 MIME
VARIABLE_NAMEvarchar(64)
VARIABLE_VALUEvarchar(2048)

STATISTICS

字段类型默认 链接到 注释 MIME
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
NON_UNIQUEbigint(1)0
INDEX_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
INDEX_NAMEvarchar(64)
SEQ_IN_INDEXbigint(2)0
COLUMN_NAMEvarchar(64)
COLLATIONvarchar(1)NULL
CARDINALITYbigint(21)NULL
SUB_PARTbigint(3)NULL
PACKEDvarchar(10)NULL
NULLABLEvarchar(3)
INDEX_TYPEvarchar(16)
COMMENTvarchar(16)NULL
INDEX_COMMENTvarchar(1024)

SYSTEM_VARIABLES

字段类型默认 链接到 注释 MIME
VARIABLE_NAMEvarchar(64)
SESSION_VALUEvarchar(2048)NULL
GLOBAL_VALUEvarchar(2048)NULL
GLOBAL_VALUE_ORIGINvarchar(64)
DEFAULT_VALUEvarchar(2048)NULL
VARIABLE_SCOPEvarchar(64)
VARIABLE_TYPEvarchar(64)
VARIABLE_COMMENTvarchar(2048)
NUMERIC_MIN_VALUEvarchar(21)NULL
NUMERIC_MAX_VALUEvarchar(21)NULL
NUMERIC_BLOCK_SIZEvarchar(21)NULL
ENUM_VALUE_LISTlongtextNULL
READ_ONLYvarchar(3)
COMMAND_LINE_ARGUMENTvarchar(64)NULL

TABLES

字段类型默认 链接到 注释 MIME
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
TABLE_TYPEvarchar(64)
ENGINEvarchar(64)NULL ENGINES -> ENGINE
VERSIONbigint(21)NULL
ROW_FORMATvarchar(10)NULL
TABLE_ROWSbigint(21)NULL
AVG_ROW_LENGTHbigint(21)NULL
DATA_LENGTHbigint(21)NULL
MAX_DATA_LENGTHbigint(21)NULL
INDEX_LENGTHbigint(21)NULL
DATA_FREEbigint(21)NULL
AUTO_INCREMENTbigint(21)NULL
CREATE_TIMEdatetimeNULL
UPDATE_TIMEdatetimeNULL
CHECK_TIMEdatetimeNULL
TABLE_COLLATIONvarchar(32)NULL COLLATIONS -> COLLATION_NAME
CHECKSUMbigint(21)NULL
CREATE_OPTIONSvarchar(2048)NULL
TABLE_COMMENTvarchar(2048)

TABLESPACES

字段类型默认 链接到 注释 MIME
TABLESPACE_NAMEvarchar(64)
ENGINEvarchar(64)
TABLESPACE_TYPEvarchar(64)NULL
LOGFILE_GROUP_NAMEvarchar(64)NULL
EXTENT_SIZEbigint(21)NULL
AUTOEXTEND_SIZEbigint(21)NULL
MAXIMUM_SIZEbigint(21)NULL
NODEGROUP_IDbigint(21)NULL
TABLESPACE_COMMENTvarchar(2048)NULL

TABLE_CONSTRAINTS

字段类型默认 链接到 注释 MIME
CONSTRAINT_CATALOGvarchar(512)
CONSTRAINT_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
CONSTRAINT_NAMEvarchar(64)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
CONSTRAINT_TYPEvarchar(64)

TABLE_PRIVILEGES

字段类型默认 链接到 注释 MIME
GRANTEEvarchar(190)
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
PRIVILEGE_TYPEvarchar(64)
IS_GRANTABLEvarchar(3)

TRIGGERS

字段类型默认 链接到 注释 MIME
TRIGGER_CATALOGvarchar(512)
TRIGGER_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TRIGGER_NAMEvarchar(64)
EVENT_MANIPULATIONvarchar(6)
EVENT_OBJECT_CATALOGvarchar(512)
EVENT_OBJECT_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
EVENT_OBJECT_TABLEvarchar(64)
ACTION_ORDERbigint(4)0
ACTION_CONDITIONlongtextNULL
ACTION_STATEMENTlongtext
ACTION_ORIENTATIONvarchar(9)
ACTION_TIMINGvarchar(6)
ACTION_REFERENCE_OLD_TABLEvarchar(64)NULL
ACTION_REFERENCE_NEW_TABLEvarchar(64)NULL
ACTION_REFERENCE_OLD_ROWvarchar(3)
ACTION_REFERENCE_NEW_ROWvarchar(3)
CREATEDdatetimeNULL
SQL_MODEvarchar(8192)
DEFINERvarchar(189)
CHARACTER_SET_CLIENTvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32) COLLATIONS -> COLLATION_NAME
DATABASE_COLLATIONvarchar(32) COLLATIONS -> COLLATION_NAME

USER_PRIVILEGES

字段类型默认 链接到 注释 MIME
GRANTEEvarchar(190)
TABLE_CATALOGvarchar(512)
PRIVILEGE_TYPEvarchar(64)
IS_GRANTABLEvarchar(3)

VIEWS

字段类型默认 链接到 注释 MIME
TABLE_CATALOGvarchar(512)
TABLE_SCHEMAvarchar(64) SCHEMATA -> SCHEMA_NAME
TABLE_NAMEvarchar(64)
VIEW_DEFINITIONlongtext
CHECK_OPTIONvarchar(8)
IS_UPDATABLEvarchar(3)
DEFINERvarchar(189)
SECURITY_TYPEvarchar(7)
CHARACTER_SET_CLIENTvarchar(32) CHARACTER_SETS -> CHARACTER_SET_NAME
COLLATION_CONNECTIONvarchar(32) COLLATIONS -> COLLATION_NAME
ALGORITHMvarchar(10)

GEOMETRY_COLUMNS

字段类型默认 链接到 注释 MIME
F_TABLE_CATALOGvarchar(512)
F_TABLE_SCHEMAvarchar(64)
F_TABLE_NAMEvarchar(64)
F_GEOMETRY_COLUMNvarchar(64)
G_TABLE_CATALOGvarchar(512)
G_TABLE_SCHEMAvarchar(64)
G_TABLE_NAMEvarchar(64)
G_GEOMETRY_COLUMNvarchar(64)
STORAGE_TYPEtinyint(2)0
GEOMETRY_TYPEint(7)0
COORD_DIMENSIONtinyint(2)0
MAX_PPRtinyint(2)0
SRIDsmallint(5)0

SPATIAL_REF_SYS

字段类型默认 链接到 注释 MIME
SRIDsmallint(5)0
AUTH_NAMEvarchar(512)
AUTH_SRIDint(5)0
SRTEXTvarchar(2048)

CLIENT_STATISTICS

字段类型默认 链接到 注释 MIME
CLIENTvarchar(64)
TOTAL_CONNECTIONSbigint(21)0
CONCURRENT_CONNECTIONSbigint(21)0
CONNECTED_TIMEbigint(21)0
BUSY_TIMEdouble0
CPU_TIMEdouble0
BYTES_RECEIVEDbigint(21)0
BYTES_SENTbigint(21)0
BINLOG_BYTES_WRITTENbigint(21)0
ROWS_READbigint(21)0
ROWS_SENTbigint(21)0
ROWS_DELETEDbigint(21)0
ROWS_INSERTEDbigint(21)0
ROWS_UPDATEDbigint(21)0
SELECT_COMMANDSbigint(21)0
UPDATE_COMMANDSbigint(21)0
OTHER_COMMANDSbigint(21)0
COMMIT_TRANSACTIONSbigint(21)0
ROLLBACK_TRANSACTIONSbigint(21)0
DENIED_CONNECTIONSbigint(21)0
LOST_CONNECTIONSbigint(21)0
ACCESS_DENIEDbigint(21)0
EMPTY_QUERIESbigint(21)0
TOTAL_SSL_CONNECTIONSbigint(21)0
MAX_STATEMENT_TIME_EXCEEDEDbigint(21)0

INDEX_STATISTICS

字段类型默认 链接到 注释 MIME
TABLE_SCHEMAvarchar(192)
TABLE_NAMEvarchar(192)
INDEX_NAMEvarchar(192)
ROWS_READbigint(21)0

INNODB_SYS_DATAFILES

字段类型默认 链接到 注释 MIME
SPACEint(11)0
PATHvarchar(4000)

TABLE_STATISTICS

字段类型默认 链接到 注释 MIME
TABLE_SCHEMAvarchar(192)
TABLE_NAMEvarchar(192)
ROWS_READbigint(21)0
ROWS_CHANGEDbigint(21)0
ROWS_CHANGED_X_INDEXESbigint(21)0

INNODB_SYS_TABLESTATS

字段类型默认 链接到 注释 MIME
TABLE_IDbigint(21)0
NAMEvarchar(193)
STATS_INITIALIZEDvarchar(193)
NUM_ROWSbigint(21)0
CLUST_INDEX_SIZEbigint(21)0
OTHER_INDEX_SIZEbigint(21)0
MODIFIED_COUNTERbigint(21)0
AUTOINCbigint(21)0
REF_COUNTint(11)0

USER_STATISTICS

字段类型默认 链接到 注释 MIME
USERvarchar(128)
TOTAL_CONNECTIONSint(11)0
CONCURRENT_CONNECTIONSint(11)0
CONNECTED_TIMEint(11)0
BUSY_TIMEdouble0
CPU_TIMEdouble0
BYTES_RECEIVEDbigint(21)0
BYTES_SENTbigint(21)0
BINLOG_BYTES_WRITTENbigint(21)0
ROWS_READbigint(21)0
ROWS_SENTbigint(21)0
ROWS_DELETEDbigint(21)0
ROWS_INSERTEDbigint(21)0
ROWS_UPDATEDbigint(21)0
SELECT_COMMANDSbigint(21)0
UPDATE_COMMANDSbigint(21)0
OTHER_COMMANDSbigint(21)0
COMMIT_TRANSACTIONSbigint(21)0
ROLLBACK_TRANSACTIONSbigint(21)0
DENIED_CONNECTIONSbigint(21)0
LOST_CONNECTIONSbigint(21)0
ACCESS_DENIEDbigint(21)0
EMPTY_QUERIESbigint(21)0
TOTAL_SSL_CONNECTIONSbigint(21)0
MAX_STATEMENT_TIME_EXCEEDEDbigint(21)0

INNODB_SYS_INDEXES

字段类型默认 链接到 注释 MIME
INDEX_IDbigint(21)0
NAMEvarchar(193)
TABLE_IDbigint(21)0
TYPEint(11)0
N_FIELDSint(11)0
PAGE_NOint(11)0
SPACEint(11)0

XTRADB_RSEG

字段类型默认 链接到 注释 MIME
rseg_idbigint(21)0
space_idbigint(21)0
zip_sizebigint(21)0
page_nobigint(21)0
max_sizebigint(21)0
curr_sizebigint(21)0

INNODB_CMP_PER_INDEX

字段类型默认 链接到 注释 MIME
database_namevarchar(192)
table_namevarchar(192)
index_namevarchar(192)
compress_opsint(11)0
compress_ops_okint(11)0
compress_timeint(11)0
uncompress_opsint(11)0
uncompress_timeint(11)0

INNODB_TRX

字段类型默认 链接到 注释 MIME
trx_idvarchar(18)
trx_statevarchar(13)
trx_starteddatetime0000-00-00 00:00:00
trx_requested_lock_idvarchar(81)NULL
trx_wait_starteddatetimeNULL
trx_weightbigint(21)0
trx_mysql_thread_idbigint(21)0
trx_queryvarchar(1024)NULL
trx_operation_statevarchar(64)NULL
trx_tables_in_usebigint(21)0
trx_tables_lockedbigint(21)0
trx_lock_structsbigint(21)0
trx_lock_memory_bytesbigint(21)0
trx_rows_lockedbigint(21)0
trx_rows_modifiedbigint(21)0
trx_concurrency_ticketsbigint(21)0
trx_isolation_levelvarchar(16)
trx_unique_checksint(1)0
trx_foreign_key_checksint(1)0
trx_last_foreign_key_errorvarchar(256)NULL
trx_adaptive_hash_latchedint(1)0
trx_adaptive_hash_timeoutbigint(21)0
trx_is_read_onlyint(1)0
trx_autocommit_non_lockingint(1)0

CHANGED_PAGE_BITMAPS

字段类型默认 链接到 注释 MIME
dummybigint(21)0

INNODB_FT_BEING_DELETED

字段类型默认 链接到 注释 MIME
DOC_IDbigint(21)0

INNODB_LOCK_WAITS

字段类型默认 链接到 注释 MIME
requesting_trx_idvarchar(18)
requested_lock_idvarchar(81)
blocking_trx_idvarchar(18)
blocking_lock_idvarchar(81)

INNODB_LOCKS

字段类型默认 链接到 注释 MIME
lock_idvarchar(81)
lock_trx_idvarchar(18)
lock_modevarchar(32)
lock_typevarchar(32)
lock_tablevarchar(1024)
lock_indexvarchar(1024)NULL
lock_spacebigint(21)NULL
lock_pagebigint(21)NULL
lock_recbigint(21)NULL
lock_datavarchar(8192)NULL

INNODB_TABLESPACES_ENCRYPTION

字段类型默认 链接到 注释 MIME
SPACEint(11)0
NAMEvarchar(655)NULL
ENCRYPTION_SCHEMEint(11)0
KEYSERVER_REQUESTSint(11)0
MIN_KEY_VERSIONint(11)0
CURRENT_KEY_VERSIONint(11)0
KEY_ROTATION_PAGE_NUMBERbigint(21)NULL
KEY_ROTATION_MAX_PAGE_NUMBERbigint(21)NULL
CURRENT_KEY_IDint(11)0

XTRADB_INTERNAL_HASH_TABLES

字段类型默认 链接到 注释 MIME
INTERNAL_HASH_TABLE_NAMEvarchar(100)
TOTAL_MEMORYbigint(21)0
CONSTANT_MEMORYbigint(21)0
VARIABLE_MEMORYbigint(21)0

INNODB_SYS_FIELDS

字段类型默认 链接到 注释 MIME
INDEX_IDbigint(21)0
NAMEvarchar(193)
POSint(11)0

INNODB_CMPMEM_RESET

字段类型默认 链接到 注释 MIME
page_sizeint(5)0
buffer_pool_instanceint(11)0
pages_usedint(11)0
pages_freeint(11)0
relocation_opsbigint(21)0
relocation_timeint(11)0

INNODB_CMP

字段类型默认 链接到 注释 MIME
page_sizeint(5)0
compress_opsint(11)0
compress_ops_okint(11)0
compress_timeint(11)0
uncompress_opsint(11)0
uncompress_timeint(11)0

INNODB_FT_INDEX_TABLE

字段类型默认 链接到 注释 MIME
WORDvarchar(255)
FIRST_DOC_IDbigint(21)0
LAST_DOC_IDbigint(21)0
DOC_COUNTbigint(21)0
DOC_IDbigint(21)0
POSITIONbigint(21)0

INNODB_SYS_TABLESPACES

字段类型默认 链接到 注释 MIME
SPACEint(11)0
NAMEvarchar(655)
FLAGint(11)0
FILE_FORMATvarchar(10)NULL
ROW_FORMATvarchar(22)NULL
PAGE_SIZEint(11)0
ZIP_PAGE_SIZEint(11)0

INNODB_MUTEXES

字段类型默认 链接到 注释 MIME
NAMEvarchar(4000)
CREATE_FILEvarchar(4000)
CREATE_LINEint(11)0
OS_WAITSbigint(21)0

INNODB_BUFFER_PAGE_LRU

字段类型默认 链接到 注释 MIME
POOL_IDbigint(21)0
LRU_POSITIONbigint(21)0
SPACEbigint(21)0
PAGE_NUMBERbigint(21)0
PAGE_TYPEvarchar(64)NULL
FLUSH_TYPEbigint(21)0
FIX_COUNTbigint(21)0
IS_HASHEDvarchar(3)NULL
NEWEST_MODIFICATIONbigint(21)0
OLDEST_MODIFICATIONbigint(21)0
ACCESS_TIMEbigint(21)0
TABLE_NAMEvarchar(1024)NULL
INDEX_NAMEvarchar(1024)NULL
NUMBER_RECORDSbigint(21)0
DATA_SIZEbigint(21)0
COMPRESSED_SIZEbigint(21)0
COMPRESSEDvarchar(3)NULL
IO_FIXvarchar(64)NULL
IS_OLDvarchar(3)NULL
FREE_PAGE_CLOCKbigint(21)0

INNODB_SYS_FOREIGN_COLS

字段类型默认 链接到 注释 MIME
IDvarchar(193)
FOR_COL_NAMEvarchar(193)
REF_COL_NAMEvarchar(193)
POSint(11)0

INNODB_CMP_RESET

字段类型默认 链接到 注释 MIME
page_sizeint(5)0
compress_opsint(11)0
compress_ops_okint(11)0
compress_timeint(11)0
uncompress_opsint(11)0
uncompress_timeint(11)0

INNODB_BUFFER_POOL_STATS

字段类型默认 链接到 注释 MIME
POOL_IDbigint(21)0
POOL_SIZEbigint(21)0
FREE_BUFFERSbigint(21)0
DATABASE_PAGESbigint(21)0
OLD_DATABASE_PAGESbigint(21)0
MODIFIED_DATABASE_PAGESbigint(21)0
PENDING_DECOMPRESSbigint(21)0
PENDING_READSbigint(21)0
PENDING_FLUSH_LRUbigint(21)0
PENDING_FLUSH_LISTbigint(21)0
PAGES_MADE_YOUNGbigint(21)0
PAGES_NOT_MADE_YOUNGbigint(21)0
PAGES_MADE_YOUNG_RATEdouble0
PAGES_MADE_NOT_YOUNG_RATEdouble0
NUMBER_PAGES_READbigint(21)0
NUMBER_PAGES_CREATEDbigint(21)0
NUMBER_PAGES_WRITTENbigint(21)0
PAGES_READ_RATEdouble0
PAGES_CREATE_RATEdouble0
PAGES_WRITTEN_RATEdouble0
NUMBER_PAGES_GETbigint(21)0
HIT_RATEbigint(21)0
YOUNG_MAKE_PER_THOUSAND_GETSbigint(21)0
NOT_YOUNG_MAKE_PER_THOUSAND_GETSbigint(21)0
NUMBER_PAGES_READ_AHEADbigint(21)0
NUMBER_READ_AHEAD_EVICTEDbigint(21)0
READ_AHEAD_RATEdouble0
READ_AHEAD_EVICTED_RATEdouble0
LRU_IO_TOTALbigint(21)0
LRU_IO_CURRENTbigint(21)0
UNCOMPRESS_TOTALbigint(21)0
UNCOMPRESS_CURRENTbigint(21)0

INNODB_FT_INDEX_CACHE

字段类型默认 链接到 注释 MIME
WORDvarchar(255)
FIRST_DOC_IDbigint(21)0
LAST_DOC_IDbigint(21)0
DOC_COUNTbigint(21)0
DOC_IDbigint(21)0
POSITIONbigint(21)0

INNODB_SYS_FOREIGN

字段类型默认 链接到 注释 MIME
IDvarchar(193)
FOR_NAMEvarchar(193)
REF_NAMEvarchar(193)
N_COLSint(11)0
TYPEint(11)0

INNODB_METRICS

字段类型默认 链接到 注释 MIME
NAMEvarchar(193)
SUBSYSTEMvarchar(193)
COUNTbigint(21)0
MAX_COUNTbigint(21)NULL
MIN_COUNTbigint(21)NULL
AVG_COUNTdoubleNULL
COUNT_RESETbigint(21)0
MAX_COUNT_RESETbigint(21)NULL
MIN_COUNT_RESETbigint(21)NULL
AVG_COUNT_RESETdoubleNULL
TIME_ENABLEDdatetimeNULL
TIME_DISABLEDdatetimeNULL
TIME_ELAPSEDbigint(21)NULL
TIME_RESETdatetimeNULL
STATUSvarchar(193)
TYPEvarchar(193)
COMMENTvarchar(193)

INNODB_FT_DEFAULT_STOPWORD

字段类型默认 链接到 注释 MIME
valuevarchar(18)

INNODB_CMPMEM

字段类型默认 链接到 注释 MIME
page_sizeint(5)0
buffer_pool_instanceint(11)0
pages_usedint(11)0
pages_freeint(11)0
relocation_opsbigint(21)0
relocation_timeint(11)0

INNODB_SYS_TABLES

字段类型默认 链接到 注释 MIME
TABLE_IDbigint(21)0
NAMEvarchar(655)
FLAGint(11)0
N_COLSint(11)0
SPACEint(11)0
FILE_FORMATvarchar(10)NULL
ROW_FORMATvarchar(12)NULL
ZIP_PAGE_SIZEint(11)0

INNODB_SYS_COLUMNS

字段类型默认 链接到 注释 MIME
TABLE_IDbigint(21)0
NAMEvarchar(193)
POSbigint(21)0
MTYPEint(11)0
PRTYPEint(11)0
LENint(11)0

INNODB_FT_CONFIG

字段类型默认 链接到 注释 MIME
KEYvarchar(193)
VALUEvarchar(193)

INNODB_BUFFER_PAGE

字段类型默认 链接到 注释 MIME
POOL_IDbigint(21)0
BLOCK_IDbigint(21)0
SPACEbigint(21)0
PAGE_NUMBERbigint(21)0
PAGE_TYPEvarchar(64)NULL
FLUSH_TYPEbigint(21)0
FIX_COUNTbigint(21)0
IS_HASHEDvarchar(3)NULL
NEWEST_MODIFICATIONbigint(21)0
OLDEST_MODIFICATIONbigint(21)0
ACCESS_TIMEbigint(21)0
TABLE_NAMEvarchar(1024)NULL
INDEX_NAMEvarchar(1024)NULL
NUMBER_RECORDSbigint(21)0
DATA_SIZEbigint(21)0
COMPRESSED_SIZEbigint(21)0
PAGE_STATEvarchar(64)NULL
IO_FIXvarchar(64)NULL
IS_OLDvarchar(3)NULL
FREE_PAGE_CLOCKbigint(21)0

INNODB_CMP_PER_INDEX_RESET

字段类型默认 链接到 注释 MIME
database_namevarchar(192)
table_namevarchar(192)
index_namevarchar(192)
compress_opsint(11)0
compress_ops_okint(11)0
compress_timeint(11)0
uncompress_opsint(11)0
uncompress_timeint(11)0

XTRADB_READ_VIEW

字段类型默认 链接到 注释 MIME
READ_VIEW_UNDO_NUMBERbigint(21)0
READ_VIEW_LOW_LIMIT_TRX_NUMBERvarchar(18)
READ_VIEW_UPPER_LIMIT_TRX_IDvarchar(18)
READ_VIEW_LOW_LIMIT_TRX_IDvarchar(18)

INNODB_SYS_SEMAPHORE_WAITS

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(21)0
OBJECT_NAMEvarchar(4000)NULL
FILEvarchar(4000)NULL
LINEint(11)0
WAIT_TIMEbigint(21)0
WAIT_OBJECTbigint(21)0
WAIT_TYPEvarchar(16)NULL
HOLDER_THREAD_IDbigint(21)0
HOLDER_FILEvarchar(4000)NULL
HOLDER_LINEint(11)0
CREATED_FILEvarchar(4000)NULL
CREATED_LINEint(11)0
WRITER_THREADbigint(21)0
RESERVATION_MODEvarchar(16)NULL
READERSint(11)0
WAITERS_FLAGbigint(21)0
LOCK_WORDbigint(21)0
LAST_READER_FILEvarchar(4000)NULL
LAST_READER_LINEint(11)0
LAST_WRITER_FILEvarchar(4000)NULL
LAST_WRITER_LINEint(11)0
OS_WAIT_COUNTint(11)0

INNODB_CHANGED_PAGES

字段类型默认 链接到 注释 MIME
space_idint(11)0
page_idint(11)0
start_lsnbigint(21)0
end_lsnbigint(21)0

INNODB_FT_DELETED

字段类型默认 链接到 注释 MIME
DOC_IDbigint(21)0

INNODB_TABLESPACES_SCRUBBING

字段类型默认 链接到 注释 MIME
SPACEbigint(21)0
NAMEvarchar(655)NULL
COMPRESSEDint(11)0
LAST_SCRUB_COMPLETEDdatetimeNULL
CURRENT_SCRUB_STARTEDdatetimeNULL
CURRENT_SCRUB_ACTIVE_THREADSint(11)NULL
CURRENT_SCRUB_PAGE_NUMBERbigint(21)0
CURRENT_SCRUB_MAX_PAGE_NUMBERbigint(21)0