database grew after creating keys

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 1 year, 8 months ago by OllieJones.

@olliejones thank you for your super fast reply. I am in contact with my host to see what I can do.

Edit: for the time being I disabled the plugin and the keys. I also found one error in the logs that appears often:

[Wed Jul 19 15:01:35.848714 2023] [error] [pid 474966] mod_proxy_fcgi.c(887): [client 2a02:1810:1c39:b500:99c3:94ed:25cc:99a7:0] AH01071: Got error ‘PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DESC wp_download_log/imfs-query-tag3538956810/’ at line 1 for query EXPLAIN DESC wp_download_log/imfs-query-tag3538956810/ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ImfsMonitor->imfsMonitorGather, ImfsMonitor->encodeQuery’

• This reply was modified 1 year, 8 months ago by dyin.