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 .