🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: sys / x$innodb_buffer_stats_by_schema
7| Campo | Tipo | Null | Key | Default | Extra |
|---|
| object_schema | text | YES | | | |
| allocated | decimal(43,0) | YES | | | |
| data | decimal(43,0) | YES | | | |
| pages | bigint(21) | NO | | 0 | |
| pages_hashed | bigint(21) | NO | | 0 | |
| pages_old | bigint(21) | NO | | 0 | |
| rows_cached | decimal(44,0) | NO | | 0 | |
🔬 Muestra de datos
8 filas
| object_schema | allocated | data | pages | pages_hashed | pages_old | rows_cached |
|---|
| cueva_bench | 115195904 | 110284140 | 7031 | 0 | 2671 | 1552789 |
| phpmyadmin | 327680 | 435 | 20 | 0 | 0 | 1 |
| mysql | 163840 | 31060 | 10 | 0 | 0 | 74 |
| lista_precios_oracle_pi | 81920 | 23474 | 5 | 0 | 0 | 543 |
| cueva_test | 65536 | 15680 | 4 | 0 | 0 | 531 |
| victorias | 65536 | 18907 | 4 | 0 | 0 | 132 |
| InnoDB System | 32768 | 14789 | 2 | 0 | 0 | 122 |
| linux_lab | 16384 | 3456 | 1 | 0 | 0 | 64 |