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

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