Home mysql I can not install innodb_buffer_pool_instances in Mariadb

I can not install innodb_buffer_pool_instances in Mariadb

Author

Date

Category

There Mariadb 10.5.8 database server Centos 7.8 c 32 GB RAM and i7-4770
All tables in the database only the type of InnoDB (MyISAM no tables). Here config my.cnf:

max_connections = 1536
key_buffer_size = 256M
read_buffer_size = 16M
join_buffer_size = 16M
# Query_cache_size = 128M
# Query_cache_limit = 2M
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 1M
tmp_table_size = 512M
max_heap_table_size = 512M
innodb_buffer_pool_size = 22G
innodb_log_file_size = 512M
innodb_flush_log_at_trx_commit = 0
thread_cache_size = 512
table_definition_cache = 1400 # As big as many tables you have
table_open_cache_instances = 4
table_open_cache = 207000
open_files_limit = 207000

After a reboot, all values ​​are set correctly config, except
table_open_cache_instances = 4
I just do not bother with this setting – install it at the beginning and the end of the config,
I rebooted both database systemctl restart mariadb.service and the entire server reboot. Nothing helps, after a reboot I go into phpmyadmin, drive in request

SHOW VARIABLES LIKE 'innodb_buffer_pool_instances'

and invariably get

Variable_name Value
innodb_buffer_pool_instances 1

For a long time Google, but did not find what could be the problem. It should be changed, but not me. Maybe it depends on some other variable, and should be installed with it?


Answer 1

table_open_cache_instances

table_open_cache_instances , in principle, does not appear in the Full List of MariaDB Options, System and Status Variables . So it is not clear what you are trying to install.

innodb_buffer_pool_instances

This setting Deprecated and ignored from MariaDB 10.5.1 , and removed in MariaDB 10.6.0 .

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions