MySQL spikes CPU (>80%) when publishing posts in Wordpress
Every time I publish or update a post in Wordpress on my CentOS there is a huge CPU spike and running # top shows its ~80% MySQL.
I have deactivated plugins and themes, and the problem persists, leading me to think that it is an issue with the database.
It also takes around 20-30 seconds for the Wordpress admin to load the publish/update for the post. It’s extremely slow performing this one task. Every thing else on the site is very fast.
Any help would be greatly appreciated!
4GB / 60GB