mysql自动关闭,日志看不懂,希望大神解读下

 郑小蒜9299_941611_G 发布于 2022-11-01 07:46

Version: '5.5.48' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160515 14:15:17 mysqld_safe Number of processes running now: 0
160515 14:15:17 mysqld_safe mysqld restarted
160515 14:15:17 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160515 14:15:17 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160515 14:15:17 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 23912 ...
160515 14:15:18 [Note] Plugin 'FEDERATED' is disabled.
160515 14:15:18 InnoDB: The InnoDB memory heap is disabled
160515 14:15:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160515 14:15:18 InnoDB: Compressed tables use zlib 1.2.7
160515 14:15:18 InnoDB: Initializing buffer pool, size = 128.0M
160515 14:15:18 InnoDB: Completed initialization of buffer pool
160515 14:15:18 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!
160515 14:15:18 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...
160515 14:15:18 InnoDB: Waiting for the background threads to start
160515 14:15:19 InnoDB: 5.5.48 started; log sequence number 1667632
160515 14:15:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160515 14:15:19 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160515 14:15:19 [Note] Server socket created on IP: '0.0.0.0'.
160515 14:15:19 [Note] Event Scheduler: Loaded 0 events
160515 14:15:19 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld: ready for connections.
Version: '5.5.48' socket: '/tmp/mysql.sock' port: 3306 Source distribution
160515 14:35:28 mysqld_safe Number of processes running now: 0
160515 14:35:28 mysqld_safe mysqld restarted
160515 14:35:29 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160515 14:35:29 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160515 14:35:29 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 24389 ...
160515 14:35:29 [Note] Plugin 'FEDERATED' is disabled.
160515 14:35:29 InnoDB: The InnoDB memory heap is disabled
160515 14:35:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160515 14:35:29 InnoDB: Compressed tables use zlib 1.2.7
160515 14:35:29 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
160515 14:35:29 InnoDB: Completed initialization of buffer pool
160515 14:35:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160515 14:35:29 [ERROR] Plugin 'InnoDB' init function returned error.
160515 14:35:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160515 14:35:29 [ERROR] Unknown/unsupported storage engine: InnoDB
160515 14:35:29 [ERROR] Aborting

160515 14:35:29 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld: Shutdown complete

160515 14:35:29 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.48/data/iZ236zu4tgyZ.pid ended
160515 14:58:19 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.48/data
160515 14:58:19 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160515 14:58:19 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160515 14:58:19 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 25030 ...
160515 14:58:19 [Note] Plugin 'FEDERATED' is disabled.
160515 14:58:19 InnoDB: The InnoDB memory heap is disabled
160515 14:58:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160515 14:58:19 InnoDB: Compressed tables use zlib 1.2.7
160515 14:58:19 InnoDB: Initializing buffer pool, size = 128.0M
160515 14:58:19 InnoDB: Completed initialization of buffer pool
160515 14:58:19 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!
160515 14:58:19 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...
160515 14:58:19 InnoDB: Waiting for the background threads to start
160515 14:58:20 InnoDB: 5.5.48 started; log sequence number 1667642
160515 14:58:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160515 14:58:20 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160515 14:58:20 [Note] Server socket created on IP: '0.0.0.0'.
160515 14:58:20 [Note] Event Scheduler: Loaded 0 events
160515 14:58:20 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld: ready for connections.
Version: '5.5.48' socket: '/tmp/mysql.sock' port: 3306 Source distribution

上面的关闭这段时间的错误日志内容,大概是怎么一回事额

1 个回答
  • 160515 14:35:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool

    看这个是机器内存太小,innodb的的buffer pool分配内存失败

    2022-11-01 18:54 回答
撰写答案
今天,你开发时遇到什么问题呢?
立即提问
热门标签
PHP1.CN | 中国最专业的PHP中文社区 | PNG素材下载 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有