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

         ---               

SELECT * FROM `INNODB_BUFFER_POOL_STATS`

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

Felder der Tabelle `INNODB_BUFFER_POOL_STATS`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	POOL_ID	bigint	21	nein		unsigned
	2.	POOL_SIZE	bigint	21	nein		unsigned
	3.	FREE_BUFFERS	bigint	21	nein		unsigned
	4.	DATABASE_PAGES	bigint	21	nein		unsigned
	5.	OLD_DATABASE_PAGES	bigint	21	nein		unsigned
	6.	MODIFIED_DATABASE_PAGES	bigint	21	nein		unsigned
	7.	PENDING_DECOMPRESS	bigint	21	nein		unsigned
	8.	PENDING_READS	bigint	21	nein		unsigned
	9.	PENDING_FLUSH_LRU	bigint	21	nein		unsigned
	10.	PENDING_FLUSH_LIST	bigint	21	nein		unsigned
	11.	PAGES_MADE_YOUNG	bigint	21	nein		unsigned
	12.	PAGES_NOT_MADE_YOUNG	bigint	21	nein		unsigned
	13.	PAGES_MADE_YOUNG_RATE	double		nein
	14.	PAGES_MADE_NOT_YOUNG_RATE	double		nein
	15.	NUMBER_PAGES_READ	bigint	21	nein		unsigned
	16.	NUMBER_PAGES_CREATED	bigint	21	nein		unsigned
	17.	NUMBER_PAGES_WRITTEN	bigint	21	nein		unsigned
	18.	PAGES_READ_RATE	double		nein
	19.	PAGES_CREATE_RATE	double		nein
	20.	PAGES_WRITTEN_RATE	double		nein
	21.	NUMBER_PAGES_GET	bigint	21	nein		unsigned
	22.	HIT_RATE	bigint	21	nein		unsigned
	23.	YOUNG_MAKE_PER_THOUSAND_GETS	bigint	21	nein		unsigned
	24.	NOT_YOUNG_MAKE_PER_THOUSAND_GETS	bigint	21	nein		unsigned
	25.	NUMBER_PAGES_READ_AHEAD	bigint	21	nein		unsigned
	26.	NUMBER_READ_AHEAD_EVICTED	bigint	21	nein		unsigned
	27.	READ_AHEAD_RATE	double		nein
	28.	READ_AHEAD_EVICTED_RATE	double		nein
	29.	LRU_IO_TOTAL	bigint	21	nein		unsigned
	30.	LRU_IO_CURRENT	bigint	21	nein		unsigned
	31.	UNCOMPRESS_TOTAL	bigint	21	nein		unsigned
	32.	UNCOMPRESS_CURRENT	bigint	21	nein		unsigned

Indizes der Tabelle `INNODB_BUFFER_POOL_STATS`