Re: When are MyIsam Tables physically updated?

2003-02-03 Thread Dan Nelson
In the last episode (Feb 03), Grigor, Peter said: > 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. He specifically asked for MySQL-only write activity: > > I am just tryin

RE: When are MyIsam Tables physically updated?

2003-02-03 Thread Grigor, Peter
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,

Re: When are MyIsam Tables physically updated?

2003-02-02 Thread Dan Nelson
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 w

When are MyIsam Tables physically updated?

2003-02-02 Thread Clyde
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 fa