mysql启动提示：Could not increase number of max

mysql启动提示：Could not increase number of max

mysql启动的时候提示：

2022-01-17T08:46:30.812801Z 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 65535)
2022-01-17T08:46:30.812878Z 0 [Warning] Changed limits: max_connections: 214 (requested 9240)
2022-01-17T08:46:30.812885Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 2000)
2022-01-17T08:46:30.999425Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. 

在mysql客户端里面查询max_connections的值，真的是214！这怎么够呢？！
检查一下配置参数

root@infokist:~# ulimit -n
65530
root@infokist:~# cat /proc/sys/fs/file-max 
3035361
root@infokist:~# cat /etc/security/limits.conf 

* soft nofile 65530
* hard nofile 65535

在服务配置文件/etc/systemd/system/multi-user.target.wants/mysql.service 中增加下面一行
LimitNOFILE=10000

# systemctl daemon-reload
root@infokist:~# service mysql restart