Thanks for the info on 2.4, everyone. I've been doing my testing on 2.4.17.
Here are the "official" results of my testing here (I had the 2.4 time in my previous email messed up): MyISAM: 2.2 -- 11 minutes; 2.4 -- 6 minutes InnoDB: 2.2 -- 21 minutes; 2.4 -- 9 minutes Pretty good increase in performance with InnoDB. I'll be doing some load testing next, but at the same time we're going to move one of our smaller production customers from MyISAM to InnoDB. So, I'll be putting together a plan for disk layout, memory, etc. Should be fun. --Walt Weaver Bozeman, Montana -----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 3:59 PM To: [EMAIL PROTECTED] Subject: Re: MySQL on Linux 2.4 question Walt, a possible reason is that fsync is much faster in Linux-2.4 than in 2.2. Check that the combined size of your log files is 50 % - 100% of the buffer pool size. Small log files cause more disk i/o and more fsyncs. The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer. Somewhere in about version 2.4.10 Linus changed the virtual memory. I am not sure how stable kernels 2.4.10 - .17 are, but at least some people are running them with success. 2.5.1 seems to be unstable. Regards, Heikki ......... Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about 8 minutes. This is obviously a big improvement, if my tests are valid. It's SUCH a big improvement that I'm wondering if I messed something up. Any comments/statement of support/snide remarks will all be appreciated. Thanks, --Walt Weaver Bozeman, Montana --------------------------------------------------------------------- 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
