🗃️ 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

Campo	Tipo	Null
POOL_ID	int(11) unsigned	NO
BLOCK_ID	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
PAGE_STATE	enum('NOT_USED','MEMORY','REMOVE_HASH','FILE_PAGE')	NO
IO_FIX	enum('IO_NONE','IO_READ','IO_WRITE')	NO
IS_OLD	int(1)	NO
FREE_PAGE_CLOCK	bigint(21) unsigned	NO

🔬 Muestra de datos

20 filas

BLOCK_ID	SPACE	PAGE_NUMBER	PAGE_TYPE	NEWEST_MODIFICATION	ACCESS_TIME	TABLE_NAME	INDEX_NAME	NUMBER_RECORDS	DATA_SIZE	PAGE_STATE	IO_FIX	IS_OLD
0	47	48747	INDEX	3056704303	42060885	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
1	0	45	INDEX	34749	43038364	`SYS_FOREIGN`	ID_IND	0	0	FILE_PAGE	IO_NONE	1
2	47	46416	INDEX	3000973319	42060649	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
3	47	24814	INDEX	2538220588	42058787	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
4	47	24809	INDEX	2537217196	42058784	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
5	0	49	INDEX	37142	43102060	`SYS_VIRTUAL`	BASE_IDX	0	0	FILE_PAGE	IO_NONE	1
6	47	46414	INDEX	3000615483	42060648	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	0
7	47	46417	INDEX	3001152234	42060650	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	0
8	47	24807	INDEX	2536863097	42058783	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
9	47	24815	INDEX	2538552730	42058788	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
10	47	24806	INDEX	2536686046	42058783	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
11	47	48746	INDEX	3056523849	42060885	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	0
12	47	47565	INDEX	3024298405	42060770	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	0
13	0	0	UNKNOWN	0	0			0	0	NOT_USED	IO_NONE	0
14	47	47567	INDEX	3024652623	42060771	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	0
15	47	46418	INDEX	3001331152	42060651	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
16	47	31267	INDEX	2675182556	42059398	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
17	47	24804	INDEX	2536331875	42058782	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1
18	47	28931	INDEX	2618663591	0	`cueva_bench`.`registros_5m`	idx_n	928	15776	FILE_PAGE	IO_NONE	1
19	47	24817	INDEX	2539278873	42058789	`cueva_bench`.`registros_5m`	idx_lote	928	15776	FILE_PAGE	IO_NONE	1