Database Overfill

Hello @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.

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 FROMwp_optionsWHEREoption_nameLIKE ('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!

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?

Hello @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

Try to set the autoload status “Yes” of “spectra_blocks_count_status” as No in WP_OPTIONS table. And thanks @sageth for completing solution.

Huge WP_OPTIONS table size! | www.ads-software.com