环境:
OS:Centos 7
DB:mysql 5.7
1.测试环境一台机器每天都要重启一次
2024-03-31T20:08:10.130560Z mysqld_safe mysqld restarted 2024-03-31T20:08:10.183119Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 25000) 2024-03-31T20:08:10.183338Z 0 [Warning] Changed limits: max_connections: 4190 (requested 5000) 2024-03-31T20:08:10.183349Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 2000)
2.查看/etc/security/limits.conf
* soft nproc 65536 * hard nproc 65536 * soft nofile 65536 * hard nofile 65536
配置正常
3.查看自启动配置文件
我这里做了系统服务自启动的方式,在文件里写死了LimitNOFILE = 5000,问题应该是这里导致的
[root@localhost logfile]# vi /usr/lib/systemd/system/mysql.service [Unit] Description=MySQL Server Documentation=man:mysqld(8) Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html After=network.target After=syslog.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql ExecStart=/home/mysql57/bin/mysqld_safe --defaults-file=/home/mysql57/conf/my.cnf --user=mysql ##LimitNOFILE = 5000 #Restart=on-failure #RestartPreventExitStatus=1 #PrivateTmp=false
将LimitNOFILE = 5000参数注释掉,然后重启mysql服务
标签：03,5000,restarted,08,safe,mysqld,mysql From： https://www.cnblogs.com/hxlasky/p/18108568