Mysql overload problem

Masimo

• November 20, 2016 02:19

I found a problem on mysql server overloading by databases query process time. Please have a look at attached screenshots, some databases query process is too many and its will take too much time, so database server will going to crush and overload. How can fix and take this problem on control? -Removed - Second screenshot is here: - Removed -

• 

  Infopro

  • November 20, 2016 11:18

  Please attach images to your posts using the Upload File Option.

  0
• 

  Masimo

  • November 20, 2016 11:50

  Attachment is here...

  0
• 

  Infopro

  • November 20, 2016 13:29

  How can fix and take this problem on control?

  
  You might want to take a closer look at that account and script on it and see whats going on. Is it an out of date addon script for a wordpress site, is the script being attacked by spammers or abused in some way? No way of knowing from the images. You'd need to look at the account to find out more.

  0
• 

  Masimo

  • November 20, 2016 13:47

  I agree with you. but you know, this is a shared hosting server with thousand sites. Its out of control to check and monitor everyone. Is it possible to have some changes on mysql config, or something like this? to ignore or stop sich like this process...

  0
• 

  Infopro

  • November 20, 2016 15:59

  Well, you've only got 2 or 3 databases shown in those two screenshots that are seemingly doing almost the same thing. Checking if those queries are legit is more important than tweaking my.cnf to help the system deal with them better. You can have a perfectly tuned server and still have an out of date or compromised script cause you problems.

  0
• 

  Masimo

  • November 24, 2016 08:19

  How about this process?

  0

Please sign in to leave a comment.