Improving MariaDB performance

My PO and SO increased to about 30k, now the system is too slow when I create po and so, db lock happens often.

especially when I create a po/so which has many items (about 700+), MySQL has gone away and 504 Gateway timeout(nginx) happened.

Any idea to diagnosis the problems or any fix?

@nnylyj check your RAM

The biggest impact is from innodb_buffer_pool_size - this should be 60% of your RAM. The default is pretty poor.

30k- 40k is not a high volume

1 Like

Hello @rmehta

What are the possible limits for ERPNext in terms of

  1. Concurrent users
  2. No of Items
  3. No of Transactions