Wish I Knew This Before (InnoDB Buffer Pool Optimization)

Increasing the InnoDB Buffer Pool is game changer. I have been using Frappe for quite a few months now, but I never got across this. Increasing the InnoDB buffer pool to around 60% of my RAM really improved memory and speed of my instance. ERPNext was feeling really slow since we started using it for real scenarios in my company, but doing this one little optimization reduced a lot of overheads for me. See for yourself

From 80% memory usage to 36%, that’s like literally 50% less memory consumption and the system feels responsive again.

There are actually tons of posts about this already but I never came across them before. So I am posting this to make it visible once again to the community.

You can find how to this with a simple search on the forum, I’ll list out the steps that worked for me

vim /etc/mysql/my.cnf

Add the below line to your mysql conf:


character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

Check this old link which has the above and many more tips.