I have no idea why, but in the last month, my site’s SQL usage has DRAMATICALLY increased… it’s caused me to go way over the host’s acceptable range; I’ve attached an image of just ONE day’s SQL activity… this is on a site running CP 1.7, if that’s any help at all.
Based on articles on the host, I just installed a caching plugin (I didn’t have one running before), installed MEMCACHE in the php.ini file, etc., etc.
Does ANYONE have other ideas on how to reduce the SQL usage footprint?
Question for you - is it (at all) possible that someone has actually “hacked” the database? Is that possible? Despite having a cache plugin installed (mini Orange’s WP Security), the CPU usage is ramping up every hour! If that’s true, re-installing the DB wouldn’t do any good would it, because I’d then have to restore from a backup, which could have whatever is hacked in the DB? Just asking, because I really can’t figure out what’s causing this
It’s hard to tell, because I’m facing a similar 403 situation with a website that prevents me from posting or editing articles via Gutenberg and the reason is accessing content(s) via REST API of course!
Now what prevents it and causes the forbidden 403 message, I cannot tell…one scenario might be user / group permissions; another might be corrupted file; another might be a service such as CloudFlare that enables WAF firewall for its users.
Ah, l suspect the 403’s are because the ADMIN on the server advised me to put something in the .htaccess file that would cause the 403 error, because he said the 403 errors don’t count against my CPU usage quota… if you have the time, could you examine my .htaccess file (I’ll send it to you here, if you’d like)… if you don’t have time, no problem… I appreciate your help so far on this!