I'm looking for someone to help troubleshoot my community website. For some reason, the site runs really slow at times, despite running on more than adequate equipment. Your job will be to find the cause of the problem, and to fix it so that the site's speed is considerably improved. My community site runs Joomla, along with Coppermine Photogallery, and PHPBB.
The Server Specs Are As Follows:
We have two servers. One server is a dedicated Web Server, and the other is a dedicated Database Server. The specs for both of the servers are the same:
Dual Quad-Core 5300 Intel Xeon Processors
4 gigs of Ram
10K RPM SAS SCSI 146GB Hard Drives
I'm using Apache 2.2.4, PHP 5.2.1 (FCGI mode with Apache), eAccelerator 0.9.5, and MySQL [url removed, login to view] . My site gets around 120,000 hits a day. I'm thinking the slowness could have something to do with the database. You must have knowledge on how to repair/optimize databases. Experts only!