Title: database grew after creating keys
Last modified: July 19, 2023

---

# database grew after creating keys

 *  Resolved [dyin](https://wordpress.org/support/users/dyin/)
 * (@dyin)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-grew-after-creating-keys/#post-16906654)
 * 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 2 years, 9 months ago by [OllieJones](https://wordpress.org/support/users/olliejones/).
 *  Thread Starter [dyin](https://wordpress.org/support/users/dyin/)
 * (@dyin)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-grew-after-creating-keys/#post-16906794)
 * [@olliejones](https://wordpress.org/support/users/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-tag_3538956810_/’ at line 1 for query EXPLAIN
   DESC wp_download_log/**imfs-query-tag_3538956810_/ made by shutdown_action_hook,
   do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ImfsMonitor-
   >imfsMonitorGather, ImfsMonitor->encodeQuery’
    -  This reply was modified 2 years, 9 months ago by [dyin](https://wordpress.org/support/users/dyin/).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘database grew after creating keys’ is closed to new replies.

 * ![](https://ps.w.org/index-wp-mysql-for-speed/assets/icon-128x128.png?rev=2652667)
 * [Index WP MySQL For Speed](https://wordpress.org/plugins/index-wp-mysql-for-speed/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/index-wp-mysql-for-speed/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/)
 * [Active Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [dyin](https://wordpress.org/support/users/dyin/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/database-grew-after-creating-keys/#post-16906794)
 * Status: resolved