SQL Logs?

[GlobalDC]

Hello, I have a user or more that have been using up nearly all server reasources, to the point where, login via ssh is impossiable, because it times out.

I have been trying to track down who has been using databases so much, and http, but cannot figure out who is doing it.

I can't seem to find the MySQL Access Logs, if anyone could point me where to find them on a DA install, RH 9, please, post.

Whenever I think i found the site, I suspend it, and it keep happening.

Any help, PLEASE.

Thanks Much,
Chris


P.S. If you dont have hosting or anything, and can help me out, I would be happy to give out free hositng ^_^

[jmstacey]

Try installing the Domain monitor tool, you can find it in the 3rd party forums. It might show you if one particular user has significantly higher usage than the others to give you an idea of whos behind it.

I don't think mysql has any logs other than error logs. You might be able to check apache logs if the culprit is using a php script to bridge his script with the backend.

[GlobalDC]

Thanks Much :)

Chris