Rainer Sip wrote: > > I'm running a community site (Xoops) on Mysql 4.0.14. > > I found that the speed of my site is slow during peak hours, when there are 450 > concurrent uers hanging on the site. Mytop showed that the queries per second maxed > at 500. I believe this could be higher, provided that I have it running on a > dedicated machine. I also noticed the load average is very high (12+ during peak > hours) > > In the mid run I'm planning to mirgrate to innodb for higher concurrency (I'm > currently using myisam). However, I'm seeking suggestions in fine tuning the > parameters. > > The machine is a Dell PowerEdge 4400 with 2 Xeon 1G processors and 2GB of memory. > There are 4 disks running raid 0+1. Attached the my.cnf for your easy review. Thanks > a lot in advance. > <snip>
Rainer, The "12+" load avg. is HIGH. What is % idle when the load average is high? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]