CPU/Memory/MySQL Usage - don't show by domain

[Matnet]

i want to check in CPU/Memory/MySQL Usage which domain using high resources using httpd in my WHM.

my CPU/Memory/MySQL Usage show like this :

User Domain %CPU %MEM Mysql Processes
nobody 18.31 49.58 0.0
Top Process %CPU 38.0 /usr/local/apache/bin/httpd -DSSL
Top Process %CPU 10.5 /usr/local/apache/bin/httpd -DSSL
Top Process %CPU 9.3 /usr/local/apache/bin/httpd -DSSL
root 1.16 13.62 2.0

Why it does not tell httpd used by domain?

plz assist

[chirpy]

It doesn't show it, because that is not how Apache works. You should really be investigating performance issues from shell and not relying on that WHM report at all. As for apache, you can get a current view of what it is doing from WHM > Apache Status.

[abubin]

if you want to see which domain is using a lot of resources then look in reporting tools like analog or webstats or webalizer. These reports will tell you how heavy a domain is been access. Of course higher hits means more busy.

[chirpy]

Not necessarily and not very reliably at all. If you have a static site with thousands of hits and a database driven site with only a few hundred, the latter could very easily be causing the performance problems.

[abubin]

Not necessarily and not very reliably at all. If you have a static site with thousands of hits and a database driven site with only a few hundred, the latter could very easily be causing the performance problems.

well, that would means that mysql would need to be one of the process shown on top of the CPU/Memory/MySQL list, right?

Since he has all httpd on top, that would means more httpd access than mysql access. Correct me if I am wrong...oh mighty one....

[chirpy]

Not necessarily, not all databases use MySQL You're probably better off monitoring the apache status and seeing where the connections are going.