+2 votes
in Databases by (71.8k 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

+1 vote
by (353k points)
selected by
Best answer

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].


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.