Have a Single Server that has both App and DB. It has 16 GB Ram. So I tried to increase the innodb_buffer_pool_size to 8GB to improve the DB Performance.
in the /etc/mysql/my.cnf i
After that i restarted mysql service.
To Verify, whether the buffer pool is increased, i gave the following command
The Value that is set is 768M and not 8GB. Also the default value given in the my.cnf file is 256M. So not sure how come 768M is selected as the buffer size.
Are we missing some thing here? How do we increase the pool size and verify whether it has actually increase or not?
Hi. My ERPNext cnf file also looks similar. All configuration are in the other file. @saravana can you share the changes here, I am also running on 16 GB, 6 core Ubuntu 20 server. Getting not so great performance. Thanks.