MySQL Forums
Forum List  »  MyISAM

Re: forcedirectio and MyISAM
Posted by: Ingo Strüwing
Date: March 28, 2006 02:39AM

Hi,

no. Every write of data on MyISAM is directly done to the data file using the system call write(2). This goes into the filesystem buffer. No sync(2), fsync(2), or fdatasync(2) is done. This means that the data is not immediately flushed to disk. It is totally up to the filesystem when to flush the buffer.

I did some reading about forcedirectio. Now I agree that reads will be affected as well as writes.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3661
March 25, 2006 03:53PM
1866
March 27, 2006 03:03AM
1834
March 27, 2006 10:40AM
Re: forcedirectio and MyISAM
2019
March 28, 2006 02:39AM


Sorry, you can't reply to this topic. It has been closed.

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.