I have a server running CentOS 5, MySQL 5.1, and PHP 5.2. I have a problem that I'm not sure where to start in troubleshooting. It seems that during periods of high traffic, Apache will occasionally have a delay (or timeout) in retrieving a requested web page. Basically, I visit a page and it just hangs on fetching it.
The problem is though that I can visit 100 pages afterward with no problem, so it's very difficult to repeat. I think the cause is improper configuration that does not allow for enough simultaneous connections to either Apache or to MySQL.
Could you please give me some tips on things I can test out to try and rule some of the possible causes out?