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!

Dedicated server overloading because of mysql

Discussion in 'Database Discussion' started by crismarques silva, Jun 21, 2017.

  1. crismarques silva

    crismarques silva Registered

    Joined:
    Jun 21, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    My dedicated server is with very high cpu server load my site does not load. Mysql is generating a lot of processes.

    This problem happened when I cleaned the cache (w3 total cache) of my site that has more than 20,000 posts, after that the site has more than 100% cpu. I tried restarting and nothing
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,183
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    You can use the "mysqladmin processlist" command to see which MySQL database or tables are using the most resources. Additionally, the following thread is a good place to start:

    Troubleshooting high server loads on Linux servers

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. crismarques silva

    crismarques silva Registered

    Joined:
    Jun 21, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    wp_posts.ID FROM wp_posts

    This table is consuming a lot of what I can do
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,183
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice