![更改 Innodb_buffer_pool_instances](https://linux22.com/image/745503/%E6%9B%B4%E6%94%B9%20Innodb_buffer_pool_instances.png)
使用 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'
答案1
它是innodb_buffer_pool_instances
,小写的i
。
使用 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'
它是innodb_buffer_pool_instances
,小写的i
。