letgod 发表于 2016-4-3 16:48:01

mysql经常自动停止,重启后正常

放假还打扰军哥真不好意思,最近两天mysql经常自动停止,重启后正常,日志发上来,麻烦军哥帮忙看看!!多谢了

licess 发表于 2016-4-3 18:20:41

160403 16:11:03 Event Scheduler: Purging the queue. 0 events
160403 16:11:03 /usr/local/mysql/bin/mysqld: Sort aborted: Query execution was interrupted
160403 16:11:03 /usr/local/mysql/bin/mysqld: Sort aborted: Query execution was interrupted
160403 16:11:03 /usr/local/mysql/bin/mysqld: Sort aborted: Query execution was interrupted
160403 16:11:05 /usr/local/mysql/bin/mysqld: Shutdown complete

你服务器什么配置?
可以在/etc/my.cnf
里加上log_warnings=2 看看有什么具体的信息

letgod 发表于 2016-4-3 19:26:00

回复 2# 的帖子

阿里云的两核2G,已经在my.cnf加入了,请问多久再提交日志呢!
页: [1]
查看完整版本: mysql经常自动停止,重启后正常