How to set table_open_cache of MariaDB

Submitted by TeamAdmin on Fri, 12/20/2019 - 18:49

First make sure that your sytem  has correct value for "LimitNOFILE"

Open this file: /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf

Check for this variable
# converted using /usr/bin/mariadb-service-convert
#
[Service]
LimitNOFILE=512 --> "65536"​

 

Save this file.

Now any changes inside my.cnf are applicable.

 

System might ask for
# systemctl daemon-reload

Now restart mariadb service

# systemctl restart mariadb

# systemctl status mariadb -l

table_open_cache, mariadb  table cache hit rate,  table_open_cache, percona  table_open_cache, mysql 8 table_definition_cache,  mariadb table_definition_cache,  table_open_cache_instances