Let op: Deze pagina komt uit ons archief.
Ga voor actuele informatie en nieuws naar onze vernieuwde website.
 
NLUUG
Voorjaarsconferentie
2011
 

Open is efficiënt
 
12 mei, 2011

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.

Voorjaar 2011

2023-05-27
 
Vereniging NLUUG
info@nluug.nl
           postbus 8189
6710 AD Ede