Re: forcedirectio and MyISAM
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
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.