Hello,
I have a droplet with 320GB & 32GB RAM My web is a wordpress with 2.000.000 pages/visited/month (300 average users in real time of Analytics) http://www.jotdown.es We use Total Cache (before WP Cache)
Three times/day we have mysql cpu overload IMG http://www.jotdown.es/content/example.jpg
Any explanation?
Sorry for my english
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
In mysql-slow.log only appears this query many times:
SELECT count(*) as c FROM wp_posts WHERE ID IN (SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id = 542)
Any idea?
Why is your droplet so massive? you don’t need something that big for 300 concurrent visitors. I suggest you to start looking for holes in your droplet security, maybe is something else other than WP, do you have any other sites or php scripts running?
Yous MySQL is running on its own droplet? or into the same droplet as your website? Also can you let us know more about your droplet environment, webserver, php version, mysql version, etc? How is Total Cache configured?
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.