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?
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.
This setting Deprecated and ignored from MariaDB 10.5.1 , and removed in MariaDB 10.6.0 .