Find out which user is messing with his php?

[Manie]

Dear users,

I suspect that there is an easy way to find out which PHP script or MySQL query is slowing down a server.

However I wasn't able to find it.

Is there some way to see which user / applicationfile is using high system usage?

Kind regards,
Armand

[xemaps]

one easy solution
you have the apache status facility
just uncomment in httpd.conf
and point to yourhost.tld/status


######
# Uncomment this next bit if you need to
# see the apache status of all incoming
# connections
#
ExtendedStatus On
<Location /status>
SetHandler server-status
</Location>
#
#######

[Manie]

Uhm, I got a pimped version of apache with 1024 concurrent requests possible. How would I know which requests (e.g. php script) is slow performing?

Isn't there something like mysql slow query logging for php?

[chatwizrd]

There is a mytop program for mysql which you can use to watch mysql querys.

So search google for "mytop".

[xemaps]

Originally posted by Manie
Uhm, I got a pimped version of apache with 1024 concurrent requests possible. How would I know which requests (e.g. php script) is slow performing?

Isn't there something like mysql slow query logging for php?

each task running is there with %cpu, time, script, aso ...

[Manie]

So what you are saying the CPU column is the processor power it takes for the server to process the request?? :confused:

Cause the top CPU numbers are around 8.0 / 9.0, and bottom are all 0.0. (And top also include simple .jpeg apache requests.)

I'm trying to figure out ways to push down my server load, but can't seem to find bottleneck's :-)

So if anyone has a simple tip / solution for me?
I would greatly appriciate it!

Regards,
Armand