Thanks for the question. As you noticed, the way database keys work is by creating copies of your data organized for quick access by WordPress.
Careful: You can’t get rid of this plugin’s high performance keys just by deactivating the plugin. Instead, you must revert the keys. Go to Tools -> Index MySQL. There you will see a way to revert the keys.
If you use WooCommerce, try reverting the keys on all tables except wp_postmeta. That should save you some database space. The wp_postmeta table is heavily used by WooCommerce, so by leaving that table’s high-performance keys in place you will get at least some benefit from the plugin (if you have the space).
Half a GiB is not a very large database storage quota. If this were my online store I’d ask myself whether it is outgrowing the hosting provider account.
- This reply was modified 12 minutes ago by OllieJones.