Database Abusing

sajithgsm

• January 31, 2022 08:39

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. -01-31 at 8.07.22 PM.jpg">75385 -01-31 at 8.07.34 PM.jpg">75389 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

  • January 31, 2022 13:59

  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.

  0
• 

  cPRex Jurassic Moderator

  • January 31, 2022 20:38

  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.

  0

Please sign in to leave a comment.