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.