Your software
My Mautic version is: 7
My PHP version is:8
My Database type and version is:mysql
Your problem
My problem is:
I am using Mautic version 5 and want to clean up the database as my database grow up to 74 GB and out of which 50 GB is from email_stats table so i want to know whats the best way to clean that up, i dont want to loose the top level stats that is how many i sent to a particular campaign/email, how many opens and how many clicked.
Can you please suggest a way to do cleanup without loosing that data and reduce the database size?