+3 votes
in Databases by (5.8k points)

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?

1 Answer

0 votes
by (25.0k points)
edited by

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.

...