Your software
My Mautic version is: v4.4.1
My PHP version is: 7.4.23
My Database type and version is: 10.3.37-MariaDB-0ubuntu0.20.04.1
Your problem
My problem is: It seems eventhough we have very powerful server but still mautic site/server get hanged till we reboot. we are using aws server when we see cpu utilizaion graph it showing 5 to 15 % max cpu utilizaion. So My question is
Why mautic site/server is get hanged frequently ?
How to utlize server memory properly so that it will not get hanged any more?
What other suggestion we should follow to avoid such type of hanging issue?
We are having 15 lac contact, lead_event_log having 22 cr +, We update segment cron every 1 hour
We have choosen mail sending option immediately.
Total Contact Count : 9283281
Total Contact Count with Email(can say valid contact) : 1350505
Total Segment Count : 165
Mail Speed : 13 per sec(This is aws mail sending rate)
Mail sending process is not continuous for 24 hours. I mean when we send email, mail volume may vary sometime 50 thousand to 3 lac in 1 batch.
Hi,
Okay, so this would be a size, where you need to do multiple adjustments to be able to run it properly.
Mautic - out of the box - is not built for this size. Mautic feels comfortable in the 10.000 - 100.000 db size.
Above that you need to take compromises and tweak things.
In your case, it will be A LOT F WORK AND LEARNING.
I can’t lay down the whole process here, cause I didn’t tackle all challanges myself, but I can point you in the right direction.
Learn about mysql memory consumption, identify querries that take long. Once you’ve done that, you need to make the changes to your mysql settings to use more memory or have bigger cache / support for larger table siezes.
Change your dashboard to eliminate charts with larger DB intensity.
I know this is such a big topic and there is so much to write and talk about, I think it would be great if there was some more knowedlge share around Mautic server optimization.
I have read many articles on setting up mautic workers behind a firewall, distributing traffic, creating master-slave and master-master environments, tweaking php for fpm etc… and I am happy to share my findings and help out the community as best I can.
However for the life of me after so many years and not being a dedicated Devops person I still face the issues mentioned above,
Yes each instance is unique but surely we can come up with some guidelines to increase performance on a server level.
There are certain people in the community (that I do not think are here anymore) that were quite tight-lipped about sharing this kind of information, however I am a big believer in open source and transparency.
Would there be any interest in hosting a workshop or a series of workshops in order to share different setups and ideas on optimizing servers for Mautic? @joeyk@rcheesley@ekke ?
I had a very fruitful chat with @Leon_Oltmanns in Wien and made me realise, that we all try to tackle the same problem with different approach. I think all the knowledge is available, just scattered through the providers / people.
I don’t think someone has ALL the pieces of the puzzle, but together we might be able to put something together.
I suggest we do a series of meetups, where everyone would explain what they managed to solve, and how, and let’s see if we can learn from eachother.
Lets get something scheduled that is comfortable for everyone.
Can we get a list of interested people and I am happy to take the initiative of setting up the first series.
@rcheesley maybe you want to do an announcement here and on slack, once I am provided with the interested parties I will setup a quick survey that people can fill in about where they are and times/days that are comfortable for them and then I will go about scheduling the meetup