bipeng0405 发表于 2019-4-27 16:20:18

mysql 连接失败的问题,请大佬帮忙看看

最近网站经常出现数据库连接失败的问题,日志如下:1904190:35:04 Plugin 'FEDERATED' is disabled.
1904190:35:04 InnoDB: The InnoDB memory heap is disabled
1904190:35:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1904190:35:04 InnoDB: Compressed tables use zlib 1.2.7
1904190:35:04 InnoDB: Using Linux native AIO
1904190:35:04 InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: mmap(1098907648 bytes) failed; errno 12
1904190:35:04 InnoDB: Completed initialization of buffer pool
1904190:35:04 InnoDB: Fatal error: cannot allocate memory for the buffer pool
1904190:35:04 Plugin 'InnoDB' init function returned error.
1904190:35:04 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
1904190:35:04 Unknown/unsupported storage engine: InnoDB
1904190:35:04 Aborting

1904190:35:04 /usr/local/mysql/bin/mysqld: Shutdown complete

1904190:35:51 Plugin 'FEDERATED' is disabled.
1904190:35:51 InnoDB: The InnoDB memory heap is disabled
1904190:35:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1904190:35:51 InnoDB: Compressed tables use zlib 1.2.7
1904190:35:51 InnoDB: Using Linux native AIO
1904190:35:51 InnoDB: Initializing buffer pool, size = 1.0G
1904190:35:51 InnoDB: Completed initialization of buffer pool
1904190: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!
1904190:35:51InnoDB: 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
1904190:35:51InnoDB: Waiting for the background threads to start
1904190:35:52 InnoDB: 5.5.60 started; log sequence number 3215952
1904190:35:52 Recovering after a crash using mysql-bin
1904190:35:53 Starting crash recovery...
1904190:35:53 Crash recovery finished.
1904190:35:53 Server hostname (bind-address): '0.0.0.0'; port: 3306
1904190:35:53    - '0.0.0.0' resolves to '0.0.0.0';
1904190:35:53 Server socket created on IP: '0.0.0.0'.
1904190:35:54 Event Scheduler: Loaded 0 events
1904190:35:54 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution求老大帮忙看看是什么问题,谢谢

licess 发表于 2019-4-27 20:21:23

https://bbs.vpser.net/thread-17485-1-1.html
页: [1]
查看完整版本: mysql 连接失败的问题,请大佬帮忙看看