open_files_limit

Zoinkies

Anyone had any luck setting open_files_limit for MariaDB?

cPFence

Yes, it's working well. Just make sure to add the variable below [mysqld] and restart MariaDB. Then, verify the change by running:

mysql -N -e "SHOW VARIABLES LIKE 'open_files_limit';" | awk '{print $2}'

If the value hasn’t changed, manually restart the container with:

docker stop mariadb
docker start mariadb

DracoBlue

Is it not possible in the panel in my.cnf?

Zoinkies

Doesn't seem to actually set it

Zoinkies

cPFence Yea it just won’t set

cPFence

Zoinkies

Forget about the UI and do it manually. Try this:

docker exec -it mariadb bash  
cat /etc/mysql/conf.d/enhance.cnf 
 
# Make sure `[mysqld]` and `open_files_limit` are both in the file.  

# If they’re not found, add them manually:  

echo "[mysqld]" >> /etc/mysql/conf.d/enhance.cnf  
echo "open_files_limit = 65535" >> /etc/mysql/conf.d/enhance.cnf  

Then restart MariaDB:  

docker stop mariadb  
docker start mariadb

Zoinkies

cPFence thanks again pal, much appreciated I will give this a go now.