Centos Web Panel (CWP): How to change the value of innodb_buffer_pool_size in MariaDB/MySQL

Question

I have installed CentOS web panel on my VPS. The configuration file of the MySQL (/etc/my.cnf) is empty. I want to increase the value of innodb_buffer_pool_size from default 128MB to 2GB. Where should I make the changes?

Answer 1

There should be server.cnf file in folder /etc/my.cnf.d. Open this file in your text editor and search for [mysqld]. Add the following highlighted line below [mysqld].

[mysqld]
innodb_buffer_pool_size=2G

Save the file and restart the MySQL server either from the CentOS web panel or command line. This will set the innodb_buffer_pool_size to 2gb.