lp:~laurynas-biveinis/percona-server/xtradb-srv-activity-fixes

Created by Laurynas Biveinis and last modified
Get this branch:
bzr branch lp:~laurynas-biveinis/percona-server/xtradb-srv-activity-fixes
Only Laurynas Biveinis can upload to this branch. If you are Laurynas Biveinis please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information

Recent revisions

451. By Laurynas Biveinis on 2013-10-03

Fix InnoDB server activity accounting for page cleaner heuristics,
implementing
https://blueprints.launchpad.net/percona-server/+spec/xtradb-cleaner-srv-activity-fixes
and fixing bug 1234562 / http://bugs.mysql.com/bug.php?id=70500.

The LRU side of the issue (bug 1234562) is caused by the fact that
page cleaner will not perform LRU flushes for background tasks that
need free pages because they are not bumping server activity. Fixed
by performing the flushes unconditionally as there appears to be no
link between free page availability and server activity in the first
place. If the server is truly idle, the LRU flush request will find
full free lists and will not do anything, matching the intended
previous behavior.

The flush list side of the issue is the page cleaner performing
innodb_io_capacity-sized flushes regardless of the background tasks
potentially doing heavy buffer pool I/O at the same time. In this
case innodb_io_capacity batch size is too large and should be reduced
as if with query threads present. Fix by adding server activity
counter bumps to background tasks that do a non-trivial amount of
buffer pool writing: purge and change buffer merge.

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
lp:percona-server/5.6
This branch contains Public information 
Everyone can see this information.