Re: MyISAM updates synchronous or not ?
Posted by:
Jay Pipes
Date: August 01, 2005 10:09AM
No, writes are performed in MyISAM in an asynchronous manner, with the operating system performing disk synching at periodic intervals. If you need synched writes, use the InnoDB storage engine, and read up on the innodb_trx_flush_at_commit variable. Synchronous writes depend very much on the underlying operating system and whether or not the hard drive(s) have their own caching mechanisms.
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
3305
August 01, 2005 09:37AM
Re: MyISAM updates synchronous or not ?
2471
August 01, 2005 10:09AM
2533
August 01, 2005 10:28AM
2162
August 01, 2005 10:47AM
2174
August 02, 2005 03:15AM
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.