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

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

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%). Thing

RE: Linux optimizations for MySQL

2002-02-25 Thread Steven Roussey
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 would become corrupt. Dave