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
 
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 ?
 
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
 
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 ?
 
A google search can reveal some good results, such as:
 
But i guess if u set campaign delivery logs to no then you won’t be able to do segmentation find x days openers or clickers etc, i’m not sure but i think so
 
Back
Top