🗃️ BASES / MARIADB

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

OK

Conexión DB

82

Tablas visibles

information_schema

Nivel actual

🧬 Columnas: information_schema / OPTIMIZER_COSTS

13

Campo	Tipo	Null	Key	Default	Extra
ENGINE	varchar(192)	NO
OPTIMIZER_DISK_READ_COST	decimal(9,6)	NO
OPTIMIZER_INDEX_BLOCK_COPY_COST	decimal(9,6)	NO
OPTIMIZER_KEY_COMPARE_COST	decimal(9,6)	NO
OPTIMIZER_KEY_COPY_COST	decimal(9,6)	NO
OPTIMIZER_KEY_LOOKUP_COST	decimal(9,6)	NO
OPTIMIZER_KEY_NEXT_FIND_COST	decimal(9,6)	NO
OPTIMIZER_DISK_READ_RATIO	decimal(9,6)	NO
OPTIMIZER_ROW_COPY_COST	decimal(9,6)	NO
OPTIMIZER_ROW_LOOKUP_COST	decimal(9,6)	NO
OPTIMIZER_ROW_NEXT_FIND_COST	decimal(9,6)	NO
OPTIMIZER_ROWID_COMPARE_COST	decimal(9,6)	NO
OPTIMIZER_ROWID_COPY_COST	decimal(9,6)	NO

🔬 Muestra de datos

9 filas

ENGINE	OPTIMIZER_DISK_READ_COST	OPTIMIZER_INDEX_BLOCK_COPY_COST	OPTIMIZER_KEY_COMPARE_COST	OPTIMIZER_KEY_COPY_COST	OPTIMIZER_KEY_LOOKUP_COST	OPTIMIZER_KEY_NEXT_FIND_COST	OPTIMIZER_DISK_READ_RATIO	OPTIMIZER_ROW_COPY_COST	OPTIMIZER_ROW_LOOKUP_COST	OPTIMIZER_ROW_NEXT_FIND_COST	OPTIMIZER_ROWID_COMPARE_COST	OPTIMIZER_ROWID_COPY_COST
default	10.240000	0.035600	0.011361	0.015685	0.435777	0.082347	0.020000	0.060866	0.130839	0.045916	0.002653	0.002653
MyISAM	10.240000	0.035600	0.011361	0.015685	0.550142	0.090585	0.020000	0.060866	1.014818	0.063539	0.002653	0.002653
CSV	10.240000	0.035600	0.011361	0.015685	0.435777	0.082347	0.020000	0.060866	0.130839	0.045916	0.002653	0.002653
MEMORY	0.000000	0.000000	0.011361	0.000000	0.000000	0.000000	0.000000	0.002334	0.000000	0.008017	0.002653	0.002653
Aria	10.240000	0.035600	0.011361	0.015685	0.435777	0.082347	0.020000	0.060866	0.130839	0.045916	0.002653	0.002653
MRG_MyISAM	10.240000	0.035600	0.011361	0.015685	0.550142	0.090585	0.020000	0.060866	1.014818	0.063539	0.002653	0.002653
InnoDB	10.240000	0.035600	0.011361	0.015685	0.791120	0.099000	0.020000	0.060870	0.765970	0.070130	0.002653	0.002653
PERFORMANCE_SCHEMA	10.240000	0.035600	0.011361	0.015685	0.435777	0.082347	0.020000	0.060866	0.130839	0.045916	0.002653	0.002653
SEQUENCE	0.000000	0.035600	0.011361	0.006239	0.006239	0.006239	0.000000	0.006239	0.006239	0.006239	0.002653	0.002653