On Tuesday, October 21, 2003, at 12:48 PM, 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)
Can you make changes to the site's software? Perhaps more aggressive caching would help. It looks like Xoops is using PHP, so you could try using something like php memcache (http://lucifer.intercosmos.net/) or Turck MMCache (http://sourceforge.net/projects/turck-mmcache) or any other PHP cache / accelerator product.
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.
Will Xoops take advantage of InnoDB's transactional capabilities?
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.
Can you add more RAM? What type of disks are you using in the RAID setup? Is it hardware or software RAID?
- Gabriel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
