Boosting Enterprise MySQL performance by implementing I/O prefetch for InnoDB

Steve Hardy, Zarafa

Abstract

Tests have shown that InnoDB is not using traditional spindle-based I/O subsystems to their maximum potential while doing OLTP workloads with I/O-bound queries; Pages are requested sequentially from the disk system instead of asynchronously, even when using MySQL 5.5's native Aynchronous I/O support. The presentation shows the advantages of implementing a prefetch mechanism which can result in large gains in I/O performance.

More information of the Innodb prefetch improvement.

Bio

Steve Hardy is CTO van Zarafa en tevens de coredeveloper van de innodb prefetch patch.