ERPNext running slow

Install / Update Deployment
1

I have installed erpnext in a system with below configuration,is it enough for erpnext with 80+ user if not what are all the additional configuration needed…if anyone knows suggest me…how to fast up application as the system is very slow from User side

1 Like
2

@hereabdulla you will have to see how your mariadb is performing.

As I have said before, first place look is innodb_buffer_pool_size

1 Like
3

Thanx for the reply @rmehta

it is showing the below value

in /etc/mysql/my.cnf

innodb_buffer_pool_size = 256M

Do I need to increase, if yes means how much to get a maximum for 100 users ?
whether it is a size of RAM ?

Thanx in advance

4
1 Like
5

try innodb_buffer_pool_size = 70% of your ram = 5gb

6

Woah! Its too dangerous to set any values without knowing impact, never follow values from internet articles and guides as most of the times those are for reference only and it is expected you know what you are doing while using it.

Instead use simplest and easiest way to get correct values according to your live environment to optimize your database.
Try MySQLTuner > https://github.com/major/MySQLTuner-perl (it works with MySQL/MariaDB)

1 Like
7

I followed all the recommendation from mysql tuner
but nothing works…still my system is slow, even alloted 5gb of total 8gb ram to innodb_buffer_pool_size

8

check slow query log

9

@hereabdulla Share output of MySQL Tuner in text format (no screenshot)

10

Increase memory in redis_cache.conf

11

It is showing 50mb Idont know maximum how much I can give

12

Dear @rmehta, @Jay, @anand , @yashodhan
Thank u all for the reply…
Now My system is fast enough But I have a strange problem whatever may be the system,when I am login through Administrator account it working fast enough but when I login through any other user account then it become dead slow…today only I found this problem…is there any different approach for this…

13

Dear Frndz…
is there any solution for the above

14

@hereabdulla checking the slow query log will show you the bottleneck

15

@anand thanx for ur reply…
There is no slow query log registered in my system.

and the system is fast when I login through admin account in any system…but any other user account except admin, it is slow…that is strange…

16

@hereabdulla

Please check documentation for MariaDB (it is 3rd party thing)

The slow query log is disabled by default. To enable it, set the slow_query_log system variable to 1.

17

@hereabdulla maybe some of the permission configuration is slowing down the system. Slow query logs will help to investigate the issue.

18

Slow query log shows nothing but stills system get slow loading (mostly in list loading)

here slow query output,as I mentioned earlier whatever may be the system when I login through Administrator account it loads faster but logging through other account become slow…

/usr/sbin/mysqld, Version: 10.0.24-MariaDB-1~trusty (mariadb.org binary distribution). started with:
    Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
    Time                 Id Command    Argument
19

It seems you have GUI loaded on server, does it serve any other purpose?

If you are in local environment, its not just MySQL, but you will also need to optimize Nginx, SocketIO, Redis workers to manage the load, plus you will also need to checkout Network level slow downs, are you used Managed switch or simple/unmanaged switch because that also makes big difference in terms of serviceability and QOS.

You should use newrelic.com APM and Server Monitoring to actually findout root cause, or simply change the server… :wink:

20

where can i find " redis cache " so i can change the value for it.