Percona Server moved to https://jira.percona.com/projects/PS

SHOW ENGINE INNODB STATUS should print insert/change buffer size in bytes

Bug #1079044 reported by Laurynas Biveinis on 2012-11-15

This bug affects 1 person

	Status	Importance	Assigned to
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

Original suggestion by Justin Swanhart.

Tags:

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2012-11-27:

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.

Laurynas Biveinis (laurynas-biveinis) on 2016-03-24

tags:

added: innodb

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2390

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Bug watches keep track of this bug in other bug trackers.