MySQL Forums
Forum List  »  Backup

in MySQL the parameter open_files_limit not change
Posted by: Soporte Seti
Date: March 28, 2015 10:12PM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
in MySQL the parameter open_files_limit not change
3149
March 28, 2015 10:12PM


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.