Title: Database Overfill
Last modified: November 9, 2022

---

# Database Overfill

 *  Resolved [Lee Hodson (VR51)](https://wordpress.org/support/users/leehodson/)
 * (@leehodson)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/database-overfill/)
 * This plugin is filling up my databases with data in wp_collect_spectra_blocks_count_batch_*
   in the wp_options table.
 * I have at least one database with a wp_options table over 41GB in size.
 * This issue began with the last or last-but-one Spectra update.
 * Hope that helps.

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

 *  [BSF – Judith Pete](https://wordpress.org/support/users/judith0/)
 * (@judith0)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/database-overfill/#post-16186081)
 * Hello [@leehodson](https://wordpress.org/support/users/leehodson/),
 * Thanks for writing to us.
 * You already opened a ticket with this issue which is now resolved.
 * Please allow me to mark this as resolved as well. Feel free to open a new thread
   in case of any other queries.
 * Regards.
    Judith.
 *  Thread Starter [Lee Hodson (VR51)](https://wordpress.org/support/users/leehodson/)
 * (@leehodson)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/database-overfill/#post-16186229)
 * It’s not quite resolved.
 * For others who find this support request, the plugin had a bug introduced in 
   version 2.0.12. This bug caused the plugin to fill up the database. The database
   in my particular site went from approx 200MB to over 50GB in the course of 24
   hours, growing at about 1GB per 30 to 40 minutes. The bug is said to have been
   fixed in version 2.0.13. The BSF support team suggested I upgrade the plugin 
   to version 2.0.14, which was already in use within my site.
 * The solution I came to was to delete the excess data. BSF were unable to advise
   me whether doing so would affect Spectra blocks in posts and thus affect the 
   content of posts that contained Spectra blocks. I still have had no reply on 
   this.
 * If your database is overflowing because of the fixed (?) bug in Spectra you can
   use the following SQL query in PhpMyAdmin to delete those superfluous rows of
   data (there should be backticks around wp_options, option_name and wp_collect_spectra_blocks_count_batch_%).
 * `DELETE FROM`wp_options`WHERE`option_name`LIKE ('wp_collect_spectra_blocks_count_batch_%');`
 * 0. Take a backup of your database first, if you can do.
    1. Open the affected
   database in PhpMyAdmin 2. Go to the SQL tab in PhpMyAdmin 3. Place the SQL query
   into the form and change wp_options to the name of your wp_options table.
 * Good Luck!
 *  Thread Starter [Lee Hodson (VR51)](https://wordpress.org/support/users/leehodson/)
 * (@leehodson)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/database-overfill/#post-16206991)
 * This bug still exists in Spectra version 2.0.15.
 * When I activate the plugin Spectra begins to fill my wp_options table with data.
   Today, after the plugin update, I activated the plugin and watched my wp_options
   table grow from 40MB to over 800MB in under 10 minutes. I had to deactivate the
   plugin again and delete the bumph data.
 * Can you please take another look at this issue?
 *  [BSF – Judith Pete](https://wordpress.org/support/users/judith0/)
 * (@judith0)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/database-overfill/#post-16234559)
 * Hello [@leehodson](https://wordpress.org/support/users/leehodson/),
 * You already opened a ticket with us and we’ll be handling this issue from our
   support end.
 * Please allow us to mark thus as resolved, please feel free to open a new thread
   in case of any other queries.
 * Regards.
    Judith
 *  [hungwenchun](https://wordpress.org/support/users/hungwenchun/)
 * (@hungwenchun)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/database-overfill/#post-16379844)
 * Try to set the autoload status “Yes” of “spectra_blocks_count_status” as No in
   WP_OPTIONS table. And thanks [@sageth](https://wordpress.org/support/users/sageth/)
   for completing solution.
 * [Huge WP_OPTIONS table size! | WordPress.org](https://wordpress.org/support/topic/huge-wp_options-table-size/)

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

The topic ‘Database Overfill’ is closed to new replies.

 * ![](https://ps.w.org/ultimate-addons-for-gutenberg/assets/icon-256x256.gif?rev
   =3240412)
 * [Spectra Gutenberg Blocks – Website Builder for the Block Editor](https://wordpress.org/plugins/ultimate-addons-for-gutenberg/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ultimate-addons-for-gutenberg/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ultimate-addons-for-gutenberg/)
 * [Active Topics](https://wordpress.org/support/plugin/ultimate-addons-for-gutenberg/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ultimate-addons-for-gutenberg/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ultimate-addons-for-gutenberg/reviews/)

 * 7 replies
 * 3 participants
 * Last reply from: [hungwenchun](https://wordpress.org/support/users/hungwenchun/)
 * Last activity: [3 years, 2 months ago](https://wordpress.org/support/topic/database-overfill/#post-16379844)
 * Status: resolved