Re: Linux optimizations for MySQL
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 [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
RE: Linux optimizations for MySQL
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
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 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
RE: Linux optimizations for MySQL
I've never heard of this in a recent kernel/e2fsprogs. Nor have I experienced it (thankfully). Do you any further information? Sincerely, Steven Roussey http://Network54.com/?pp=e -Original Message- From: David Turner [mailto:[EMAIL PROTECTED]] Sent: Monday, February 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 would become corrupt. Dave - 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