🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
information_schema
Nivel actual
🧬 Columnas: information_schema / PARTITIONS
25| Campo | Tipo | Null | Key | Default | Extra |
|---|
| TABLE_CATALOG | varchar(512) | NO | | | |
| TABLE_SCHEMA | varchar(64) | NO | | | |
| TABLE_NAME | varchar(64) | NO | | | |
| PARTITION_NAME | varchar(64) | YES | | | |
| SUBPARTITION_NAME | varchar(64) | YES | | | |
| PARTITION_ORDINAL_POSITION | bigint(21) unsigned | YES | | | |
| SUBPARTITION_ORDINAL_POSITION | bigint(21) unsigned | YES | | | |
| PARTITION_METHOD | varchar(18) | YES | | | |
| SUBPARTITION_METHOD | varchar(12) | YES | | | |
| PARTITION_EXPRESSION | longtext | YES | | | |
| SUBPARTITION_EXPRESSION | longtext | YES | | | |
| PARTITION_DESCRIPTION | longtext | YES | | | |
| TABLE_ROWS | bigint(21) unsigned | NO | | | |
| AVG_ROW_LENGTH | bigint(21) unsigned | NO | | | |
| DATA_LENGTH | bigint(21) unsigned | NO | | | |
| MAX_DATA_LENGTH | bigint(21) unsigned | YES | | | |
| INDEX_LENGTH | bigint(21) unsigned | NO | | | |
| DATA_FREE | bigint(21) unsigned | NO | | | |
| CREATE_TIME | datetime | YES | | | |
| UPDATE_TIME | datetime | YES | | | |
| CHECK_TIME | datetime | YES | | | |
| CHECKSUM | bigint(21) unsigned | YES | | | |
| PARTITION_COMMENT | varchar(80) | NO | | | |
| NODEGROUP | varchar(12) | NO | | | |
| TABLESPACE_NAME | varchar(64) | YES | | | |
🔬 Muestra de datos
20 filas
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
|---|
| def | information_schema | ALL_PLUGINS | | | | | | | | | | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2026-07-12 02:09:22 | 2026-07-12 02:09:22 | | | | | |
| def | information_schema | APPLICABLE_ROLES | | | | | | | | | | 0 | 1565 | 0 | 16743935 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | CHARACTER_SETS | | | | | | | | | | 0 | 480 | 0 | 16500960 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | CHECK_CONSTRAINTS | | | | | | | | | | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2026-07-12 02:09:22 | 2026-07-12 02:09:22 | | | | | |
| def | information_schema | COLLATIONS | | | | | | | | | | 0 | 569 | 0 | 16572125 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | | | | | | | | | | 0 | 502 | 0 | 16709572 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | COLUMNS | | | | | | | | | | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2026-07-12 02:09:22 | 2026-07-12 02:09:22 | | | | | |
| def | information_schema | COLUMN_PRIVILEGES | | | | | | | | | | 0 | 3478 | 0 | 16763960 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | ENABLED_ROLES | | | | | | | | | | 0 | 388 | 0 | 16604848 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | ENGINES | | | | | | | | | | 0 | 732 | 0 | 16684476 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | EVENTS | | | | | | | | | | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2026-07-12 02:09:22 | 2026-07-12 02:09:22 | | | | | |
| def | information_schema | FILES | | | | | | | | | | 0 | 4004 | 0 | 16756740 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | GLOBAL_STATUS | | | | | | | | | | 0 | 12484 | 0 | 16766012 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | GLOBAL_VARIABLES | | | | | | | | | | 0 | 12484 | 0 | 16766012 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | KEYWORDS | | | | | | | | | | 0 | 195 | 0 | 16356600 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | KEY_CACHES | | | | | | | | | | 0 | 660 | 0 | 16674900 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | KEY_COLUMN_USAGE | | | | | | | | | | 0 | 4638 | 0 | 16766370 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | KEY_PERIOD_USAGE | | | | | | | | | | 0 | 4042 | 0 | 16750048 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | OPTIMIZER_COSTS | | | | | | | | | | 0 | 639 | 0 | 16749468 | 0 | 0 | 2026-07-12 02:09:22 | | | | | | |
| def | information_schema | OPTIMIZER_TRACE | | | | | | | | | | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2026-07-12 02:09:22 | 2026-07-12 02:09:22 | | | | | |