[Tools]  Datenbank: `information_schema`  Tabelle: `INNODB_BUFFER_PAGE`

         ---               

SELECT * FROM `INNODB_BUFFER_PAGE`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `INNODB_BUFFER_PAGE`

Felder der Tabelle `INNODB_BUFFER_PAGE`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	POOL_ID	int	11	nein		unsigned
	2.	BLOCK_ID	bigint	21	nein		unsigned
	3.	SPACE	int	11	nein		unsigned
	4.	PAGE_NUMBER	int	11	nein		unsigned
	5.	PAGE_TYPE	varchar	64	ja					utf8_general_ci
	6.	FLUSH_TYPE	int	11	nein		unsigned
	7.	FIX_COUNT	int	11	nein		unsigned
	8.	IS_HASHED	int	1	nein
	9.	NEWEST_MODIFICATION	bigint	21	nein		unsigned
	10.	OLDEST_MODIFICATION	bigint	21	nein		unsigned
	11.	ACCESS_TIME	bigint	21	nein		unsigned
	12.	TABLE_NAME	varchar	1024	ja					utf8_general_ci
	13.	INDEX_NAME	varchar	64	ja					utf8_general_ci
	14.	NUMBER_RECORDS	bigint	21	nein		unsigned
	15.	DATA_SIZE	bigint	21	nein		unsigned
	16.	COMPRESSED_SIZE	bigint	21	nein		unsigned
	17.	PAGE_STATE	enum('NOT_USED','MEMORY','REMOVE_HASH','FILE_PAGE')		nein					utf8_general_ci
	18.	IO_FIX	enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN')		nein					utf8_general_ci
	19.	IS_OLD	int	1	nein
	20.	FREE_PAGE_CLOCK	bigint	21	nein		unsigned

Indizes der Tabelle `INNODB_BUFFER_PAGE`