How to fix "Unavailable" with ERPNext On Amazon AWS on T2xlarge

[Ibrahim_Malek1]

Hello Everyone,
I did an installation along time ago on Amazon AWS using UnbntU linux 14.6, & kept upgrading the instance as long as my users are growing till we reached the T2xlarge instance now, however, for the 80 users I have sometimes the system give’s the unavailable page for no reason, I’ve never try any performance tuning on the linux or the MariaDB back-end please advice
regards,
Malek

[Mukesh_Variyani]

If you haven’t then first increase workers (Recommended workers 9 for T2xlarge) in common_site_config. Generally path: frappe-bench/sites/common_site_config.json

Also consider some performance tuning for mysql as suggested in below post, file path: /etc/mysql/my.cnf

Performance Issues (large data)

Some suggestions Start logging slow queries Check your innodb_buffer_pool_size (keep it to 60% of your RAM) - make sure you have enough RAM! Check your RAM usage Check Redis cache size - keep it to 10% of the RAM Try and posting the slow queries and we can figure how to speed things up. Edit: Having multiple cores would also be important if you have lots of parallel entries.