SHOW ENGINE INNODB STATUS should print insert/change buffer size in bytes
Bug #1079044 reported by
Laurynas Biveinis
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Wishlist
|
Unassigned | |||
5.5 |
Triaged
|
Wishlist
|
Unassigned | |||
5.6 |
Triaged
|
Wishlist
|
Unassigned | |||
5.7 |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
Original suggestion by Justin Swanhart.
tags: | added: innodb |
To post a comment you must log in.
Since change buffers are maintained as index tree in the buffer pool, the size given in
'Ibuf: size 1, free list len 0, seg size 2, 0 merges'
multiplied by UNIV_PAGE_SIZE should give the total size of the insert buffer in memory in kB.
However, it might need to be checked whether "Database pages"
under "BUFFER POOL AND MEMORY" includes the pages of change
buffer or not.
I also checked I_S.BUFFER_ POOL_PAGES, and noticed that Ibuf pages
are not included there.