MySQL Bugs: #22718: Allow MyISAM to be used with Direct I/O

Bug #22718	Allow MyISAM to be used with Direct I/O
Submitted:	26 Sep 2006 22:31	Modified:	15 Sep 2009 13:45
Reporter:	Chris Calender	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S4 (Feature request)
Version:	All Versions	OS:	Any (All OS)
Assigned to:		CPU Architecture:	Any
Triage:	D5 (Feature request)

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Allow MyISAM tables to be used with Direct I/O.

Currently, Direct I/O can only be used with InnoDB (--forcedirectio option):

http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html

I realize that this cannot be done with MyISAM currently because MySQL does not cache data files.  However, if this is something that can be done in the future, that would be very helpful for those that have Direct I/O.

How to repeat:
N/A

Suggested fix:
N/A

This should be changed to a feature request for Maria. MyISAM will never cache data blocks so this will kill performance. Maria may already cache them today.