Update of innodb_buffer_pool_instances

[Girish Salunke]

Dear Team,

We are using MySQL 8.0.37 community version and want to update innodb_buffer_pool_instances and other variable too to increase the performance.

I edited the my.ini to add entry for innodb_buffer_pool_instances=8 and restarted MySQL services. But system is taking dafult value for innodb_buffer_pool_instances=1.

I tried to set the varibale through SET PERSIT and SET GLOBAL command. But couldn't set because of read only variable.

Let me know if you have any clue to set innodb_buffer_pool_instances to 8.