I realized that my
wp_options table is huge, hitting 473.2 MB, which made me curious. Then I started to run a few queries until noticing that the following query returns 306378195 bytes, or ~306 MB.
SELECT * FROM wp_options WHERE option_name LIKE '%_transient_yst_sm_post_%';
By digging into the PHP files of my WordPress site, I found that "yst_sm_" is the constant
STORAGE_KEY_PREFIX located in Yoast SEO Plugin sitemap files (
I'm wondering if it's safe to delete those entries, freeing precious 300 MB that is causing
wp_options to be the biggest table in my database.