🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: mysql / innodb_table_stats
6| Campo | Tipo | Null | Key | Default | Extra |
|---|
| database_name | varchar(64) | NO | PRI | | |
| table_name | varchar(199) | NO | PRI | | |
| last_update | timestamp | NO | | current_timestamp() | on update current_timestamp() |
| n_rows | bigint(20) unsigned | NO | | | |
| clustered_index_size | bigint(20) unsigned | NO | | | |
| sum_of_other_index_sizes | bigint(20) unsigned | NO | | | |
🔬 Muestra de datos
20 filas
| database_name | table_name | last_update | n_rows | clustered_index_size | sum_of_other_index_sizes |
|---|
| bitacora | frases | 2026-06-27 06:12:07 | 14 | 1 | 9 |
| bitacora | usuarios | 2026-06-14 21:39:23 | 0 | 1 | 1 |
| caja_negra | categorias | 2026-06-30 08:40:10 | 8 | 1 | 1 |
| caja_negra | registros | 2026-06-30 11:23:01 | 8 | 1 | 4 |
| fakenews_lab | frases_bigramas | 2026-08-12 19:02:06 | 709 | 30 | 6 |
| laboratorio | personas_fake | 2026-06-22 05:07:11 | 399578 | 5224 | 6266 |
| laboratorio | pi_chunks | 2026-06-20 10:10:24 | 0 | 1 | 1 |
| libro_vida | daily_focus | 2026-08-13 08:41:13 | 12 | 1 | 1 |
| libro_vida | habit_logs | 2026-06-28 08:27:21 | 2 | 1 | 2 |
| libro_vida | habits | 2026-06-28 07:55:25 | 3 | 1 | 0 |
| libro_vida | life_entries | 2026-06-28 07:55:25 | 0 | 1 | 1 |
| libro_vida | life_lists | 2026-06-28 08:27:29 | 10 | 1 | 2 |
| libro_vida | mood_entries | 2026-06-28 08:01:42 | 1 | 1 | 2 |
| libro_vida | quick_notes | 2026-06-28 07:57:54 | 3 | 1 | 1 |
| libro_vida | reminders | 2026-06-28 07:55:25 | 3 | 1 | 2 |
| libro_vida | settings | 2026-06-28 07:55:25 | 0 | 1 | 1 |
| libro_vida | small_wins | 2026-06-28 07:55:25 | 5 | 1 | 1 |
| libro_vida | week_events | 2026-06-28 07:55:35 | 4 | 1 | 2 |
| linux_comandos | comandos | 2026-07-07 06:38:27 | 7 | 1 | 3 |
| lista_precios | espectro_frames | 2026-06-20 07:34:33 | 0 | 1 | 3 |