更改 Innodb_buffer_pool_instances

Question

使用 mysql 5.6

innodb大小为512M

default is Innodb_buffer_pool_instances=8

尝试在 my.cnf 中添加

Innodb_buffer_pool_instances=1

收到错误

/usr/sbin/mysqld: unknown variable 'Innodb_buffer_pool_instances=1'

Answer 1

它是innodb_buffer_pool_instances，小写的i。