MySQL db is over 1.3GB

Hi!

The table “td_011_settings” in wp-options is over 1.3GB
I’d like to know if there is a way too reduce this size (I have the theme for years, I don’t know if it is related),
or if it is secure to set autoload data to “no”.

https://www.screencast.com/t/DNpMp4Tjz1

Thanks!

Hi there!

Thanks for responding quickly.
I have already reduce everything I could with other plugins and already optimize my database.
As you can see, the only really large data is in the table td_011_settings.
I do have a big website and I also configured everything using Cloud Library Templates.

Well, I set autoload data to “no” in this table. The website seems to be working fine. For your experience, is that ok? Because that would help a lot!
I’m having problems using WP Engine cache because of that. They recommend total autoloaded data below 800,000 bytes (0.8Mb) for optimal performance.

Thanks again!!

I am wondering if there is any other follow-up to this final question about autoloaded data because I’ve run into the same situation.

My total db is about 1.3GB and td_011_settings accounts for about 0.8 GB of that.

If I could safely turn off the autoloaded data, it seems like the database might run faster.

My site is using Cloud Library. In the wp_options I see some larger items such as widget_td_block_21_widget and widget_td_block_7_widget. Those blocks are no longer used on the site. Do you think I could safely remove these from the database?

I too am having this same issue. We run the Newspaper Theme on roughly 10+ different sites, and all of them have a HUGE problem td_011_settings row. With the largest one being 1,064,079 bytes or 1.06 MB which is autoloaded on each request. Combine the that with td_011 row which is 86422bytes and you are almost at 2mb per request and that is just for those two entries. When looking at the import/export panel I see you are keeping backups of the settings panel. How do you remove some of the backups? Currently we have 6 backups some of which are dated from a year ago.

When I look through the actual raw data it appears that in my particular case on this site I am looking at it is duplicated 10x, I search for instance for a random ID tagid: \'1bPate1YIKjanN9rdVZc\' and it returns 10 results that one id is only listed on ONE portion of the site. The full length of that td_011_settings is over 12,000 lines long, and the JSON is broken on line 12321, if it wasn’t it wold be over 20k lines long.

Also, please do not respond to this ticket with “did you deactivate plugins, did you view article on speeding up WordPress, did you read articles on how to make you db smaller, etc, etc”, as all of those have already been done. This is happening on all of the sites we use the Newspaper theme on so it is NOT an isolated issue.

Thanks

Done.

Your support was less than helpful via email. The response is below. The answer is just to reset the theme panel and redo all of your settings… Not an acceptable answer.

Hi,
In most cases this problem can be solved using this guide https://www.wpbeginner.com/plugins/how-to-clean-up-your-wordpress-database-for-improved-performance/
Also in some cases the database is corrupted, for that you need to make a full backup and copy the theme settings and rest the theme panel settings, after that the check to see if the problem persists, if no, set the theme settings back and check again if the problem persists, then the settings for theme balel are corrupted and you must make new settings from a fresh theme.
Thank you for your understanding!
Alex N.

This is still an issue for me and I’m really trying to find a way to fix it. My hosting provider points to this as the main reason for the site slowness. Do you have any thoughts on what they say?

++++++++++

What is indeed concerning at the point is the amount of autoload data the database runs. The recommended threshold to not cause slowness and performance issues on a site is 900KB, the site is currently running 1.23MB, most of that data being set by NewsPaper and the tagDiv suite of plugins, apart from a custom set of options that I see coming up:

| td_011_settings       | 907083 |
| _transient_dirsize_cache    | 276284 |
| td_011       |  90572 |

It’d be a good idea to check with a developer if it’s possible removing any of those options, or at least divide some of them into smaller options, to take off from autoload, thus helping the site’s overall functionality.

+++++++++++++++

• This reply was modified 5 years by ddj.

The site is on version: 10.3.9.1

Can you better define what you mean by “cleared their database”?

In the database, I have removed entries leftover from previously used plugins and run WP Optimize on it.

I’d like to update this thread …

After working with tagDiv support, I’ve tried numerous things to reduce the size of the table td_011_settings, and none are working.

Today I removed one Template from the site and edited three Categories to get its settings from the Global Template. Between each of the four changes, I ran WP-Optimize to clear unused data from tables.

As I understand it, each of these activities should have resulted in a smaller table of td_011_settings.

Instead, the size of the table increased with each change. The size started at 907862 and ended at 909599.

Any ideas on what I can do to reduce the size of that settings table?

Are there any updates from the developers on this? Any more information I can provide?

I also have the same problem. There appears to be a whole lot of CSS info that could be loaded a different way.

Here is what is in my td_011_settings
A lot of this is css
https://www.cttowns.com/td_011_settings/wp_options.txt

I don’t have that option to stop the backups.
https://drive.google.com/file/d/13mbZaqUENZj-feCqjprxXu3PJuMSF6ZI/view?usp=sharing

I’ve updated the theme and turned off the backups, it resulted in a 40 btye savings. Thats not much.