How to check which domain using system resources ?

[asking]

i wanna check which domain is using how much system resources ?

is it possible and which process are running for any specific domain which can cause server unstable ?

how many mysql queries ? etc.. ? anything like that ?

awaiting your reply

 

[zEitEr]

You can learn some basic information from httpd-status (or server-status) page.
MySQL counts mysql queries for every user, if set up a limit on them. But I don't know, how they can see the actual value for a specified user's mysql queries counter.

 

[LawsHosting]

People say mytop will show the mysql queries in real-time, but I've yet to witness this. Maybe the second delay is too slow, thats why I can't see nothing.

 

[zEitEr]

If you want to see mysql queries real-time with some kind of an analysis, I'd recommend using Jet Profiler for MySQL. There's also a free edition.