Your software
My Mautic version is: 2.16.0
My PHP version is: 7.0.33-34
Your problem
My problem is:
Our Mautic is very slow. Especially updating segments takes a very long time.
We currently have the problem that the following cronjob unfortunately takes longer and longer.
app/console mautic:segments:update
We see in SQL that an SQL query sometimes takes 1-2 hours to run.
Hence the question whether Mautic can clean up/optimize something in the database.
Steps I have tried to fix the problem:
We have already checked/completed the following on the server side.
- The server has enough CPU, RAM and hard disk I/O.
- Optimization on the part of MySQL.