Title: Big Database
Last modified: October 4, 2021

---

# Big Database

 *  Resolved [NiceGuy211](https://wordpress.org/support/users/spargut/)
 * (@spargut)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/big-database-2/)
 * Hello,
 * We had a big Woocommerce database with about 29.000.000 entries. wp_postmeta 
   had about 16.300.000 entries. Can we also use this plugin?
 * Thank you for this great plugin if its work.

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

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/big-database-2/#post-14939391)
 * Yes, it should work for you.
 * You may want to use wp_cli to do the rekey operation from a command line.
 *  wp index_mysql enable wp_postmeta
 * As always, please let me know if you have problems.
 *  Thread Starter [NiceGuy211](https://wordpress.org/support/users/spargut/)
 * (@spargut)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/big-database-2/#post-14944433)
 * Hello,
 * Is the plugin compatible with Redis? because when i activate Redis on my site
   the CPU goes high and the max process will reach shortly. (Redis Object Cache)
 * Thank you
 * Simon
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/big-database-2/#post-14945698)
 * I have tested it with Redis. I will test it again. The plugin only affects data
   lookups that make it past redis to the database.
 * It puts no code anywhere in WordPress except to render its Dashboard page and
   do its work totally within that page. I don’t think it should interact with the
   redis-based object cache at all.
 * Can you tell me more about your particular site?
 *  Thread Starter [NiceGuy211](https://wordpress.org/support/users/spargut/)
 * (@spargut)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/big-database-2/#post-14946273)
 * Hello,
 * Thank you for your fast reply.
    I check it again and same issue – i also wait
   2 hours if it calms down but 2 hours max process and max cpu consumption. Can
   i send you the details via email?
 * Thank you
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/big-database-2/#post-14948614)
 * Sure, email me. You can find my contact on my Github profile …
 * github[dot]com[slash]OllieJones
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/big-database-2/#post-14988497)
 * As it turned out, this was resolved by flushing the redis Object Cache.

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

The topic ‘Big Database’ 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/)

 * 6 replies
 * 2 participants
 * Last reply from: [OllieJones](https://wordpress.org/support/users/olliejones/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/big-database-2/#post-14988497)
 * Status: resolved