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. Right now I want every last ounce of speed while our external RAID array is being rebuilt. 2 disk SCSI RAID 0 is not enough. 4 disk SCSI RAID 0 or > 4 disk SCSI 0+1 is much better.
Sincerely, Steven Roussey http://Network54.com/?pp=e > -----Original Message----- > From: David Turner [mailto:[EMAIL PROTECTED]] > > 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 work for MySQL as well. > > > > Would: > > chattr -R +A mysql_datadir_path > > help? > > > > Also, what about editing /ect/sysctl.cong file and add an entry to > > improve filesystem performance, as follows: > > vm.bdflush = 100 1200 128 512 15 5000 500 1884 2 > > Would this work as well in 2.4.16+ kernels (tweaking the numbers > > accordingly for your system)? > > > > Sincerely, > > Steven Roussey > > http://Network54.com/?pp=e > > > > (1) http://www.linuxjournal.com/article.php?sid=5840 > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
