Mautic DB Huge - Events & Import History - what can be deleted

Product Support
1

Your software
My Mautic version is: 3.1
My PHP version is: 7.2

Your problem
My problem is:
I have noticed that my DB is getting huge (okay we have over 1M contacts) but part of the problem is there are hourly imports coming into the DB and I see that both the lead_event_log and imports table are rather big.

Does anyone know if anything bad will happen if I purge the import table totally, and remove all entries from leads_event_log table where properties like “%file%”

2

This is what my DB is looking like:
email_stats | 16056.08 |
| audit_log | 3820.63 |
| lead_event_log | 2837.56 |
| campaign_lead_event_log | 2698.25 |
| leads | 1434.94 |

3

This is a very hard question. I have the answer, but you not gonna like it.

Will you need tracking data?

Or check this:

1 Like
4

Is this causing space issues, or is this hindering your performance?

Reason I ask is there seems to be some relief on the way. (At least indirectly)

5

Thanks @joeyk going to check those articles out.

We need tracking, but not for all the records and for so long back,

@EJL - it is performance related. going to check out your links as well.

Thanks to both above