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.

Dedicated server overloading because of mysql

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page