Re: MyISAM updates synchronous or not ?
>No, writes are performed in MyISAM in an asynchronous manner, with the operating >system performing disk synching at periodic intervals.
Right. I suspected as much, but it doesn't seem to be documented.
>If you need synched writes, use the InnoDB storage engine, and read up on the >innodb_trx_flush_at_commit variable.
Yes, I'm aware of this, but I'd rather fix it at the app. level.
Thanks for the info.
Steve Collyer
Subject
Views
Written By
Posted
3305
August 01, 2005 09:37AM
2472
August 01, 2005 10:09AM
Re: MyISAM updates synchronous or not ?
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.