On Fri, Nov 07, 2003 at 05:03:43PM -0600, William Baker wrote: > Sorry for the slow reply. I was battling SCSI controller bugs as well > as database issues. I have given up on the software raid for now > because it is unstable.
Really? I've run Linux software RAID quite happily on several systems (both RAID-5 and RAID-1) for years. > Back to the subject at hand: performance. > > You are right, the "load" is meaningless outside the context of a > specific machine...and often even inside the context of a specific > machine. top showed that the system was disk (iowait) bound. Changing > the innodb_log_buffer_size (64MB) and innodb_log_file_size (32MB) was > the trick to increasing performance significantly. I was able to cut > index build time in half. Ah, good. > There is still way too much disk activity during the index build. Since > the whole file fits in cache at several levels, it makes no sense that > the CPU still reflects an average of >20% in iowait. At least user > space is now around 70% cpu usage, which is up from under 50%. Other > than digging into souce code and using strace, I'm clueless as to how to > improve this situation. I think it's still way too high. I've tried > variations of all the system variables that appear to be relevant. Did we already talk about the log flush method you're using with InnoDB? I don't recall... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 55 days, processed 2,061,950,033 queries (433/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
