mysql running over 200% CPU according to atop – pt-query-digest suggests slow running query is a lookup in wp_options for ‘autoload’ = yes
So the issue was actually a DDOS attack on our site. I used urlsnarf to see what requests were being placed and there were basically hundreds of POST request from about 20-30 or so IP addresses. Seems quite small scale for what I understood is a typical DDOS attack. It also explains why it took … Read more