Database shrink

[nemesis82]

Hi all,
is it possibile shrink mailwizz database?
Actually my db is 40gb and raising, i would like shrink and resize in a safe and scheduled way.

Thanks

 

[frm.mwz]

Hi all,
is it possibile shrink mailwizz database?
Actually my db is 40gb and raising, i would like shrink and resize in a safe and scheduled way.

Thanks

Can be done, better manually and with oversight (PM me), since automation can yield disaster for various reasons. It is included in monthly maintenance for ongoing clients.

 

[Vroom]

If you don't need to keep stats you can remove old campaigns and then it will delete the old stats (I think once a day it updates).

Most of the database is delivery logs, and then next biggest table is open logs. They make up probably 90% of your database. I truncate both from time to time, and only problem i notice is loss of stats on old campaigns.