K
K
Kirill Gerasenkov2014-09-17 12:29:07
MySQL
Kirill Gerasenkov, 2014-09-17 12:29:07

Why doesn't table_cache change in MariaDB?

Good afternoon, there is a bunch:
PHP Version 5.4.16 + Apache / 2.4.6 + 5.5.37-MariaDB + nginx 1.6
Above the base, of course, like all ordinary users, phpmyadmin v.4.2.7.1 hangs
and all this is spinning on CentOS 7.
The problem is that the tuner decided to scan Maria and received in response that my table_open_cache is too small.
I laughed, because I completely re-uploaded the config (my.cnf) and specified table_open_cache = 4096 in it, which is quite enough for my 3K tables.
BUT, as it turned out, it did not change and defaulted to 407.
What could be the problem?
Maria's logs say:
140917 13:10:32 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
140917 13:10:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
nikoinlove, 2014-09-26
@m000dy

mysql cannot set a limit greater than the system limit on open files
, you can see it ulimit -n
increase - ulimit -n 4096

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question