in MySQL the parameter open_files_limit not change
Hi,
I have O.S "CentOS Linux release 7.0.1406 (Core)" and MySQL 5.6.23, when I try to increase parameter open_files_limit and max_connections, this parameter not change.
The files limits:
cat /etc/security/limits.conf:
* soft nofile 1024000
* hard nofile 1024000
* soft nproc 10240
* hard nproc 10240
mysql soft nofile 8192
mysql hard nofile 8192
the file /etc/my.cnf:
[mysqld]
open_files_limit = 8192
max_connections = 1000
After MySQL restart :
mysql> show global variables like 'open%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 1024 |
+------------------+-------+
1 row in set (0.00 sec)
mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 214 |
+-----------------+-------+
1 row in set (0.00 sec)
Can you help me?
Thanks!
Subject
Views
Written By
Posted
in MySQL the parameter open_files_limit not change
3309
March 28, 2015 10:12PM
1340
April 01, 2015 03:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.