I was recently horrified to discover that the “wp_options” table of this site was over 1.3 gigabytes in size. For those of you counting at home – that is ENORMOUS and unnecessary. I was confused, because the table seemed to balloon overnight (and likely did balloon overnight, it turns out!).
The issue was caused by a poorly-coded plugin that added some HUGE rows to wp_options. I’m not 100% sure of the culprit nor the specific row, but I’m pretty sure it was either the Jetpack or Spectra plugin that did the ballooning. How do I know this? Well, a manual search (e.g. using phpMyAdmin and my eyeballs) of recent rows in the “wp_options” table turned up a lot of rows that had values that included both “jetpack” and “spectra”.
How I deleted the offending rows and shrunk my “wp_options” table from 1.3gb to 3mb
I used a pretty blunt hammer stroke to fix the issue, running the following 3 sql queries via phpMyAdmin:
- DELETE FROM wp_options where option_name like ‘%jetpack%’;
This removed 180 rows.
- DELETE FROM wp_options where option_name like ‘%spectra%’;
This removed 97 rows.
- DELETE FROM wp_options where option_name like ‘%transient%’;
This removed 51 rows.
So, again, I’m not sure exactly which plugin was the offender, but deleting only 328 rows from my database shaved off over a gigabyte of girth.
Is this helpful?
More posts from themightymo.com
How to merge multiple .csv files via command line
Today I downloaded 29 csv files with tax information. I could import those files 1 at a time into WooCommerce, but wouldn’t it be nice if I could merge them first and then only import a single file? The unix command is simple – just navigate to the folder with all the csv files and…
15 Best WordPress Support and Maintenance Services for 2023: Ensuring Your Website Stays in Top Shape
Small business owners and non-profit leaders know that keeping your website secure, fast, and fully-functional is critical to success. Here’s the unspoken truth: You can either learn how to do all that tech maintenance and development stuff yourself, or hire someone else to do it. But let’s face it, doing it yourself isn’t always the…
How to Whitelist SEM Rush IPs in Cloudflare
Alright, I’m going to show you how to whitelist a set of IPs on CloudFlare. In our case we use SEMrush and we want to make sure the SEMrush has full access to our sites.