MySQL db is over 1.3GB

Posted in: Newspaper
Post count: 38

I just did a theme update to 11.2 and turned off the backups of settings. It made a huge difference immediately on both staging and production. On production, the size of td_011_settings was at 907862, and is now at 91015. On staging, where the content is slightly different and where I took additional steps, the size went from 907922 down to 1124. The additional steps were to turn off backups, export the theme settings, reset the theme settings, and import the theme settings, and run WP-Optimize on the tables between these steps.

In all, I’d say the ability to turn off the backups made a big difference.

  • This reply was modified 4 years by ddj. Reason: added one more step in the staging workflow
Post count: 33

Same here.


@tagdiv
team Would you please add an option to remove the old backup to reduce this, our live website exceeded the 1.5G and Can you please confirm is safe to set autoload to No?

Post count: 18283

Hello!

Yes, this option is available. https://i.imgur.com/TVAdtdD.png As you can see here you are being asked if you want or not to remove the existing backups.

Thank you!

Post count: 33

Hello Vlad, Thank you for your reply, We not planning to make this update soon, so would you please help us to the safest way to remove table content without any negative effect on the website or theme? Can we safely truncate it directly?

Post count: 27744

Hello,

Unfortunately, this implementation was done by the developers and involves more knowledge and changes in several files, these changes can only be made by one developer.

Thank you!

Post count: 33

Hello Anamaria,

OK. Can you share with me the responsible files for this part please?

Post count: 27744

Hi,

That option was added in newspaper 11.1 and I don’t know exactly what code was added for that option, but if you want you can verify this by checking the modified files from version 11 to version 11.1. if you want the files you can contact us by email at contact@tagdiv.com where to specify this or download the patch 11_11.1 from here https://we.tl/t-BPZOJoZZMl

Thank you!

Viewing 7 posts - 26 through 32 (of 32 total)
You must be logged in to reply to this topic.