I've been trying to pinpoint the cause of a spike of CPU to 100%.

The Production Server is HPDL380 G4, Xeon 3.8Ghz (x2) CPU, 2GB Memory, 146 GBx2 (Mirror) HDD.

OS: Linux Red Hat ES 4.0
Apache2.0.55 and PHP5.2.0 and MySQL.

We are thinking that the HTTP+PHP is eating a lot of resources. At one point it went up to 100%.

Has anybody encountered this problem?

Please help.