Backport Google's patches V3

Bug #370054 reported by Percona
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona patches
Fix Released
Undecided
Unassigned

Bug Description

Please look into integration next fixes from Google:

Yes, many changes to do IO faster. Some are similar to yours, but I
think some are still missing from XtraDB and the results I get on
iibench may demonstrate they are needed. Changes include:
  * use request arrays in os0file.c with more slots
  * make iteration over request arrays in os0file.c more efficient
  * get rid of the O(N*N) cost for finding adjacent requests in os0file.c

There are a few changes in srv0srv.c that are similar to what you have
but I think your code might need to be updated to write dirty pages
and prefetch insert buffer merges more aggresively. Also code I have
there considers the current number of free slots in the request array
when submitting a batch of requests.

In srv0srv.c insert buffer read prefetches are done aggressively
(perhaps too aggressively) when the user set limit on the max ibuf
size has been exceeded. In your code, the behavior is similar to
traditional Innodb except you have the ibuf accelaration factor.

And also
http://code.google.com/p/google-mysql-tools/wiki/InnodbMutexContention2

Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

All of them might be already imported to the current version.

Changed in percona-patches:
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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