Hi,
I have installed Frappe Docker (GitHub - frappe/frappe_docker: Docker images for production and development setups of the Frappe framework and ERPNext ) for erpnext setup. Initially, I was using a db in the same cloud instance where the docker compose is running and it was running smoothly.
I had to move the db out of the instance to a new instance, and sometimes, there is a lag of almost >1s in a lot of APIs. I am unable to debug this as the instances are in the same network.
Can someone assist me with the issue or share an ideal ERPNext setup for production?
Anything from here helps?
I am running ERPNext on Kubernetes with an external MySQL server and Redis. I have monitored MySQL performance metrics, and there are no signs of issues.
To further investigate, I integrated OpenTelemetry for tracing. As shown in the attached screenshot, Redis and MySQL performance appear to be fine. However, I’m experiencing intermittent slow responses when calling a single backend endpoint.
For example, in Jaeger traces, a simple login request sometimes takes an unexpectedly long time, despi…
Configure db environment variables or config file for common memory related tweaks. Search forum and in general for mariadb config.