前段时间奶爸把一台VPS环境从LNMP换到了宝塔面板,结果经常MySQL数据库莫名其妙的自动停止,看日志也没看出来是什么问题,所以就只能来一招最简单的数据库进程守护up.
宝塔面板添加MySQL进程守护脚本方法
InPagoda Panel后台,点击计划任务,然后添加一个Shell脚本。名字自选,执行周期按分钟执行,奶爸这里是设置的十分钟,脚本内容如下:
pgrep -x mysqld &> /dev/null if [ $? -ne 0 ];then bash /www/server/panel/script/rememory.sh /etc/init.d/mysqld start fi
另外在MySQL的性能优化里面,设置了一下,然后保存了发现并没什么卵用,MySQL依然停止运行,代码如下,空了再来具体研究问题所在了。
190513 14:39:11 [Note] /www/server/mysql/bin/mysqld: Normal shutdown 190513 14:39:11 [Note] Event Scheduler: Purging the queue. 0 events 190513 14:39:11 InnoDB: Starting shutdown... 190513 14:39:12 InnoDB: Shutdown completed; log sequence number 618693401 190513 14:39:12 [Note] /www/server/mysql/bin/mysqld: Shutdown complete 190513 14:39:13 [Note] Plugin 'FEDERATED' is disabled. 190513 14:39:13 InnoDB: The InnoDB memory heap is disabled 190513 14:39:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190513 14:39:13 InnoDB: Compressed tables use zlib 1.2.7 190513 14:39:13 InnoDB: Using Linux native AIO 190513 14:39:13 InnoDB: Initializing buffer pool, size = 256.0M 190513 14:39:13 InnoDB: Completed initialization of buffer pool 190513 14:39:13 InnoDB: highest supported file format is Barracuda. 190513 14:39:14 InnoDB: Waiting for the background threads to start 190513 14:39:15 InnoDB: 5.5.57 started; log sequence number 618693401 190513 14:39:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 190513 14:39:15 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 190513 14:39:15 [Note] Server socket created on IP: '0.0.0.0'. 190513 14:39:15 [Warning] 'user' entry 'x@%' has both a password and an authentication plugin specified. The password will be ignored. 190513 14:39:15 [Note] Event Scheduler: Loaded 0 events 190513 14:39:15 [Note] /www/server/mysql/bin/mysqld: ready for connections. Version: '5.5.57-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 190513 14:39:21 [Warning] IP address '2' has been resolved to the host name '2.vultr.com', which resembles IPv4-address itself. 190513 14:39:43 [Warning] IP address '9' has been resolved to the host name '9.vultr.com', which resembles IPv4-address itself. 190513 14:39:48 [Warning] IP address '8' has been resolved to the host name '8.vultr.com', which resembles IPv4-address itself. 190513 14:40:12 [Warning] IP address '9' has been resolved to the host name '9.vultr.com', which resembles IPv4-address itself.
2021年05月14日更新:依然死,调整了下swap大小再观察下。然后还重启了一次服务器。开机后内存使用600+,还空200+
This entry is part 2 of 14 in the series: 宝塔面板教程
- Pagoda panel firewall open port_firewalld_iptables add rules
- Pagoda Panel MySql process daemon script_Automatic restart after database shutdown
- Pagoda management commands Forgot the password of Pagoda panel solution
- How to add websites inside the pagoda panel_bind more websites
- 2021 new version of pagoda panel installation WordPress website tutorial
- Pagoda panel upgrade WordPress prompt error when connecting to the server need FTP information solution
- Pagoda panel phpMyAdmin reported 405 not allowed error solution
- Pagoda panel automatic backup website and database to FTP storage space tutorial
- How to restore Pagoda Backup website_Server backup data recovery tutorial
- Pagoda panel forget backstage login URL, security portal verification failure solution
- How to install Memcached, ionCube and other extensions in Pagoda Panel
- Install the site yourself using the Pagoda panel video tutorial
- Pagoda panel how to upgrade phpmyadmin to version 4.9
- 2022宝塔面板安装教程(更新安装视频教程)