I’ve run into issues with some wordpress, single-site (not multi-site) databases getting rather large in the past due to too many articles increasing the size, and leaving me with web hosts complaining about “slow queries” in MySQL.
Anyone else run into this issue with a single site and a ton of content? At this point, it's becoming a pain in my arse, and I'm willing to consider anything other than crazy expensive hardware or cloud upgrades...mainly because I've not been able to monetize the sites to their full potential yet.
In fact, it's a large WordPress site that doesn't get a crazy amount of traffic. So the size of the database is the issue, rather than the need for scaling due to traffic or amount of queries. I welcome all replies, as I'm somewhat lost on this one.
I've been considering HyperDB, SharDB and a host of different options, but I'm honestly not sure what the best solution to this is. Those seem more geared towards multi-site installs, which I'm not, so I'm a bit lost.
I've also checked into query caching plugins, but that doesn't solve the issue of slow queries...only lessens it.