We have a website and for some reason lately its been grinding our server to a halt. It has had a spike of traffic, but even still that spike is only possibly 1k or 2k.
We installed eAccelerator PHP bytecode cache on the server, but this doesn't seem to be doing much. I've also installed a wordpress plugin that is supposed to work with eAccelerator, but the server's still going down.
We've moved all the images to amazon s3 and still the website goes down, so the load must be created by a certain script on the server (or a fault on the server, although our hosting company have assured us that there is no technical fault their end).
Is there any tool or piece of software, or technique to find out what scripts cause the most load on the server, to see if we can pin point it to a script somewhere that is maybe causing an infinite loop.
Or any more general tools that can monitor the usage on our server completely to see where problems may be caused? We're not entirely sure its a script error - it could be a mysql error or anything.
Thanks for your help.