database grew after creating keys
-
Hello,
I just installed your plugin to improve the speed of query’s (woocommerce orders).
However I noticed that my database usage grew from 340mb to 460mb.
I only have 500mb. Should I uninstall to avoid going over the limit?Thanks for the info
-
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.
@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’
The topic ‘database grew after creating keys’ is closed to new replies.
