🗃️ 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_table
8| Campo | Tipo | Null | Key | Default | Extra |
|---|
| object_schema | text | YES | | | |
| object_name | 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
20 filas
| object_schema | object_name | allocated | data | pages | pages_hashed | pages_old | rows_cached |
|---|
| cueva_bench | registros_5m | 102252544 | 98397024 | 6241 | 0 | 2671 | 1929110 |
| cueva_bench | ametralla_registros | 12910592 | 11886840 | 788 | 0 | 0 | 141274 |
| mysql | innodb_index_stats | 65536 | 28721 | 4 | 0 | 0 | 264 |
| mysql | transaction_registry | 65536 | 0 | 4 | 0 | 0 | 0 |
| cueva_test | registros | 49152 | 15447 | 3 | 0 | 0 | 530 |
| lista_precios_oracle_pi | productos | 49152 | 23304 | 3 | 0 | 0 | 533 |
| victorias | bench_runs | 49152 | 18886 | 3 | 0 | 0 | 262 |
| phpmyadmin | pma__column_info | 32768 | 0 | 2 | 0 | 0 | 0 |
| cueva_bench | bench_runs | 16384 | 172 | 1 | 0 | 0 | 1 |
| cueva_bench | bench_state | 16384 | 104 | 1 | 0 | 0 | 1 |
| cueva_test | bench_runs | 16384 | 233 | 1 | 0 | 0 | 1 |
| InnoDB System | SYS_COLUMNS | 16384 | 11642 | 1 | 0 | 0 | 183 |
| InnoDB System | SYS_TABLES | 16384 | 3147 | 1 | 0 | 0 | 60 |
| linux_lab | comandos_linux | 16384 | 3456 | 1 | 0 | 0 | 64 |
| lista_precios_oracle_pi | espectro_frames | 16384 | 0 | 1 | 0 | 0 | 0 |
| lista_precios_oracle_pi | pi_chunks | 16384 | 170 | 1 | 0 | 0 | 10 |
| mysql | gtid_slave_pos | 16384 | 0 | 1 | 0 | 0 | 0 |
| mysql | innodb_table_stats | 16384 | 2339 | 1 | 0 | 0 | 32 |
| phpmyadmin | pma__bookmark | 16384 | 0 | 1 | 0 | 0 | 0 |
| phpmyadmin | pma__central_columns | 16384 | 0 | 1 | 0 | 0 | 0 |