| 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 |
Undefined index: token