Database shrink

Discussion in 'Tips and tricks' started by nemesis82, Oct 5, 2018.

  1. nemesis82

    nemesis82 New Member

    Joined:
    Sep 19, 2018
    Messages:
    23
    Likes Received:
    1
    S.E:
    2019-09-17 13:35:43
    L.T:
    Regular
    L.C:
    1
    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
     
  2. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,443
    Likes Received:
    644
    S.E:
    2018-11-06 14:46:35
    L.T:
    Regular
    L.C:
    6
    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.
     
  3. Vroom

    Vroom Member

    Joined:
    May 27, 2015
    Messages:
    120
    Likes Received:
    11
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    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.
     

Share This Page