Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Not a Bug
-
10.6.13
-
Almalinux 8, CPanel.
Description
In /etc/my.cnf, table_open_cache is set to 1024. However, `show variables like 'table_open_cache';` shows 200. If a value LESS than 200 is set in my.cnf, it takes that value, but anything more than 200 and it's capped at 200.
We can dynamically set it to a higher value using `set global table_open_cache = 1024;`, and that is reflected in the variable, but we can't seem to set a higher value from my.cnf and have it apply after restarting the service.
`ulimit -n` returns 1024. `open_files_limit` is 40000. We've also checked that there are no other configuration files overriding the value (and besides that wouldn't explain why we can set it to values < 200). Also checked the error log, but didn't see any startup errors there.
This is happening on three separate new Almalinux 8 servers we've provisioned, but did not occur on our old servers, which were on MariaDB 10.6.12, on CentOS 7.