Mysql数据库突然自动停止，手动启动不了

本帖最后由 cnnewin 于 2018-5-7 11:51 编辑

使用一键修复工具https://www.bt.cn/bbs/forum.php?mod=viewthread&tid=6109&extra=
错误如下，请大侠给分析一下什么原因。

MySQL server PID file could not be found! [FAILED]
Starting MySQL..The server quit without updating PID file (/www/server/data/iZrj 9g2k1kdk93tq0ayxgiZ.pid). [FAILED]
================================================================================ ==========
2018-01-15T04:00:19.462030Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-01-15T04:00:22.940413Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-01-15T04:00:31.330586Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-05-02T20:01:37.572217Z 266049 [ERROR] Disk is full writing './mysql-bin.000 166' (Errcode: 15935712 - No space left on device). Waiting for someone to free space...
2018-05-02T20:01:37.572418Z 266049 [ERROR] Retry in 60 secs. Message reprinted i n 600 secs
================================================================================ ==========
mysql start error.

复制代码

谢谢

cnnewin · 发表于 2018-5-7 11:52:03

问题解决了，是磁盘满了，