linux 上的数据库 mysql 突然挂掉了
重启mysql(systemctl restart mysqld ), 出现类似下面的情况:
/system.slice/mysqld.service
└─control
├─2571 /bin/bash /usr/bin/mysql-systemd-start post
└─3541 sleep 1
最后查看 mysql.log 发现不知道错误的错误:
[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
[Warning] Buffered warning: Changed limits: max_connections: 216 (requested 1000)
根据https://blog.csdn.net/redlevin/article/details/51996990 修改:
在 /etc/security/limits.conf 文件中加入:
* hard nofile 65535
* soft nofile 65535
在 /usr/lib/systemd/system/mysqld.service 文件中加入:
LimitNOFILE=65535
重启mysql(systemctl restart mysqld), 报以下信息:
mysqld.service changed on disk. Run 'systemctl daemon-reload' to reload units.
运行一下:systemctl daemon-reload
搞定收工!