标题:
[求助]
mysql服务运行好好的无故会出现连接不上的问题
[打印本页]
作者:
yoer
时间:
2018-2-22 15:47
标题:
mysql服务运行好好的无故会出现连接不上的问题
180221 18:59:58 InnoDB: Waiting for the background threads to start
180221 18:59:59 InnoDB: 5.5.54 started; log sequence number 6827662
180221 18:59:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180221 18:59:59 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180221 18:59:59 [Note] Server socket created on IP: '0.0.0.0'.
180221 18:59:59 [Note] Event Scheduler: Loaded 0 events
180221 18:59:59 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
Version: '5.5.54' socket: '/tmp/mysql.sock' port: 3306 Source distribution
180222 3:27:38 [Note] Plugin 'FEDERATED' is disabled.
180222 3:27:38 InnoDB: The InnoDB memory heap is disabled
180222 3:27:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180222 3:27:38 InnoDB: Compressed tables use zlib 1.2.3
180222 3:27:38 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
180222 3:27:38 InnoDB: Completed initialization of buffer pool
180222 3:27:38 InnoDB: Fatal error: cannot allocate memory for the buffer pool
180222 3:27:38 [ERROR] Plugin 'InnoDB' init function returned error.
180222 3:27:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180222 3:27:38 [ERROR] Unknown/unsupported storage engine: InnoDB
180222 3:27:38 [ERROR] Aborting
180222 3:27:38 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: Shutdown complete
180222 15:09:14 [Note] Plugin 'FEDERATED' is disabled.
180222 15:09:14 InnoDB: The InnoDB memory heap is disabled
180222 15:09:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180222 15:09:14 InnoDB: Compressed tables use zlib 1.2.3
180222 15:09:14 InnoDB: Initializing buffer pool, size = 128.0M
180222 15:09:14 InnoDB: Completed initialization of buffer pool
180222 15:09:14 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
180222 15:09:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
180222 15:09:15 InnoDB: Waiting for the background threads to start
180222 15:09:16 InnoDB: 5.5.54 started; log sequence number 6827672
180222 15:09:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180222 15:09:16 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180222 15:09:16 [Note] Server socket created on IP: '0.0.0.0'.
180222 15:09:16 [Note] Event Scheduler: Loaded 0 events
180222 15:09:16 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
Version: '5.5.54' socket: '/tmp/mysql.sock' port: 3306 Source distribution
复制代码
摘取以上错误日志,昨晚7点重启后恢复,凌晨3点就出现错误了,下午15点重启后又恢复正常。经常出现这个问题,需要手动重启才行。看不懂日志,求大神帮助。
欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/)
Powered by Discuz! 7.2