0

I had a problem with my VPS like a week ago, and I had to completely reinstall it for it to work. It worked, but just for a while.

Everything was alright until now, I really don't know what the problem is.

The mysql error log has errors about maxrequestworkers, so we increased the max workers, but that didn't do anything, still at 100%.

I'm attaching an image of top so you can see what's doing it:

btw, im on DEBIAN 8.

htop screenshot

There is screen without mysql process, just check screenshot.

enter image description here

MYSQL TUNER SCREENSHOT.

https://i.imgur.com/eJao2Pj.png

migrated from askubuntu.com Jun 10 at 17:20

This question came from our site for Ubuntu users and developers.

  • How many CPUs does your system have? Are you sure there's a problem? What is the problem, exactly? What is the DB doing? What CPU usage would you expect? – terdon Jun 10 at 17:21
  • 4 cpu, 100%, MYSQL is taking 200% cpu instead of 20% normal. – Adam Čech Jun 10 at 17:25
  • 2
    So it's using 50% of available CPU (200% means 2 out of 4 cores used at 100%). Do you notice any actual problem? Is the machine slower than normal? What makes you think there is a problem here? I am not saying there is no problem, I am just trying to understand what symptoms you see. – terdon Jun 10 at 17:36
  • Is this connected to something world-visible? Unusual behaviour can be caused by somebody doing sql injection attacks (though they'd not typically use something that gets noticed, but not all attackers are smart). – Ulrich Schwarz Jun 10 at 17:36
  • 1
    You need to analyze what those connections are what they are doing. Start by looking at the output of mysqladmin processlist (SHOW PROCESSLIST from within mysql). Check if you have some processes running crazy queries or sleeping. Also check that the connections are coming from where you expect them to come from. – GracefulRestart Jun 10 at 19:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.