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 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
