Hi, I’m experiencing very High CPU Usage. I know I have a lots of leads, and I send 1000/2000 email/day. Does anybody have the same problem?
Hi, I’m experiencing very High CPU Usage. I know I have a lots of leads, and I send 1000/2000 email/day. Does anybody have the same problem?
+1
MySQL is having high usage for segments rebuild. This is happening since update to 4.3.1
My host provider sent me a mail with a complain about CPU overhead
This all depends on the number of contacts, number of segments, number of campaigns and how your cronjob are setup to run.
It is a science in itself and would be amazing if Mautic was able to address this issue, currently it is a manual configuration thing and you need to understand how to setup this by yourself using cronjob.
It can also be on sites that have very high traffic.
It not depend of number of contacts or anything else. I have moved my mautic instance to a private server with Ubuntu 20.04 php 8.0.21 and mariadb 10.6.7
Everything is fine but when selected option channel->emails… Even I am not doing nothing suddendly the mariadb process is starting to use more and more CPU until 100% and mautic is hung… I can not sleect other option… I just need to restart mariadb and then I can use again everything in mautic if I will not select emails option. cronjobs are stopped in otrder to do not have any task running… The result is always the same entering in the emails list (with only 17 mails) the CPU goes up because the DB usage. I have 2 Cores and 4GB (memory usage is ok)
Mautic version is 4.4.1 (I think this happens since version 4
Hi,
Is it possible, that your cron commands are overlapping each other?
Is this dedicated CPU? Also: is it possible, that your mariadb settings are different from before and certain memory settings make the process less efficient?
Any takeaways from this?
To avoid these problems all cron commands are stopped… Mariadb is configured as per defaults.
I can work in Mautic without any problem but once I access to ->Channels->Emails I can not do anything more… the system hangs (I can only see the emails list). I can not go to other section "dashboard for example)… and Mariadb is getting to 100% CPU
Slowly is going up…
By the way all mautic instances that I have in the server are hang because Mariadb is not responding
I think since version 4 there is a “loop” in the code.
Yes… I have in php.ini max_memory_size=1G. But memory is ok… is CPU what is really bad
Moved the db to a hosted and administrated by the hosting with MariaDB 10.5 and the result is the same… when enter in emails… the mautic system hangs 
. I can not send more mails. It is really a pitty
After many tests and the same problem I have rolled back the Mautic to version 3.3.5 (Thank’s god DB schema did not changed) and now everything works fine. For me it is clear that is a Mautic 4 bug
What is the size of your email stats table?
The size I see in phpmyadmin is 475K
Is this the number of lines?
I would be interested in total GB.
My theory is, that you have to many lines, that your Mautic can’t process the emait_stats table.
Possibly due to large images (or many small) used in emails, which now all stuck in the table.
J
Yeah 450K rows… and I have images in the mails of course. 2-5 images of normally 500X300
So I should not include images in the mails? 
So it works in 3.3.5 because the images do not go to the table?
I didn’t say you shouldn’t and that size is totally fine. Just trying to understand why your emails won’t open. Images go into the table, if it works fine in 3.3.5, then probably there is something in 4.+
Just thinking of a workaround for you because downgrade is not an option.
Just for clarification… It is not that emails do not open… it is when open the list of mails… I can not even sort them by id… once I enter in this screen below all the system hangs
Downgrade “was not an option” but finally after many many tests and tries… I had to downgrade to 3.3.4 again… Thanks God The 4.4.1 database works in 3.3.4 after doctrine:schema:update --force
I could not test every single function, but the main ones are working… I missed the images of my mails… but I will load them again. At least the emails (text and format) still there…
So this is allowing me to continue sending mails
This is super weird, because I’m overviewing 80 installations right now and we don’t have this problem. Could be environment, or maybe even content of an email in the DB. Really hard to figure out.
I totally understand and I tried to avoid in the last 7 days to do weird things…
But it is a reality that the same mails and the same info works fine in 3.3.4 and not in 4.4.1
I do not know why… but it is a fact.
I made several test to determine where was the problem… but for sure there is some queries that with my mails make the DB hang because high CPU use… (seems a loop)
I tested different environements and different DB version… in private MAriaDB (10.6) hosted MariaDB (10.5) and it is the same…
If someone is interested to see what happen… I am open to send the mautic DB (4.4.1) to test what is happening in the end could help not only me but also to know what is happening
And you said you had no weird entries in your logs, right?