I have installed erpnext on a laptop running Ubuntu 14.04 with a RAM of 8 Gb . Now a days it takes ages to load a particular page , I read in few posts that the Innodb pool buffer size should be set to 80% of RAM , I checked in the cnf file , it was set to 256Mb , so I am planning to increase the buffer size . Could anyone guide me with a clear example of how to change the buffer size , few posts indicates that directly editing the cnf file would corrupt the database . Please someone help me with the proper procedure to change the buffer size.
The best way to make changes to variables is to create your own cnf file. This way, things won’t get overwritten during any Ubuntu, MariaDB, or ERPNext update.
I recommend making a new .cnf file in /etc/mysql/conf.d and making the change in there.
First, stop mariadb sudo service mysql stop
Then create the file, add the variable
Then restart mariadb sudo service mysql start