我最近将我的 mariadb 数据库更新到 10.5.5,我无法设置 innodb_buffer_pool_instances
innodb_log_file_size = 3G
innodb_buffer_pool_size = 12G
innodb_buffer_pool_instances = 12
但当
MariaDB [(none)]> SHOW VARIABLES LIKE "%innodb_buffer_pool_%";
+-------------------------------------+----------------+
| Variable_name | Value |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size | 134217728 |
| innodb_buffer_pool_dump_at_shutdown | ON |
| innodb_buffer_pool_dump_now | OFF |
| innodb_buffer_pool_dump_pct | 25 |
| innodb_buffer_pool_filename | ib_buffer_pool |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 12884901888 |
+-------------------------------------+----------------+
我需要其他变量来配置池实例吗?哪个?
非常感谢您的任何想法。
innodb_buffer_pool_instances在 10.5 中被删除,因为由于代码的内部重组,它们没有提供任何好处。
没有替代设置。
该变量无用,仅用于兼容性,将在 10.6 中删除