› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
Artoria
V2EX  ›  MySQL

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

  •  
  •   Artoria · Apr 18, 2016 · 7684 views
    This topic created in 3861 days ago, the information mentioned may be changed or developed.
    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

    好像没什么问题?
    10 replies  •  2016-08-03 17:05:01 +08:00
    huigeer
    huigeer
    Apr 18, 2016
    1
    内存够么, 是不是 oom 被系统 kill 了?
    Artoria
    Artoria
    OP
    Apr 18, 2016
    2
    @huigeer 内存是够的。 不论是 cpu 还是内存占用都非常小。但从上面的时间过后每隔 3 天就会挂掉。毫无头绪
    holyghost
    holyghost
    Apr 18, 2016
    3
    上 supervisor ,看看是不是收到什么莫名其妙的信号了。
    caixiexin
    caixiexin
    Apr 18, 2016 via Android
    4
    机器的内存多少,小于 512 内存机器跑 innodb 引擎的话可能会有问题
    Artoria
    Artoria
    OP
    Apr 18, 2016
    5
    @caixiexin 2G 内存呀
    billlee
    billlee
    Apr 18, 2016
    6
    先开 coredump 看看吧
    alect
    alect
    Apr 18, 2016
    7
    以目前的经验来看,绝大数原因是因为内存不够用。。。
    (曾经多次在小内存 VPS 上因为内存小编译 mysql 失败的路过
    lovedboy
    lovedboy
    Apr 19, 2016
    8
    感觉是 oom
    huigeer
    huigeer
    Apr 20, 2016
    9
    看一下 mysql 的 error log 或者系统的 log
    alsotang
    alsotang
    Aug 3, 2016
    10
    less /var/log/messages

    看看是不是 oom
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2100 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 43ms · UTC 06:50 · PVG 14:50 · LAX 22:50 · JFK 01:50
    ♥ Do have faith in what you're doing.