Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
GRANTEE | varchar(190) | No | ||||
ROLE_NAME | varchar(128) | No | ||||
IS_GRANTABLE | varchar(3) | No | ||||
IS_DEFAULT | varchar(3) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
CHARACTER_SET_NAME | varchar(32) | No | ||||
DEFAULT_COLLATE_NAME | varchar(32) | No | COLLATIONS -> COLLATION_NAME | |||
DESCRIPTION | varchar(60) | No | ||||
MAXLEN | bigint(3) | No | 0 |
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 |
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 |
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(27) | No | ||||
PRIVILEGES | varchar(80) | No | ||||
COLUMN_COMMENT | varchar(1024) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
GRANTEE | varchar(190) | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ROLE_NAME | varchar(128) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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(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 | CHARACTER_SETS -> CHARACTER_SET_NAME | |||
COLLATION_CONNECTION | varchar(32) | No | COLLATIONS -> COLLATION_NAME | |||
DATABASE_COLLATION | varchar(32) | No | COLLATIONS -> COLLATION_NAME |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
VARIABLE_NAME | varchar(64) | No | ||||
VARIABLE_VALUE | varchar(2048) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
VARIABLE_NAME | varchar(64) | No | ||||
VARIABLE_VALUE | varchar(2048) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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 |
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 | int(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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ID | bigint(4) | No | 0 | |||
USER | varchar(128) | 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 | |||
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 | int(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 |
Column | Type | Null | Default | Links to | 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 |
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 |
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 | int(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(189) | 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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
GRANTEE | varchar(190) | No | ||||
TABLE_CATALOG | varchar(512) | No | ||||
TABLE_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | |||
PRIVILEGE_TYPE | varchar(64) | No | ||||
IS_GRANTABLE | varchar(3) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
VARIABLE_NAME | varchar(64) | No | ||||
VARIABLE_VALUE | varchar(2048) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
VARIABLE_NAME | varchar(64) | No | ||||
VARIABLE_VALUE | varchar(2048) | No |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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(2048) | Yes | NULL | |||
TABLE_COMMENT | varchar(2048) | No |
Column | Type | Null | Default | Links to | 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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
GRANTEE | varchar(190) | 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 |
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(189) | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
GRANTEE | varchar(190) | No | ||||
TABLE_CATALOG | varchar(512) | No | ||||
PRIVILEGE_TYPE | varchar(64) | No | ||||
IS_GRANTABLE | varchar(3) | No |
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(189) | 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 | |||
ALGORITHM | varchar(10) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
SRID | smallint(5) | No | 0 | |||
AUTH_NAME | varchar(512) | No | ||||
AUTH_SRID | int(5) | No | 0 | |||
SRTEXT | varchar(2048) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
TABLE_SCHEMA | varchar(192) | No | ||||
TABLE_NAME | varchar(192) | No | ||||
INDEX_NAME | varchar(192) | No | ||||
ROWS_READ | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
SPACE | int(11) | No | 0 | |||
PATH | varchar(4000) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
rseg_id | bigint(21) | No | 0 | |||
space_id | bigint(21) | No | 0 | |||
zip_size | bigint(21) | No | 0 | |||
page_no | bigint(21) | No | 0 | |||
max_size | bigint(21) | No | 0 | |||
curr_size | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
dummy | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
DOC_ID | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
INTERNAL_HASH_TABLE_NAME | varchar(100) | No | ||||
TOTAL_MEMORY | bigint(21) | No | 0 | |||
CONSTANT_MEMORY | bigint(21) | No | 0 | |||
VARIABLE_MEMORY | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
INDEX_ID | bigint(21) | No | 0 | |||
NAME | varchar(193) | No | ||||
POS | int(11) | No | 0 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
NAME | varchar(4000) | No | ||||
CREATE_FILE | varchar(4000) | No | ||||
CREATE_LINE | int(11) | No | 0 | |||
OS_WAITS | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ID | varchar(193) | No | ||||
FOR_COL_NAME | varchar(193) | No | ||||
REF_COL_NAME | varchar(193) | No | ||||
POS | int(11) | No | 0 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
value | varchar(18) | No |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
KEY | varchar(193) | No | ||||
VALUE | varchar(193) | No |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
READ_VIEW_UNDO_NUMBER | bigint(21) | No | 0 | |||
READ_VIEW_LOW_LIMIT_TRX_NUMBER | varchar(18) | No | ||||
READ_VIEW_UPPER_LIMIT_TRX_ID | varchar(18) | No | ||||
READ_VIEW_LOW_LIMIT_TRX_ID | varchar(18) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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_READER_FILE | varchar(4000) | Yes | NULL | |||
LAST_READER_LINE | int(11) | No | 0 | |||
LAST_WRITER_FILE | varchar(4000) | Yes | NULL | |||
LAST_WRITER_LINE | int(11) | No | 0 | |||
OS_WAIT_COUNT | int(11) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
space_id | int(11) | No | 0 | |||
page_id | int(11) | No | 0 | |||
start_lsn | bigint(21) | No | 0 | |||
end_lsn | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
DOC_ID | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
SPACE | bigint(21) | No | 0 | |||
NAME | varchar(655) | Yes | NULL | |||
COMPRESSED | int(11) | 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 |