Unforunately webdev is not my forte, I’ve dabbled with it and WordPress with a crude understanding of php and mysql and have successfully managed to keep the site updated, customized, and running smoothly for years.
I believe it’s just growin bigger and bigger, and these Buddypress/WP queries are not playing nice anymore.
Here is a tiny subsection of a 50MB slow query log I turned on for 0.5s+ queries. In this file, there is a “slow query” every second, if not multiple every second.
They all look very similar to this:
Adding indices, hacking away in the Buddypress files to “ignore” certain indices, looking at “explain”, etc all isn’t helping. Hell there’s even a core WP call in there constantly so it’s not just Buddypress:
SELECT post_date_gmt FROM wp_posts WHERE post_status = ‘publish’ AND post_type IN (‘post’, ‘page’, ‘attachment’, ‘wpfb_filepage’, ‘spotlight’, ‘tattle’) ORDER BY post_date_gmt DESC LIMIT 1;
Anyway, I’m sort of at a loss on how to fix this.
I kinda am looking to see if I can hire someone trustworthy and with a history to get into the server and safely tinker things into a more optimized state. Any ideas? Thanks!
[ad_2]
Without knowing much more about this, an easy fix for DB slowness (assuming it’s a basic posts query) is to throw more RAM at it. If you’re on shared hosting, get a VPS. If you’re on a VPS, make it bigger. Digital Ocean, Linode, Vultr are decent.