Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
LAMP Server Performance Tips

So I have a website, users upload images, people view images etc. Simple enough. Lots of writes and reads everywhere. Its built in MySQL and PHP on Apache.

We have one dedicated server. Right now we are getting hammered with unexpected press and users and our CPU cycle is out of control, slowing down the entire site.

Off hand I am guessing its either the saving of the image to the disk, or the Mysql queries.

What tools can I use to educate myself on what is happening and pinpoint the problem? How can I find out what is happening in detail in this time of crisis?

share|improve this question
    
Which operating system? –  ramruma Apr 12 '12 at 7:47
    
The operating system is Cent OS –  Dave Chenell Apr 12 '12 at 13:01
add comment

marked as duplicate by Wesley, John Gardeniers, Khaled, TheCleaner, HopelessN00b Dec 5 '12 at 3:02

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

up vote 0 down vote accepted

Try New Relic. It is a service that can analysis which PHP functions and MySQL queries are taking time and will automatically analyse those queries to see why it is slow. It costs money but you could use their trial to debug your problem.

share|improve this answer
    
Awesome, looks promising I will check it out now! –  Dave Chenell Apr 12 '12 at 4:07
    
Turned out to be exactly what I needed. Thanks again –  Dave Chenell Apr 12 '12 at 5:07
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.