ERP Running very slow, please in need your help

ERPNext
, , , ,
1

Dear Supports

I am currently experiencing a significant slowdown with our ERP system. We are using ERPNext in a production environment, running on an OVM file in a virtual machine (VM). When opening patient names or accessing related records, the system hangs for approximately five minutes, severely impacting workflow efficiency.

I would greatly appreciate your assistance in resolving this issue. Below are some key details for your reference:

  • **ubuntu 16.04.4 erp next vm vbuilt on marach 31 2018
  • Host System Configuration: [e.g., CPU, 16gbRAM, and 50 storage allocated to the VM]
  • Virtualization Platform: [ VirtualBox]
  • Steps to Reproduce:
    1. Navigate to [i.
    2. Open a patient name or record.
    3. Experience prolonged lag or hanging (5 minutes or more). i couldn’t open any file , its taking long time to open.

Could you please advise on potential causes or provide guidance on optimizing the system for better performance? If additional information or logs are required, kindly let me know, and I will provide them promptly.

Thank you for your attention to this matter.

2

install ubuntu in a system and use it, VM don’t work properly after sometime and causes frequent lags , slow system etc.

3

To check-

Check System Resource Usage

Review ERPNext Logs:

Check the ERPNext logs for any errors or warnings that could point to the root cause. Look in these log files:

  • ERPNext logs: /home/erpnext/frappe-bench/logs/
  • System logs: /var/log/syslog, /var/log/dmesg, /var/log/mysql/error.log

Check MySQL (MariaDB) Configuration:

ERPNext relies heavily on MySQL (MariaDB). If the database is not properly optimized, it can cause delays when fetching patient records or other data.

  • MySQL Performance: Check the performance of MySQL by running the following commands:
sudo systemctl status mysql
sudo mysql -u root -e "SHOW STATUS LIKE 'Innodb_buffer_pool%';"
sudo mysql -u root -e "SHOW STATUS LIKE 'Qcache%';"
  • Increase InnoDB Buffer Pool Size: If you have more available RAM, consider increasing the InnoDB buffer pool size in /etc/mysql/my.cnf. A larger buffer pool helps with database caching, which can improve query performance.
  • Check slow queries: Look into the MySQL slow query log to identify slow queries that might be contributing to the lag. You can enable the slow query log if it’s not already enabled.

Cache clear

bench --site your_site_name clear-cache
1 Like
4

3

2
21366×768 12.4 KB

one

5

please , iam completely in ERP system. COuld you please any possible i can be contact you?

6

Brother im not familiar with the vm, as it works very slow, you should wait and let someone else reply to this post.

Till then you can use google and check how you can optimize the vm for more stable and better use.

7

For the past five years, I did not face any slowness issues. the problem started three days ago, and I have been struggling to find a solution.

8

You can check these settings.

  1. Resource Allocation: Increase CPU, RAM, and disk space allocated to the VM.
  2. Disk Type: Ensure the virtual disk is stored on an SSD.
  3. VirtualBox Settings: Optimize settings such as I/O, paravirtualization, and disk caching.
  4. Check Host Performance: Make sure the host system is not overcommitted with resources.
  5. Network Performance: If accessing remotely, ensure the network connection is stable and fast.
9

1:CPU: 2 CPUs are allocated to the VM. The physical machine has a total of 16 GB of RAM.

2: RAM: 12 GB of RAM is allocated to the VM, while the host system retains the remaining RAM.

3: Disk Storage: The VM has 40 GB of storage allocated.

4: Network Performance: We are using a high-speed network with a speed of 100 Mbps.

10

@Boosa_Shravan how big is the innodb_buffer_pool_size in your sql settings ?

11

44

12

@Boosa_Shravan if your vm is using nothing but the erpnext , give it half the ram allocated to your vm . so 5G or 6 G. then restart mysql

13

45
can you please share me MYsql restart command ?

14

sudo systemctl restart mysql .
and the file should be /etc/mysql/my.cnf

15

46
Please, I am completely new to Linux. If you could share the steps step-by-step, I will follow . I am really sorry for any inconvenience

16

systemctl not system . copy the exact command

17

for the save, i used Control +O enter, Control +X

18

@Boosa_Shravan I dont know and it doesn’t matter what editor you are using . just save it , reopen the file to make sure it’s saved .

19

sorry … now entered correctly. its accepted command.
47

20

any changes ?