Performance issues on Amazon AWS after only 2 days

I deployed Mautic to AWS’s free tier (via Bitnami: https://bitnami.com/stack/mautic) two days ago and now I am already experiencing huge performance issues.



After only 2 days of social monitoring, I have 50,000 leads identified via their Twitter handles. However it takes over a minute (sometimes several minutes) to load every page on Mautic, rendering it pretty unusable, and this is obviously is cause for concern with regard to scaling.



What would be the cause of this performance bottleneck?



How might one go about scaling Mautic to prevent this issue?



What is the maximum number of leads Mautic can handle?

I deployed Mautic to AWS’s free tier (via Bitnami: https://bitnami.com/stack/mautic) two days ago and now I am already experiencing huge performance issues.

After only 2 days of social monitoring, I have 50,000 leads identified via their Twitter handles. However it takes over a minute (sometimes several minutes) to load every page on Mautic, rendering it pretty unusable, and this is obviously is cause for concern with regard to scaling.

What would be the cause of this performance bottleneck?

How might one go about scaling Mautic to prevent this issue?

What is the maximum number of leads Mautic can handle?

Here’s the only noteworthy bit in Mautic’s log:

[2016-11-23 11:10:07] mautic.ERROR: Notice: unserialize(): Error at offset 166 of 273 bytes - in file /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] []

And here’s a screenshot showing the 32 second load time, seemingly due to problems loading the contacts.

http://imgur.com/a/Zj2M4

What is your server hardware

T2 Micro on AWS EC2.
https://aws.amazon.com/ec2/instance-types/

It’s the default deployment for Mautic on Bitnami.

For now I have simply scaled up the specs on my server, however I wonder whether this is a realistic solution given that I’ve had to increase my server budget by about $100/month after only 2 days of lead growth.

Well, after you switched to a better server config, did the problem go away?

Yes, but who’s to say that the performance will not degrade after another few days? My intuition tells me that Mautic is not ready for enterprise scale. It should be able to query 50,000 leads just as quickly as 5,000. I’ve run forum software with five or six times that many rows, and never once had to wait 30-60 seconds for a page to load. I think Mautic must be using resources inefficiently.

I tried Mautic in a micro instance and had to change to a more powerful instance. I found that MySQL kept crashing. However, you shouldn’t have to spend much.