🗃️ BASES / MARIADB

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

Conexión DB

Tablas visibles

information_schema

Nivel actual

🧬 Columnas: information_schema / INNODB_BUFFER_PAGE_LRU

Campo	Tipo	Null
POOL_ID	int(11) unsigned	NO
LRU_POSITION	bigint(21) unsigned	NO
SPACE	int(11) unsigned	NO
PAGE_NUMBER	int(11) unsigned	NO
PAGE_TYPE	varchar(64)	YES
FLUSH_TYPE	int(11) unsigned	NO
FIX_COUNT	int(11) unsigned	NO
IS_HASHED	int(1)	NO
NEWEST_MODIFICATION	bigint(21) unsigned	NO
OLDEST_MODIFICATION	bigint(21) unsigned	NO
ACCESS_TIME	bigint(21) unsigned	NO
TABLE_NAME	varchar(1024)	YES
INDEX_NAME	varchar(64)	YES
NUMBER_RECORDS	bigint(21) unsigned	NO
DATA_SIZE	bigint(21) unsigned	NO
COMPRESSED_SIZE	bigint(21) unsigned	NO
COMPRESSED	int(1)	NO
IO_FIX	enum('IO_NONE','IO_READ','IO_WRITE')	NO
IS_OLD	int(1)	YES
FREE_PAGE_CLOCK	bigint(21) unsigned	NO

🔬 Muestra de datos

20 filas

LRU_POSITION	SPACE	PAGE_NUMBER	PAGE_TYPE	NEWEST_MODIFICATION	ACCESS_TIME	TABLE_NAME	INDEX_NAME	NUMBER_RECORDS	DATA_SIZE	IO_FIX
0	47	25352	INDEX	2543795027	42058827	`cueva_bench`.`registros_5m`	idx_lote	928	15776	IO_NONE
1	47	25350	INDEX	2543437160	42058826	`cueva_bench`.`registros_5m`	idx_lote	928	15776	IO_NONE
2	47	25349	INDEX	2543258258	42058825	`cueva_bench`.`registros_5m`	idx_lote	928	15776	IO_NONE
3	47	25347	INDEX	2542900461	42058824	`cueva_bench`.`registros_5m`	idx_lote	928	15776	IO_NONE
4	47	25346	INDEX	2542721560	42058824	`cueva_bench`.`registros_5m`	idx_lote	928	15776	IO_NONE
5	47	25344	INDEX	2542363591	42058822	`cueva_bench`.`registros_5m`	idx_lote	928	15776	IO_NONE
6	47	24895	INDEX	2542184786	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
7	47	24893	INDEX	2541826642	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
8	47	24891	INDEX	2541469232	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
9	47	24890	INDEX	2541291252	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
10	47	24888	INDEX	2540935296	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
11	47	24887	INDEX	2540757320	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
12	47	24885	INDEX	2540400897	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
13	47	24883	INDEX	2539883432	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
14	47	24882	INDEX	2539598175	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
15	47	24880	INDEX	2538857646	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
16	47	24879	INDEX	2538552830	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
17	47	24877	INDEX	2537925713	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
18	47	24876	INDEX	2537748619	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE
19	47	24874	INDEX	2537394345	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	IO_NONE