Where to start? Server profiling tools

Question

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?

The operating system is Cent OS – Dave Chenell Apr 12 '12 at 13:01 — Dave Chenell, Apr 12 '12 at 13:01

score 0 · Accepted Answer · answered Apr 12 '12 at 03:53

0

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.

answered Apr 12 '12 at 03:53

Hengjie

2,853
1
15
10

Awesome, looks promising I will check it out now! – Dave Chenell Apr 12 '12 at 04:07
Turned out to be exactly what I needed. Thanks again – Dave Chenell Apr 12 '12 at 05:07

Where to start? Server profiling tools

1 Answers1