Created
January 28, 2011 17:58
-
-
Save wedgemartin/800652 to your computer and use it in GitHub Desktop.
innodb free buffers 0
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
------------------------------------- | |
INSERT BUFFER AND ADAPTIVE HASH INDEX | |
------------------------------------- | |
Ibuf: size 1, free list len 5, seg size 7, | |
175 inserts, 175 merged recs, 148 merges | |
Hash table size 1106407, node heap has 1666 buffer(s) | |
13281.21 hash searches/s, 46230.21 non-hash searches/s | |
--- | |
LOG | |
--- | |
Log sequence number 6 1689269226 | |
Log flushed up to 6 1689268360 | |
Last checkpoint at 6 1689248996 | |
0 pending log writes, 0 pending chkp writes | |
4222 log i/o's done, 3.23 log i/o's/second | |
---------------------- | |
BUFFER POOL AND MEMORY | |
---------------------- | |
Total memory allocated 647890728; in additional pool allocated 21171456 | |
Dictionary memory allocated 162680 | |
Buffer pool size 32768 | |
Free buffers 0 | |
Database pages 31102 | |
Modified db pages 83 | |
Pending reads 193 | |
Pending writes: LRU 0, flush list 0, single page 0 | |
Pages read 16783772, created 47, written 3945 | |
12870.32 reads/s, 0.08 creates/s, 0.77 writes/s | |
Buffer pool hit rate 947 / 1000 | |
-------------- | |
ROW OPERATIONS | |
-------------- | |
8 queries inside InnoDB, 367 queries in queue | |
348 read views open inside InnoDB | |
Main thread process no. 13465, id 46913655662928, state: sleeping | |
Number of rows inserted 3382, updated 54, deleted 0, read 78257551 | |
3.08 inserts/s, 0.15 updates/s, 0.00 deletes/s, 60608.80 reads/s | |
---------------------------- | |
END OF INNODB MONITOR OUTPUT | |
============================ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment