VPS侦探论坛
标题:
mysql 连接失败的问题,请大佬帮忙看看
[打印本页]
作者:
bipeng0405
时间:
2019-4-27 16:20
标题:
mysql 连接失败的问题,请大佬帮忙看看
最近网站经常出现数据库连接失败的问题,日志如下:
190419 0:35:04 [Note] Plugin 'FEDERATED' is disabled.
190419 0:35:04 InnoDB: The InnoDB memory heap is disabled
190419 0:35:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190419 0:35:04 InnoDB: Compressed tables use zlib 1.2.7
190419 0:35:04 InnoDB: Using Linux native AIO
190419 0:35:04 InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: mmap(1098907648 bytes) failed; errno 12
190419 0:35:04 InnoDB: Completed initialization of buffer pool
190419 0:35:04 InnoDB: Fatal error: cannot allocate memory for the buffer pool
190419 0:35:04 [ERROR] Plugin 'InnoDB' init function returned error.
190419 0:35:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
190419 0:35:04 [ERROR] Unknown/unsupported storage engine: InnoDB
190419 0:35:04 [ERROR] Aborting
190419 0:35:04 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
190419 0:35:51 [Note] Plugin 'FEDERATED' is disabled.
190419 0:35:51 InnoDB: The InnoDB memory heap is disabled
190419 0:35:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190419 0:35:51 InnoDB: Compressed tables use zlib 1.2.7
190419 0:35:51 InnoDB: Using Linux native AIO
190419 0:35:51 InnoDB: Initializing buffer pool, size = 1.0G
190419 0:35:51 InnoDB: Completed initialization of buffer pool
190419 0:35:51 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!
190419 0:35:51 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...
InnoDB: Last MySQL binlog file position 0 19465650, file name ./mysql-bin.000030
190419 0:35:51 InnoDB: Waiting for the background threads to start
190419 0:35:52 InnoDB: 5.5.60 started; log sequence number 3215952
190419 0:35:52 [Note] Recovering after a crash using mysql-bin
190419 0:35:53 [Note] Starting crash recovery...
190419 0:35:53 [Note] Crash recovery finished.
190419 0:35:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
190419 0:35:53 [Note] - '0.0.0.0' resolves to '0.0.0.0';
190419 0:35:53 [Note] Server socket created on IP: '0.0.0.0'.
190419 0:35:54 [Note] Event Scheduler: Loaded 0 events
190419 0:35:54 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.60-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
复制代码
求老大帮忙看看是什么问题,谢谢
作者:
licess
时间:
2019-4-27 20:21
https://bbs.vpser.net/thread-17485-1-1.html
欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)
Powered by Discuz! X3.4