🗃️ BASES / MARIADB

Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.

🏠 Tres puertas🗃️ Bases📋 Tablas de mysql
MariaDB/mysql/innodb_index_stats
OK
Conexión DB
31
Tablas visibles
mysql
Nivel actual

🧬 Columnas: mysql / innodb_index_stats

8
CampoTipoNullKeyDefaultExtra
database_namevarchar(64)NOPRI
table_namevarchar(199)NOPRI
index_namevarchar(64)NOPRI
last_updatetimestampNOcurrent_timestamp()on update current_timestamp()
stat_namevarchar(64)NOPRI
stat_valuebigint(20) unsignedNO
sample_sizebigint(20) unsignedYES
stat_descriptionvarchar(1024)NO

🔬 Muestra de datos

20 filas
database_nametable_nameindex_namelast_updatestat_namestat_valuesample_sizestat_description
bitacorafrasesFTS_DOC_ID_INDEX2026-06-27 06:12:07n_diff_pfx01111FTS_DOC_ID
bitacorafrasesFTS_DOC_ID_INDEX2026-06-27 06:12:07n_leaf_pages1Number of leaf pages in the index
bitacorafrasesFTS_DOC_ID_INDEX2026-06-27 06:12:07size1Number of pages in the index
bitacorafrasesPRIMARY2026-06-27 06:12:07n_diff_pfx01111id
bitacorafrasesPRIMARY2026-06-27 06:12:07n_leaf_pages1Number of leaf pages in the index
bitacorafrasesPRIMARY2026-06-27 06:12:07size1Number of pages in the index
bitacorafrasesfk_frases_created_by2026-06-27 06:12:07n_diff_pfx0111created_by
bitacorafrasesfk_frases_created_by2026-06-27 06:12:07n_diff_pfx02111created_by,id
bitacorafrasesfk_frases_created_by2026-06-27 06:12:07n_leaf_pages1Number of leaf pages in the index
bitacorafrasesfk_frases_created_by2026-06-27 06:12:07size1Number of pages in the index
bitacorafrasesfk_frases_updated_by2026-06-27 06:12:07n_diff_pfx0111updated_by
bitacorafrasesfk_frases_updated_by2026-06-27 06:12:07n_diff_pfx02111updated_by,id
bitacorafrasesfk_frases_updated_by2026-06-27 06:12:07n_leaf_pages1Number of leaf pages in the index
bitacorafrasesfk_frases_updated_by2026-06-27 06:12:07size1Number of pages in the index
bitacorafrasesidx_autor2026-06-27 06:12:07n_diff_pfx0181autor
bitacorafrasesidx_autor2026-06-27 06:12:07n_diff_pfx02111autor,id
bitacorafrasesidx_autor2026-06-27 06:12:07n_leaf_pages1Number of leaf pages in the index
bitacorafrasesidx_autor2026-06-27 06:12:07size1Number of pages in the index
bitacorafrasesidx_categoria2026-06-27 06:12:07n_diff_pfx0181categoria
bitacorafrasesidx_categoria2026-06-27 06:12:07n_diff_pfx02111categoria,id