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

The Register - Software

The Register is a leading global online tech publication, with more than nine million monthly unique browsers worldwide. The core audiences are the UK and US, accounting for more than 6m. The bulk of the remaining readership are located in Canada, Australia and northern Europe.