Cannot set innodb_buffer_pool_size above 1023M in my.ini Windows server 2012 R2 with 64GB RAM, MySQL 8. The Database is about 5GB.

I am using a buffer pool of 1023M, as shown below:

innodb_buffer_pool_size=1023M


If I enter anything above 1023M e.g. 1024M or 2G then MySQL will not start and the following appears in the errorlog:


  "Configuring persisted options failed: "Variable
  'innodb_buffer_pool_size' can't be set to the value of '8388608'".


If I use the value 8388608, then it starts (which is ironic) but that's not enough.

When running using:

SET GLOBAL innodb_buffer_pool_size=10737418240; 


It starts fine and sets the pool to 10GB - but that reverts back when rebooted.

Any pointers would be great.
"Persisted options" is new in 8.0.  See if this works:

SET PERSIST innodb_buffer_pool_size=10737418240;


For more info:

https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html