Your software
My Mautic version is: 1.71
My PHP version is: 5.6
My Database type and version is:
Your problem
My problem is:
email_stats table with 25gb
Can I just clean this table using phpmyadmin?
Hi,
There is a very good conversation about this in the forums, but I’m on mobile, no way I will find it now.
However your problem is email_stats.tokens column.
The bloating happens, if you use code mode in your emails and embed huge images. The whole code is saved in email_stats.tokens, and it can be 6-8-10+ MB / email. After a couple of sends of 10k emails, you can easily end up with a 25 GB table.
I suggest you empty just the token column. Don’t delete the rest. I didn’t notice any issues when I did it, hopefully it will be the same for you.
DO IT AT YOUR OWN RISK.
Regards:
Joey
1 Like