From: Steve Hardy
Date: October 1 2010 10:30am
Subject: InnoDB I/O-bound performance enhancement patch
List-Archive: http://lists.mysql.com/internals/38126
Message-Id:
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Hi guys,
I made a rough AIO-prefetch patch to improve I/O bound performance of InnoDB. I also posted this to percona-discussion, but I hear that there may be some more interested people here.
What the patch does is:
1. Implement read_multi_range_*(), read_range_*() for InnoDB (almost a copy of the default handlers)
2. Add asynchronous prefetches for pages that will be read by the innodb row fetch code