Database Maintenance

N

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 ?
 
nemesis82 said:
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 ?
Click to expand...
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:
stackoverflow.com

Why does the index occupy even more space than data in my MySQL table?

I have a MySQL table with more than a billion rows hosted on Google Cloud SQL. >> SHOW CREATE TABLE depth CREATE TABLE `depth` ( `date` date DEFAULT NULL, `receive_time` datetime(3) DEF...
stackoverflow.com stackoverflow.com
stackoverflow.com

Why index size greater than data size in InnoDB?

I noticed that in couple of InnoDB tables with a primary key, a unique key, one or two reference keys. The index length is considerably larger than the data length itself. The question is why? The...
stackoverflow.com stackoverflow.com
 
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
 
You must log in or register to reply here.
Back
Top