Question

Wordpress mysql cpu overload

  • Posted January 4, 2015

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

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

I think I found the problem, it’s caused for plugin WPtouch Pro

https://wordpress.org/support/topic/slow-queries-possibly-slowing-down-the-site

Hello,

My MySql is running into same droplet that my website

I dont have any other site or php scripts running.

Thank you for help

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?

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?

I’ve installed mytop.

Thank you very much.

With that kind of volume you may need to spend money on a decent MySQL query analyzer to figure out which queries from WP (and WP plugins, most likely) are eating up your CPU cycles. For a cheap and quick (but powerful) first look at your problem, install mytop to see what your mysql and threads are doing while your system is running.