List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 2 2003 8:20pm
Subject:Re: When are MyIsam Tables physically updated?
View as plain text  
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
	dnelson@stripped
Thread
When are MyIsam Tables physically updated?Clyde2 Feb
  • Windows Users FeedBackClyde2 Feb
  • Re: When are MyIsam Tables physically updated?Dan Nelson2 Feb
  • Re: Windows Users FeedBackGerald R. Jensen2 Feb
  • hang then resume....pazenko4 Feb
RE: When are MyIsam Tables physically updated?Peter Grigor3 Feb
  • Re: When are MyIsam Tables physically updated?Dan Nelson3 Feb
RE: hang then resume....Victor Pendleton5 Feb
  • Re: hang then resume....pazenko5 Feb
  • Re: hang then resume....pazenko6 Feb