0529 DZ经常数据库崩溃

cclylycc

QQ截图20170528090035.jpg (85.03 KB, 下载次数: 0)

2017-5-28 09:02 上传

点击文件名下载附件

Vultr 512M JP，用的Kangle，内存是够的，但是问题没找到。

要每次service restart才能解决

QQ截图20170529134428.jpg (47.32 KB, 下载次数: 0)

2017-5-29 13:43 上传

点击文件名下载附件

太占CPU了啊，问题不知道出在哪里

献上部分日志：

Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 14:06:58 mysqld_safe Number of processes running now: 0
170527 14:06:58 mysqld_safe mysqld restarted
170527 14:06:58  InnoDB: Initializing buffer pool, size = 8.0M
170527 14:06:58  InnoDB: Completed initialization of buffer pool
170527 14:06:58  InnoDB: Started; log sequence number 0 46608
170527 14:06:58 [Note] Event Scheduler: Loaded 0 events
170527 14:06:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 14:36:12 mysqld_safe Number of processes running now: 0
170527 14:36:12 mysqld_safe mysqld restarted
170527 14:36:12  InnoDB: Initializing buffer pool, size = 8.0M
170527 14:36:12  InnoDB: Completed initialization of buffer pool
170527 14:36:12  InnoDB: Started; log sequence number 0 46608
170527 14:36:12 [Note] Event Scheduler: Loaded 0 events
170527 14:36:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 16:04:00 mysqld_safe Number of processes running now: 0
170527 16:04:00 mysqld_safe mysqld restarted
170527 16:04:00  InnoDB: Initializing buffer pool, size = 8.0M
170527 16:04:00  InnoDB: Completed initialization of buffer pool
170527 16:04:00  InnoDB: Started; log sequence number 0 46608
170527 16:04:00 [Note] Event Scheduler: Loaded 0 events
170527 16:04:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 16:19:57 mysqld_safe Number of processes running now: 0
170527 16:19:57 mysqld_safe mysqld restarted
170527 16:19:58  InnoDB: Initializing buffer pool, size = 8.0M
170527 16:19:58  InnoDB: Completed initialization of buffer pool
170527 16:19:58  InnoDB: Started; log sequence number 0 46608
170527 16:19:58 [Note] Event Scheduler: Loaded 0 events
170527 16:19:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 20:18:57 mysqld_safe Number of processes running now: 0
170527 20:18:58 mysqld_safe mysqld restarted
170527 20:18:58  InnoDB: Initializing buffer pool, size = 8.0M
170527 20:18:58  InnoDB: Completed initialization of buffer pool
170527 20:18:58  InnoDB: Started; log sequence number 0 46608
170527 20:19:05 [Note] Event Scheduler: Loaded 0 events
170527 20:19:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 20:19:07 mysqld_safe Number of processes running now: 0
170527 20:19:07 mysqld_safe mysqld restarted
170527 20:19:08  InnoDB: Initializing buffer pool, size = 8.0M
170527 20:19:08  InnoDB: Completed initialization of buffer pool
170527 20:19:08  InnoDB: Started; log sequence number 0 46608
170527 20:19:13 [Note] Event Scheduler: Loaded 0 events
170527 20:19:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170527 20:19:13 mysqld_safe Number of processes running now: 0
170527 20:19:13 mysqld_safe mysqld restarted
170527 20:19:14  InnoDB: Initializing buffer pool, size = 8.0M
170527 20:19:14  InnoDB: Completed initialization of buffer pool
170527 20:19:14  InnoDB: Started; log sequence number 0 46608
170527 20:19:19 mysqld_safe Number of processes running now: 0
170527 20:19:19 mysqld_safe mysqld restarted
170527 20:19:19  InnoDB: Initializing buffer pool, size = 8.0M
170527 20:19:19  InnoDB: Completed initialization of buffer pool
170527 20:19:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170528 00:59:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170528  0:59:07  InnoDB: Initializing buffer pool, size = 8.0M
170528  0:59:07  InnoDB: Completed initialization of buffer pool
170528  0:59:07  InnoDB: Started; log sequence number 0 46608
170528  0:59:07 [Note] Event Scheduler: Loaded 0 events
170528  0:59:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

砍柴郎

几千万数据？

cclylycc

砍柴郎 发表于 2017-5-28 09:10
几千万数据？

几千万数据我为什么还用512:lol

左手写爱

发帖启用下滑动验证码

maklove

Vultr512就算是正常的lnmp也会挂

cclylycc

maklove 发表于 2017-5-28 10:53
Vultr512就算是正常的lnmp也会挂

但是之前也没挂呀，难道Vultr有buff加成？

maklove

cclylycc 发表于 2017-5-28 11:11
但是之前也没挂呀，难道Vultr有buff加成？

反正我的啥也不放  过一段时间mysql就死了

yumijie

kangle问题?

cclylycc

yumijie 发表于 2017-5-28 12:42
kangle问题?

不会吧，kangle我也没改什么东西，都是默认的

cclylycc

求大神，刚刚又崩溃了一次