mysql老是自动重启

错误日志

Version: '5.6.35-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2017-05-23 00:28:05 29281 [Note] Plugin 'FEDERATED' is disabled.
2017-05-23 00:28:05 29281 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-05-23 00:28:05 29281 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-23 00:28:05 29281 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-23 00:28:05 29281 [Note] InnoDB: Memory barrier is not used
2017-05-23 00:28:05 29281 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-23 00:28:05 29281 [Note] InnoDB: Using Linux native AIO
2017-05-23 00:28:05 29281 [Note] InnoDB: Not using CPU crc32 instructions
2017-05-23 00:28:05 29281 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2017-05-23 00:28:05 29281 [Note] InnoDB: Completed initialization of buffer pool
2017-05-23 00:28:05 29281 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-23 00:28:05 29281 [Note] InnoDB: The log sequence numbers 13528120 and 13528120 in ibdata files do not match the log sequence number 13528608 in the ib_logfiles!
2017-05-23 00:28:05 29281 [Note] InnoDB: Database was not shutdown normally!
2017-05-23 00:28:05 29281 [Note] InnoDB: Starting crash recovery.
2017-05-23 00:28:05 29281 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-05-23 00:28:05 29281 [Note] InnoDB: Restoring possible half-written data pages
2017-05-23 00:28:05 29281 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 826, file name mysql-bin.008779
2017-05-23 00:28:05 29281 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-23 00:28:05 29281 [Note] InnoDB: Waiting for purge to start
2017-05-23 00:28:05 29281 [Note] InnoDB: 5.6.35 started; log sequence number 13528608
2017-05-23 00:28:05 29281 [Note] Recovering after a crash using mysql-bin
2017-05-23 00:28:05 29281 [Note] Starting crash recovery...
2017-05-23 00:28:05 29281 [Note] Crash recovery finished.
2017-05-23 00:28:06 29281 [Note] Server hostname (bind-address): '*'; port: 3306
2017-05-23 00:28:06 29281 [Note] IPv6 is available.
2017-05-23 00:28:06 29281 [Note] - '::' resolves to '::';
2017-05-23 00:28:06 29281 [Note] Server socket created on IP: '::'.
2017-05-23 00:28:06 29281 [Note] Event Scheduler: Loaded 0 events
2017-05-23 00:28:06 29281 [Note] /www/server/mysql/bin/mysqld: ready for connections.

复制代码

xiaoben@007 · 发表于 2017-5-23 14:44:00

你这日志不完整，不够全面，看不出重点~~~~

河妖 · 发表于 2017-5-23 15:56:25

看不出来啥东西你可以先参照这贴进行优化
https://www.bt.cn/bbs/forum.php?mod=viewthread&tid=3117

█ 菠萝云-免费装宝塔,4G内存68 █	█ 易探云·香港/美国vps仅9元 █	A3招租，联系qq394030111	A4招租，联系qq394030111	【多途云】高防CDN
高防服务器，无视一切流量攻击	+++美国百G防护500M带宽29元+++	OV/EV SSL证书，可当日签发	【阿里云】宝塔一键部署，5.5折	宝塔一键部署DV,EV,OV,SSL证书
█ 易探云·高防云4核8G仅88元 █	===真高防===CDN99元起\|全球节点	香港日本美国弹性云19.9	【阿里云】2核2G，3M，45.1元/年	在线网站测速、批量PING运维工具