Database Maintenance

nemesis82

Active Member
Hy guys,
i'm not a DBA expert and ask your support. It's correct this size of index in db ? Expecially in mw_campaign_delivery_log, this huge index slow down my setup, could you give me some info if i could optimize ( and maybe in which way ) this table / setup ?
Below some screen

thx

1615717411481.png

1615717430856.png
 

nemesis82

Active Member
ok, i've forgottend enabling the "Delete campaign delivery logs " option in backend. Now solved :)
1 question, could i purge the log after 3 days and not after 5 ?
 

laurentiu

Active Member
Staff member Support Staff MailWizz 2.0 Tester
ok, i've forgottend enabling the "Delete campaign delivery logs " option in backend. Now solved :)
1 question, could i purge the log after 3 days and not after 5 ?
You need to change this file: web/apps/common/config/main.php on LINE 270: 'campaign.delivery.logs.delete.days_back' => 5 , put what value you want instead of 5 , keep in mind this change will be overwritten on update. Screenshot 2021-03-15 at 09.09.49.png
 

nemesis82

Active Member
last question, as i wrote above i'm not a dba expert, could you explain me why the index size is bigger than the data size ?
 

twisted1919

Administrator
Staff member
A google search can reveal some good results, such as:
 
Top