I'm trying to increase to 9000 but MariaDB sets it at 4895 automatically.
Here is my simple config https://pastebin.com/raw/4eFiuFSv
MySQLTuner output:
Control warning line(s) into /var/lib/mysql/cp.goal.ge.err file
Control error line(s) into /var/lib/mysql/cp.goal.ge.err file
Restrict Host for user@% to user@SpecificDNSorIp
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Temporary table size is already large - reduce result set size
Reduce your SELECT DISTINCT queries without LIMIT clauses
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64:
Beware that open_files_limit (10000) variable
should be greater than table_open_cache (4895)
Optimize queries and/or use InnoDB to reduce lock wait
Consider installing Sys schema from https://github.com/mysql/mysql-sys
Variables to adjust:
query_cache_size (=0)
query_cache_type (=0)
query_cache_size (> 125M)
table_open_cache (> 4895)
/var/lib/mysql/cp.goal.ge.err
to see if there are any references to this variable.mysql
client and execute:SET GLOBAL table_open_cache=9000;
Does that work?