From: Dan Nelson
Date: February 2 2003 8:20pm
Subject: Re: When are MyIsam Tables physically updated?
List-Archive: http://lists.mysql.com/mysql/131475
Message-Id: <20030202202049.GC39529@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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