🗃️ 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 / TABLES
23| Campo | Tipo | Null | Key | Default | Extra |
|---|
| TABLE_CATALOG | varchar(512) | NO | | | |
| TABLE_SCHEMA | varchar(64) | NO | | | |
| TABLE_NAME | varchar(64) | NO | | | |
| TABLE_TYPE | varchar(64) | NO | | | |
| ENGINE | varchar(64) | YES | | | |
| VERSION | bigint(21) unsigned | YES | | | |
| ROW_FORMAT | varchar(10) | YES | | | |
| TABLE_ROWS | bigint(21) unsigned | YES | | | |
| AVG_ROW_LENGTH | bigint(21) unsigned | YES | | | |
| DATA_LENGTH | bigint(21) unsigned | YES | | | |
| MAX_DATA_LENGTH | bigint(21) unsigned | YES | | | |
| INDEX_LENGTH | bigint(21) unsigned | YES | | | |
| DATA_FREE | bigint(21) unsigned | YES | | | |
| AUTO_INCREMENT | bigint(21) unsigned | YES | | | |
| CREATE_TIME | datetime | YES | | | |
| UPDATE_TIME | datetime | YES | | | |
| CHECK_TIME | datetime | YES | | | |
| TABLE_COLLATION | varchar(64) | YES | | | |
| CHECKSUM | bigint(21) unsigned | YES | | | |
| CREATE_OPTIONS | varchar(2048) | YES | | | |
| TABLE_COMMENT | varchar(2048) | NO | | | |
| MAX_INDEX_LENGTH | bigint(21) unsigned | YES | | | |
| TEMPORARY | varchar(1) | YES | | | |
🔬 Muestra de datos
20 filas
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | MAX_INDEX_LENGTH | TEMPORARY |
|---|
| def | information_schema | ALL_PLUGINS | SYSTEM VIEW | Aria | 11 | Page | | 0 | 8192 | 4503599627288576 | 8192 | 0 | | 2026-07-12 02:14:17 | 2026-07-12 02:14:17 | | utf8mb3_general_ci | | max_rows=10340103180330466 transactional=0 | | 137438945280 | Y |
| def | information_schema | APPLICABLE_ROLES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 1565 | 0 | 16743935 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=10699 | | 0 | Y |
| def | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | 11 | Fixed | | 480 | 0 | 16500960 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=34952 | | 0 | Y |
| def | information_schema | CHECK_CONSTRAINTS | SYSTEM VIEW | Aria | 11 | Page | | 0 | 8192 | 4503599627288576 | 8192 | 0 | | 2026-07-12 02:14:17 | 2026-07-12 02:14:17 | | utf8mb3_general_ci | | max_rows=8571907097448676 transactional=0 | | 137438945280 | Y |
| def | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | 11 | Fixed | | 569 | 0 | 16572125 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=29127 | | 0 | Y |
| def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | 11 | Fixed | | 502 | 0 | 16709572 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=33288 | | 0 | Y |
| def | information_schema | COLUMNS | SYSTEM VIEW | Aria | 11 | Page | | 0 | 8192 | 4503599627288576 | 8192 | 0 | | 2026-07-12 02:14:17 | 2026-07-12 02:14:17 | | utf8mb3_general_ci | | max_rows=2926196712200119 transactional=0 | | 137438945280 | Y |
| def | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 3478 | 0 | 16763960 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=4821 | | 0 | Y |
| def | information_schema | ENABLED_ROLES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 388 | 0 | 16604848 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=42799 | | 0 | Y |
| def | information_schema | ENGINES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 732 | 0 | 16684476 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=22795 | | 0 | Y |
| def | information_schema | EVENTS | SYSTEM VIEW | Aria | 11 | Page | | 0 | 8192 | 4503599627288576 | 8192 | 0 | | 2026-07-12 02:14:17 | 2026-07-12 02:14:17 | | utf8mb3_general_ci | | max_rows=653954341807627 transactional=0 | | 137438945280 | Y |
| def | information_schema | FILES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 4004 | 0 | 16756740 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=4185 | | 0 | Y |
| def | information_schema | GLOBAL_STATUS | SYSTEM VIEW | MEMORY | 11 | Fixed | | 12484 | 0 | 16766012 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=1343 | | 0 | Y |
| def | information_schema | GLOBAL_VARIABLES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 12484 | 0 | 16766012 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=1343 | | 0 | Y |
| def | information_schema | KEYWORDS | SYSTEM VIEW | MEMORY | 11 | Fixed | | 195 | 0 | 16356600 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=83886 | | 0 | Y |
| def | information_schema | KEY_CACHES | SYSTEM VIEW | MEMORY | 11 | Fixed | | 660 | 0 | 16674900 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=25266 | | 0 | Y |
| def | information_schema | KEY_COLUMN_USAGE | SYSTEM VIEW | MEMORY | 11 | Fixed | | 4638 | 0 | 16766370 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=3615 | | 0 | Y |
| def | information_schema | KEY_PERIOD_USAGE | SYSTEM VIEW | MEMORY | 11 | Fixed | | 4042 | 0 | 16750048 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=4144 | | 0 | Y |
| def | information_schema | OPTIMIZER_COSTS | SYSTEM VIEW | MEMORY | 11 | Fixed | | 639 | 0 | 16749468 | 0 | 0 | | 2026-07-12 02:14:17 | | | utf8mb3_general_ci | | max_rows=26214 | | 0 | Y |
| def | information_schema | OPTIMIZER_TRACE | SYSTEM VIEW | Aria | 11 | Page | | 0 | 8192 | 4503599627288576 | 8192 | 0 | | 2026-07-12 02:14:17 | 2026-07-12 02:14:17 | | utf8mb3_general_ci | | max_rows=576460752303423487 transactional=0 | | 137438945280 | Y |