This is not so...Mysql will write out the data for MyIsam tables without calling the operating system to do an fsync()...it's up to the OS to flush dirty pages to disk.
See http://www.mysql.com/doc/en/Command-line_options.html under the --flush command line parameter. Peter <^_^> > -----Original Message----- > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 02, 2003 3:21 PM > To: Clyde > Cc: [EMAIL PROTECTED] > Subject: Re: When are MyIsam Tables physically updated? > > > In the last episode (Feb 02), Clyde said: > > Hi, > > > > I am just trying to get a handle on when tables are physically > > written to disk. (ignoring whatever operating system level caching > > that may be going on) > > > > IE If you do some updates/inserts to a MyIsam table and then have a > > power failure will you ALWAYS loose those updates (Even if the power > > failure is after say 5 minutes of inactivity on a table, assuming no > > intervening FLUSH command), or does the server do a write to disk > > based on some algorithm (eg low activity or Number of updates)? > > MySQL always writes MyISAM table data out immediately. Index updates > may be cached in ram if you have delay_key_write turned on. > > -- > Dan Nelson > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
