I'm somehow a newbie on sysAdmin.
I have a Dedicated Server @Mediatemple and they're not supporting me on this issue.
So far I had an issue with MySQL Expensive Queries and I found a way how to determine which PHP Application is querying large amount of data which we don't need.
My issue now is ,that I can do a "ps aux" and I can see that a "httpd" service is consuming CPU and Memory more than others ,but I can't find out which vhost or application is doing that.
So is there a way how to find out from the HTTPD process, which application is causing that.
PS Our OS is CentOS 5.x with Apache2 and PHP5.