Mysql : ERROR 1238 (HY000): Variable 'innodb_buffer_pool_size' is a read only variable

Question

I am trying to modify the value of innodb_buffer_pool_size from the command line, but I am getting the following error:

"ERROR 1238 (HY000): Variable 'innodb_buffer_pool_size' is a read only variable"

How can I fix it?

Answer 1

Try to update my.cnf (for linux) or my.ini (for windows) file instead of doing from the command line. It might work.

Add or change the needed variables under the [mysqld] section in my.cnf or my.ini file and restart the MySQL server.

[mysqld]

innodb_buffer_pool_size=xxx , where xxx is the size of the buffer pool.