+1 vote
in Databases by (11.1k points)

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?

1 Answer

0 votes
by (15.8k points)

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.

...