ERPNext Slow Performance

ERPNext
1

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

2

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
2 Likes
3

Where can I find the “my.cnf” file?

BKM

4

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"
3 Likes
5

Is it a specific 10 users? or roughly 10 random people that could switch at random?

6

Hello @trentmu,

Thanks for the great information.

I try, if it’s gonna work.

Thanks.
@Foxdemon96

7

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

8

I just came across this suggestion. See if it helps you.

9

Hello @trentmu

What’s the best way to calculate these values? Any references?

I run a 8gb server. Not sure what numbers to set.

1 Like
10

Try this for the buffer_pool value :
https://dba.stackexchange.com/a/27341:

1 Like
11

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

2 Likes