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

Campo	Tipo	Null
SPACE	int(11) unsigned	NO
NAME	varchar(655)	NO
FLAG	int(11) unsigned	NO
ROW_FORMAT	varchar(22)	YES
PAGE_SIZE	int(11) unsigned	NO
FILENAME	varchar(512)	NO
FS_BLOCK_SIZE	int(11) unsigned	NO
FILE_SIZE	bigint(21) unsigned	NO
ALLOCATED_SIZE	bigint(21) unsigned	NO

🔬 Muestra de datos

20 filas

SPACE	NAME	FLAG	PAGE_SIZE	FILENAME	FS_BLOCK_SIZE	FILE_SIZE	ALLOCATED_SIZE
0	innodb_system	21	16384	./ibdata1	4096	12582912	12582912
1	innodb_undo001	21	16384	.//undo001	4096	10485760	10485760
2	innodb_undo002	21	16384	.//undo002	4096	10485760	10485760
3	innodb_undo003	21	16384	.//undo003	4096	10485760	10485760
4	mysql/innodb_table_stats	21	16384	./mysql/innodb_table_stats.ibd	4096	65536	65536
5	mysql/innodb_index_stats	21	16384	./mysql/innodb_index_stats.ibd	4096	131072	135168
6	mysql/transaction_registry	21	16384	./mysql/transaction_registry.ibd	4096	114688	114688
7	mysql/gtid_slave_pos	21	16384	./mysql/gtid_slave_pos.ibd	4096	65536	65536
8	phpmyadmin/pma__bookmark	21	16384	./phpmyadmin/pma__bookmark.ibd	4096	65536	69632
9	phpmyadmin/pma__column_info	21	16384	./phpmyadmin/pma__column_info.ibd	4096	81920	81920
10	phpmyadmin/pma__history	21	16384	./phpmyadmin/pma__history.ibd	4096	81920	81920
11	phpmyadmin/pma__pdf_pages	21	16384	./phpmyadmin/pma__pdf_pages.ibd	4096	81920	81920
12	phpmyadmin/pma__recent	21	16384	./phpmyadmin/pma__recent.ibd	4096	65536	69632
13	phpmyadmin/pma__favorite	21	16384	./phpmyadmin/pma__favorite.ibd	4096	65536	65536
14	phpmyadmin/pma__table_uiprefs	21	16384	./phpmyadmin/pma__table_uiprefs.ibd	4096	65536	69632
15	phpmyadmin/pma__relation	21	16384	./phpmyadmin/pma__relation.ibd	4096	81920	81920
16	phpmyadmin/pma__table_coords	21	16384	./phpmyadmin/pma__table_coords.ibd	4096	65536	65536
17	phpmyadmin/pma__table_info	21	16384	./phpmyadmin/pma__table_info.ibd	4096	65536	65536
18	phpmyadmin/pma__tracking	21	16384	./phpmyadmin/pma__tracking.ibd	4096	65536	69632
19	phpmyadmin/pma__userconfig	21	16384	./phpmyadmin/pma__userconfig.ibd	4096	65536	69632