mysql 莫名其妙的会自动停止。

[Artoria]

Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160313 07:13:20 mysqld_safe Number of processes running now: 0
160313 07:13:20 mysqld_safe mysqld restarted
160313 7:13:25 [Note] Event Scheduler: Loaded 0 events
160313 7:13:25 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.
Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160313 07:13:41 mysqld_safe Number of processes running now: 0
160313 07:13:42 mysqld_safe mysqld restarted
160313 7:13:42 [Note] Event Scheduler: Loaded 0 events
160313 7:13:42 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.
Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160313 13:27:45 mysqld_safe Number of processes running now: 0
160313 13:27:46 mysqld_safe mysqld restarted
160313 13:27:49 [Note] Event Scheduler: Loaded 0 events
160313 13:27:49 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.
Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160313 13:28:02 mysqld_safe Number of processes running now: 0
160313 13:28:02 mysqld_safe mysqld restarted
160313 13:28:04 [Note] Event Scheduler: Loaded 0 events
160313 13:28:04 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.
Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160314 01:26:50 mysqld_safe Number of processes running now: 0
160314 01:26:51 mysqld_safe mysqld restarted
160314 1:27:00 [Note] Event Scheduler: Loaded 0 events
160314 1:27:00 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.
Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160314 01:27:10 mysqld_safe Number of processes running now: 0
160314 01:27:12 mysqld_safe mysqld restarted

上面的是停止的那几天的 err

好像没什么问题？

[huigeer]

内存够么， 是不是 oom 被系统 kill 了？

[Artoria]

@huigeer 内存是够的。 不论是 cpu 还是内存占用都非常小。但从上面的时间过后每隔 3 天就会挂掉。毫无头绪

[holyghost]

上 supervisor ，看看是不是收到什么莫名其妙的信号了。

[caixiexin]

机器的内存多少，小于 512 内存机器跑 innodb 引擎的话可能会有问题

[Artoria]

@caixiexin 2G 内存呀

[billlee]

先开 coredump 看看吧

[alect]

以目前的经验来看，绝大数原因是因为内存不够用。。。
（曾经多次在小内存 VPS 上因为内存小编译 mysql 失败的路过

[lovedboy]

感觉是 oom

[huigeer]

看一下 mysql 的 error log 或者系统的 log

[alsotang]

less /var/log/messages

看看是不是 oom