Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql overload problem

Discussion in 'Workarounds and Optimization' started by Masimo, Nov 20, 2016.

  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    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 -
     
    #1 Masimo, Nov 20, 2016
    Last edited by a moderator: Nov 20, 2016
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,766
    Likes Received:
    313
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Please attach images to your posts using the Upload File Option.
     
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Attachment is here...
     

    Attached Files:

  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,766
    Likes Received:
    313
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
  5. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    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...
     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,766
    Likes Received:
    313
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    rpvw likes this.
  7. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    How about this process?
     

    Attached Files:

Loading...

Share This Page