i am using MariaDB database for ERPNext. This site is production site i need to optimize this site database without any data losses please give me best solution .
On the ERPNext site, you can access the white paper on Scaling ERPNext at the following link:
Chapter 2.3, which covers Database Scaling, may be useful. Please note that it provides general guidance rather than detailed, step-by-step tutorials.
Profiling and monitoring could assist you with this also.
I hope this information proves helpful to you.