Database Abusing

[sajithgsm]

Hello Team,

For a few days, there is something happening with MySQL. It's abusing actually. the MySQL Server is getting high and high and /tmp folder is filling up with MySQL Files. and server getting down after that.
Here is the proof.




Do you have any idea how to solve that problem or find the account that is abusing MySQL? CloudLinux Governor also running but it is helpless.
It's running a Select Query. How can we find the problem?

 

[ffeingol]

When you are having the issue, you can run the following from shell

mysqladmin processlist

You may also be able to look at the processes via phpMyAdmin if the load on the server is not too high. A long running query will show a long time in MySQL (the time column). From the process list you can see the user-id (mysql user) as well as at least part of the command being run.

 

[cPRex]

Please keep all issues limited to just one thread to avoid confusion. I believe I replied with some more details in another thread as well, but let us know if the details that @ffeingol posted help.