Bug #40604 support multiple background IO threads in InnoDB

Submitted: 9 Nov 2008 18:26 Modified: 12 Aug 2009 17:09
Reporter: Mark Callaghan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.0,5.1 OS:Any
Assigned to: Inaam Rana CPU Architecture:Any
Tags: background.io, Contribution, innodb, thread

[9 Nov 2008 18:26] Mark Callaghan 
Description:
Innodb uses 1 background IO thread to flush dirty buffer cache pages and 1 to handle prefetch read requests. This kills performance for reads when the server has many disks. It is bad for writes when buffered IO is not used. Multiple threads should be supported for reads and writes or support for async IO should be added.

How to repeat:
Run Innodb on a server with many disks and use innodb_flush_method=O_DIRECT

Suggested fix:
Derived from the Google patch http://bazaar.launchpad.net/%7Emdcallag/mysql-patch/5.0-map/revision/2687.

Percona has a different patch.
[10 Nov 2008 15:35] Heikki Tuuri 
Assigning thsi feature request to myself.

We have the AIO patch in pipeline.
[10 Nov 2008 15:50] Heikki Tuuri 
After a second thought, assigning this to Inaam, who is our AIO man.
[12 Aug 2009 17:09] Inaam Rana 
Fixed in plugin 1.0.4

binaries/source and documentation available at innodb.com

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.