Skip to content

Instantly share code, notes, and snippets.

@wedgemartin
Created January 28, 2011 17:58
Show Gist options
  • Save wedgemartin/800652 to your computer and use it in GitHub Desktop.
Save wedgemartin/800652 to your computer and use it in GitHub Desktop.
innodb free buffers 0
-------------------------------------
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