RE: Linux optimizations for MySQL

2002-02-25 Thread Steven Roussey
25, 2002 4:01 pm > To: [EMAIL PROTECTED] > Subject: Re: Linux optimizations for MySQL > > I thought there was a problem with the datafile corruption if the cache > was > lost when you chattr a file. That the file

Re: Linux optimizations for MySQL

2002-02-25 Thread David Turner
I thought there was a problem with the datafile corruption if the cache was lost when you chattr a file. That the file would become corrupt. Dave On Mon, Feb 25, 2002 at 03:55:23PM -0800, Steven Roussey wrote: > I assume you are talking about bdflush only at 100% (I'm actually trying > 90%). Thin

RE: Linux optimizations for MySQL

2002-02-25 Thread Steven Roussey
I assume you are talking about bdflush only at 100% (I'm actually trying 90%). Thing is, all our tables are constantly changing. Unless the server crashes just after a flush tables command, the tables are likely to get corrupt anyhow. The data altering flow of queries is over 1000/s at the moment.

Re: Linux optimizations for MySQL

2002-02-25 Thread David Turner
If you do that don't you run a greater risk of corruption of the datafiles if the host unexpectedly goes down? Dave On Mon, Feb 25, 2002 at 01:07:06PM -0800, Steven Roussey wrote: > I was reading an article on speeding up Oracle on Linux(1) and thought > their two optimizations for Linux would wo