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

         ---               

SELECT * FROM `INNODB_BUFFER_PAGE_LRU`

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_LRU`

Felder der Tabelle `INNODB_BUFFER_PAGE_LRU`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	POOL_ID	bigint	21	nein		unsigned
	2.	LRU_POSITION	bigint	21	nein		unsigned
	3.	SPACE	bigint	21	nein		unsigned
	4.	PAGE_NUMBER	bigint	21	nein		unsigned
	5.	PAGE_TYPE	varchar	64	ja					utf8_general_ci
	6.	FLUSH_TYPE	bigint	21	nein		unsigned
	7.	FIX_COUNT	bigint	21	nein		unsigned
	8.	IS_HASHED	varchar	3	ja					utf8_general_ci
	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	1024	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.	COMPRESSED	varchar	3	ja					utf8_general_ci
	18.	IO_FIX	varchar	64	ja					utf8_general_ci
	19.	IS_OLD	varchar	3	ja					utf8_general_ci
	20.	FREE_PAGE_CLOCK	bigint	21	nein		unsigned

Indizes der Tabelle `INNODB_BUFFER_PAGE_LRU`