Hello Guys,
Is it possible out of 80 users only 10 users experiencing slow performance overall ?
Sorry about this guys, I’m still new with the ERPNext.
Thanks.
@Foxdemon96
Hello Guys,
Is it possible out of 80 users only 10 users experiencing slow performance overall ?
Sorry about this guys, I’m still new with the ERPNext.
Thanks.
@Foxdemon96
Check that your mysql settings are optimised. In particular, these… (in the my.cnf file).
This example is for a machine with 4GB RAM. I can’t guarantee that they are perfect, but they helped a bit on my system
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=2G
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=512M
innodb_log_buffer_size=256M
# the default here is 4MB, or maybe 16MB?? in more recent versions, which sometimes allows for disconnects in the middle of transactions
max_allowed_packet=64M
Where can I find the “my.cnf” file?
BKM
Normally (Distro dependant)…
/etc/mysql/my.cnf
#but, can also be
/etc/mysql.conf
This command should help to locate it
sudo mysqld --help --verbose | grep "cnf\|conf" | grep -v "config\|conflict"
Is it a specific 10 users? or roughly 10 random people that could switch at random?
Hello @chabad360,
Those 10 users are the one who works a lot by inserting to much data at the same time they are the one who approved in and out transactions, by doing it I used workflow.
Thanks.
@Foxdemon96
Hello @trentmu
What’s the best way to calculate these values? Any references?
I run a 8gb server. Not sure what numbers to set.
For 8GB, I would use this…
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=4G
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=1G
innodb_log_buffer_size=512M
# the default here is 4MB, or maybe 16MB?? in more recent versions, which sometimes allows for disconnects in the middle of transactions
max_allowed_packet=64M
There are a few mysql optimisation tools available that will analyse it for you and give you recommendations.
This one is the best I’ve tried
A few good articles on the topic