mysql-Too many open files

今天由于进行数据库备份，写完脚本之后进行测试的时候，发现报错。
[root@mysql-master shell]# sh sql-pin.sh 
Warning: Using a password on the command line interface can be insecure.
mysqldump: Got error: 23: Out of resources when opening file './pin/ims_ewei_shop_task_poster_qr.MYD' (Errcode: 24 - Too many open files) when using LOCK TABLES
此时进入数据库：
输入 
	mysql> show variables like '%open%';
	+----------------------------+----------+
	| Variable_name              | Value    |
	+----------------------------+----------+
	| have_openssl               | DISABLED |
	| innodb_open_files          | 431      |
	| open_files_limit           | 1024     |
	| table_open_cache           | 431      |
	| table_open_cache_instances | 1        |
	+----------------------------+----------+
	5 rows in set (0.00 sec)

open_files_limit  为1024 需要变大
修改/etc/systemd/system/mysqld.service
再最后一行加入
	LimitNOFILE=102400
重启mysql
[root@mysql-master system]# systemctl daemon-reload
[root@mysql-master system]# sudo service mysql restart
再次进入mysql数据库
mysql> show variables like '%open%';
+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| have_openssl               | DISABLED |
| innodb_open_files          | 2000     |
| open_files_limit           | 102400   |
| table_open_cache           | 2000     |
| table_open_cache_instances | 1        |
+----------------------------+----------+
5 rows in set (0.00 sec)
现在 
	open_files_limit   102400
然后运行脚本就不会报错。