First I would recommend upgrading to the latest version of Mautic.
There is the possibility to clean up the DB a bit with a cronjob that cleans events etc… but I do not think this will solve your problem.
It seems that maybe you have pretty intricate filters in your segments and maybe a number of different segments, what I would suggest is not to update all your segments all the time. Rather figure out which segments need to be updated daily, which ones every x minutes etc… and add in cronjob to only update specific segments at specific times. This can be done with adding -i [segment_id] at the end of the update:segment cronjob.
Other ways are outside of Mautic scope and would require optimizing database with external tools maybe
Hi, you need to be efficient when you create your mautic segments.
Log in to SSH, and check which segment update takes long time.
Disable the ones, that pull down your instance.
For example: if you have page visit based segments, they can be a real problem once you have many visitors. Make sure you are not running redundant segments.
yes exactly. I checked this and the visited url segment is taking the longest. it feels like it is almost stuck.
is there any way we can fasten it @joeyk ?