VPS侦探论坛

 找回密码
 注册
查看: 165|回复: 2

mysql 频繁停止

[复制链接]
发表于 2020-4-12 08:50:05 | 显示全部楼层 |阅读模式



本帖最后由 呆子 于 2020-4-12 08:51 编辑

服务器为do的双核2g
网站程序wp
nginx/1.9.9
lnmp版本为1.5
sql版本默认
php版本7.2.6
目前先临时使用的定时脚本 检查mysql状态



本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2020-4-12 12:45:25 | 显示全部楼层


InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
200412  5:55:43  InnoDB: Unable to open the first data file
InnoDB: Error in opening /usr/local/mysql/var/ibdata1
200412  5:55:43  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/ ... em-error-codes.html
200412  5:55:43 InnoDB: Could not open or create data files.
200412  5:55:43 InnoDB: If you tried to add new data files, and it failed here,
200412  5:55:43 InnoDB: you should now edit innodb_data_file_path in my.cnf back
200412  5:55:43 InnoDB: to what it was, and remove the new ibdata files InnoDB created
200412  5:55:43 InnoDB: in this failed attempt. InnoDB only wrote those files full of
200412  5:55:43 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
200412  5:55:43 InnoDB: remove old data files which contain your precious data!
200412  5:55:43 [ERROR] Plugin 'InnoDB' init function returned error.
200412  5:55:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
200412  5:55:43 [ERROR] Unknown/unsupported storage engine: InnoDB
200412  5:55:43 [ERROR] Aborting

按日志信息的话估计可能mysql已经启动或未被完整正确关闭,mysqld进程一直在占用,而无法启动
kill 进程pid再启动


频繁重启估计可能内存不够用了,你看一下系统日志
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2020-4-12 16:29:21 | 显示全部楼层



重启我是用脚本自动重启的   目前尝试建立了一个4g的SWAP  稳定了有6个多小时了  我在观察下   谢谢军哥
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2020-6-4 15:22 , Processed in 0.044634 second(s), 27 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表