MySQL and max_open_files issue

[berekin]

Hi all,

i have installed Centos 7 when i start MySQL server there are some warnigns in log files..

141111 20:08:27 mysqld_safe Starting mysqld daemon with databases from /home/mysql
2014-11-11 20:08:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-11-11 20:08:27 1903 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535)

2014-11-11 20:08:27 1903 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)


[root@tsv3-mysql ~]# ulimit -a mysql
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 118920
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 65535
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 65535
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

my /etc/security/limits.conf looks like this

* soft nproc 65535
* hard nproc 65535
* soft nofile 65535
* hard nofile 65535

mysql soft nofile 65535
mysql hard nofile 65535


mysql version is

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.21 MySQL Community Server (GPL)

uname -a
Linux test-mysql 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux


Can you please help? I have read about this issue on the internet and it looks like there is a bug in Cetnos..

[avij]

Does this happen on CentOS-provided mariadb as well?

No, this is not a support forum for third party software, sorry.

[gerald_clark]

CentOS 7 comes with MariaDB, not MySQL.
You will need to get support from the people that supplied your MySQL.

[dpasqua]

Hi,

Edit file /usr/lib/systemd/system/mysqld.service

Add at end:

LimitNOFILE=65535
LimitNPROC=65535

Save file and exexute:
# systemctl daemon-reload

Restart mysql:
# service mysqld restart

Best regards