🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: sys / x$schema_flattened_keys
6| Campo | Tipo | Null | Key | Default | Extra |
|---|
| table_schema | varchar(64) | NO | | | |
| table_name | varchar(64) | NO | | | |
| index_name | varchar(64) | NO | | | |
| non_unique | bigint(1) | YES | | | |
| subpart_exists | bigint(1) | YES | | | |
| index_columns | mediumtext | YES | | | |
🔬 Muestra de datos
20 filas
| table_schema | table_name | index_name | non_unique | subpart_exists | index_columns |
|---|
| cueva_bench | ametralla_registros | idx_creado | 1 | 0 | creado_en |
| cueva_bench | ametralla_registros | idx_lote | 1 | 0 | lote |
| cueva_bench | ametralla_registros | PRIMARY | 0 | 0 | id |
| cueva_bench | bench_runs | PRIMARY | 0 | 0 | id |
| cueva_bench | bench_state | PRIMARY | 0 | 0 | id |
| cueva_bench | registros_5m | idx_creado | 1 | 0 | creado_en |
| cueva_bench | registros_5m | idx_lote | 1 | 0 | lote |
| cueva_bench | registros_5m | idx_n | 1 | 0 | n |
| cueva_bench | registros_5m | PRIMARY | 0 | 0 | id |
| cueva_test | bench_runs | PRIMARY | 0 | 0 | id |
| cueva_test | registros | idx_creado | 1 | 0 | creado_en |
| cueva_test | registros | idx_lote | 1 | 0 | lote |
| cueva_test | registros | idx_origen | 1 | 0 | origen |
| cueva_test | registros | PRIMARY | 0 | 0 | id |
| linux_lab | comandos_linux | PRIMARY | 0 | 0 | comando |
| lista_precios_oracle_pi | espectro_frames | idx_sesion_id | 1 | 0 | sesion_id |
| lista_precios_oracle_pi | espectro_frames | idx_sesion_timestamp | 1 | 0 | sesion_id,timestamp_ms |
| lista_precios_oracle_pi | espectro_frames | idx_timestamp_ms | 1 | 0 | timestamp_ms |
| lista_precios_oracle_pi | espectro_frames | PRIMARY | 0 | 0 | id |
| lista_precios_oracle_pi | pi_chunks | PRIMARY | 0 | 0 | id |