sajithgsm

Well-Known Member
Jun 9, 2020
97
18
83
Sri Lanka
cPanel Access Level
Root Administrator
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.

Screenshot 2022-01-31 at 8.07.22 PM.jpg
Screenshot 2022-01-31 at 8.07.34 PM.jpg

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?
 
Last edited by a moderator:

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
714
280
363
cPanel Access Level
DataCenter Provider
When you are having the issue, you can run the following from shell

Code:
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.