too maney files open MySQL 解决方案

方案源于：

http://unix.stackexchange.com/questions/152186/mysql-max-open-files-more-than-1024#answe

r-15791;

Edit /etc/security/limits.conf and add the following lines

mysql soft nofile 65535

mysql hard nofile 65535

then reboot.

Then

edit /usr/lib/systemd/system/mysqld.service or /usr/lib/systemd/system/mariadb.

查看进入 MySQL --> open_files_limit 65536 OK