mySQL. Help needed!!!
ok, here's a situation. server with virtual hosts. one of users is an as*hole and crashes the server from time to time with his glitchy scripts.
currently i can catch his glitchy script in a second..... just by using "top" + "mod_status"...... not a problem.
but what do i do with mySQL ???
"top" PIDs are not the same as mySQL PIDs... so i can't compare PIDs and cick him out..
"show processlist;" ain't shows CPU or RAM usage, so i can't get the username also if i got few processes running at any time.
so the question is... how to trace a user who crashes a server with glitchy mySQL processes???
PLEASE, HELP
