Dedicated server overloading because of mysql

[crismarques silva]

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

 

[cPanelMichael]

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.

 

[crismarques silva]

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.

wp_posts.ID FROM wp_posts

This table is consuming a lot of what I can do

 

[cPanelMichael]

Hello,

This is more of a task that you'd need to seek help from a qualified system administrator with, as it's related to your website as opposed to cPanel. I did do a search to find the following third-party URL that might help:

Optimizing Your WordPress Database – A Complete Guide

Otherwise, you can find a list of qualified system administrators on the following URL:

System Administration Services | cPanel Forums

Thank you.