启动mysql 无法申请内存错误 Fatal error: cannot allocate memory for the buffer pool

最新推荐文章于 2022-08-25 14:48:35 发布
原创 最新推荐文章于 2022-08-25 14:48:35 发布 · 1.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了一种解决Linux系统中因内存不足导致的fatal error问题的方法。通过检查当前系统的内存使用情况，利用命令创建额外的交换空间（SWAP），从而缓解内存压力。适用于遇到类似问题的开发者。
Fatal error: cannot allocate memory for the buffer pool

free查看内存，若是swap无剩余
$ sudo dd if=/dev/zero of=/swapfile bs=1M count=1024 #增加1G的SWAP进去
$ sudo mkswap /swapfile
$ sudo swapon /swapfile
$ free

查看swap是否有剩余

             total       used       free     shared    buffers     cached
Mem:        608476     601432       7044          0        824      88752
-/+ buffers/cache:     511856      96620
Swap:      1048572          0    1048572

再重新启动
InnoDB: Cannot allocate memory for the buffer pool
LDC，公众号【轻松学编程】
04-20 756
Ubuntu下MySQL启动失败 Failed to start MySQL Community Server mysql.service: Start request repeated too quickly Can't connect to MySQL server on '127.0.0.1' (111) InnoDB: Cannot allocate memory for the buffer pool See "systemctl status mysql.service" and "journa
mysql 内存不足引发的坑
QQ648472886的博客
12-30 5991
问题： [root@iZuzc9f4ma6h2iZ ~]# service mysqld restart MySQL server PID file could not be found! [FAILED] Starting MySQL.Logging to '/var/log/mysql/error.log'. The server quit without
Fatal error: cannot allocate memory for the buffer pool
weixin_30567225的博客
05-21 207
mysql有时候会被系统kill掉，原因是内存不够了，一般都是Ubuntu出现的，因为Ubuntu吃内存，你们又给的不多。。 咋解决呢？ 重启服务器是可以的，起码暂时可以了， 可以考虑加内存，或者增加swap。 如果给Ubuntu增加swap请见下文： 转载自：https://www.digitalocean.com/community/articles/how-to-add-swap-...
安装mysql 报Fatal error: cannot allocate memory for the buffer pool
07-10 228
120710 11:01:38 InnoDB: Initializing buffer pool, size = 8.0GInnoDB: mmap(8791261184 bytes) failed; errno 12120710 11:01:38 InnoDB: Completed initialization of buffer pool120710 11:01:38 InnoDB...
Java中Runtime.getRuntime().exec()错误：Cannot allocate memory!
爱.NET
03-07 678
用java的Runtime.getRuntime().exec(cmd)方式，执行aapt命令行解包apk文件时，遇到“Cannot allocate memory”的错误。 但是直接在linux上使用aapt命令可以正常使用。 网上查询资料整理如下： Cannot allocate memory 在Linux上调试一个比较复杂的Java程序，称为JavaA吧，JavaA会频繁...
Fatal error: cannot allocate the memory for the buffer pool
weixin_30859423的博客
03-01 242
100602 14:23:17 mysqld started100602 14:23:17 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.100602 14:23:17 In...
MySQL启动时报 无法申请内存错误解决方式 Fatal error: cannot allocate memory for the buffer pool
JayphaCMS
10-08 405
国庆前配置的MySQL服务器,今天重启,MySQL就启动不了,开始以为是MySQL 的PID文件没有权限,折腾了一下,还是没启动成功,于是度娘了一下,发现很多介绍的都是说my.cnf中的innodb_buffer_pool_size参数设置太小,然后我就修改这个参数值,再重试,依然没有启动成功,没办法,接着度娘,然而还是没有什么鸟用,千篇一律的都是介绍说innodb_buffer_pool_siz...
root@ecm-e00f:/# sudo journalctl -u mariadb -xe # 检查启动错误 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initializing buffer pool, total> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initialized memory pressure eve> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Completed initialization of buf> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File system buffers for log dis> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: End of log at LSN=46996 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: 128 rollback segments are activ> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Setting file './ibtmp1' size to> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: log sequence number 46996; tran> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Loading buffer pool(s) from /yu> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '0.0.0.0'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '::'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Buffer pool(s) load completed a> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] /usr/sbin/mariadbd: ready for connectio> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: Version: '10.11.11-MariaDB-0+deb12u1' socket: '/run/mysqld/mysqld.s> Jun 25 16:43:09 ecm-e00f systemd[1]: Started mariadb.service - MariaDB 10.11.11 database server. ░░ Subject: A start job for unit mariadb.service has finished successfully ░░ Defined-By: systemd ░░ Support: https://www.debian.org/support ░░ ░░ A start job for unit mariadb.service has finished successfully. ░░ ░░ The job identifier is 57427. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336825]: Checking for insecure root accounts. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336829]: Triggering myisam-recover for all MyISAM tables and a> lines 960-985/985 (END) Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initialized memory pressure event listener Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Completed initialization of buffer pool Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: End of log at LSN=46996 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: 128 rollback segments are active. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: log sequence number 46996; transaction id 14 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Loading buffer pool(s) from /yunxiang/data/mysql/ib_buffer_pool Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '0.0.0.0'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '::'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Buffer pool(s) load completed at 250625 16:43:09 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] /usr/sbin/mariadbd: ready for connections. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: Version: '10.11.11-MariaDB-0+deb12u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 12 Jun 25 16:43:09 ecm-e00f systemd[1]: Started mariadb.service - MariaDB 10.11.11 database server. ░░ Subject: A start job for unit mariadb.service has finished successfully ░░ Defined-By: systemd ░░ Support: https://www.debian.org/support ░░ ░░ A start job for unit mariadb.service has finished successfully. ░░ ░░ The job identifier is 57427. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336825]: Checking for insecure root accounts. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336829]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables ~
最新发布
06-26
- `Cannot allocate memory` → 内存不足 - `Table 'mysql.plugin' doesn't exist` → 系统表损坏[^4] --- #### 2. **常见错误场景及解决方案** | 错误类型 | 日志特征 | 修复方案 | |---------|----------|---...
记一次mariadb数据库无法连接
09-10
错误日志中的"Fatal error: cannot allocate memory for the buffer pool"明确指出，内存不足是导致InnoDB无法初始化的原因。 InnoDB的缓冲池（buffer pool）是用来缓存数据和索引的内存区域，以提高数据库性能。...
交叉编译Mysql-server5.5.62版本并运行
qinbo1234567890的博客
08-08 900
Mysql5.5 版本的交叉编译
mysql启动报错【InnoDB: Cannot allocate memory for the buffer pool】
wsaicyj的博客
12-05 1756
mysql突然连接失败，重启后也报报错，然后去/var/log/mysql/查看error.log，报错信息如下： InnoDB: mmap(137363456 bytes) failed; errno 12 2018-12-05 10:24:23 721 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2018-12-05...
Cannot allocate memory for the buffer pool
有一种人仅仅是认识就很好了的博客
03-17 5583
Cannot allocate memory for the buffer pool翻译过来就是：无法为缓冲池分配内存。简单解释就是没法为mysql的buffer pool分配128M的内存。进入 vi /etc/my.cnf 修改 InnoDB缓冲池大小my.cnf 的innodb_buffer_pool_size 参数默认是注释的。开启并修改内存大小即可。...
syslog 向内存中缓存,mysql致命错误：无法为缓冲池分配内存
weixin_34246826的博客
12-24 378
I have this error log from MySQL, any idea?Website works for some time and then I get MySQL shutdown completely after a couple of hours.140919 10:48:27 [Warning] Using unique option prefix myisam-reco...
mysql启动报错cannot allocate memory for the buffer pool处理
热门推荐
afa007的专栏
01-23 1万+
今天启动mysql服务器时失败了。去/var/log/mysql/查看error.log，报错信息如下： 160123 22:29:26 InnoDB: Initializing buffer pool, size = 200.0M InnoDB: mmap(214630400 bytes) failed; errno 12 160123 22:29:26 InnoDB: Completed
mysql child process_mysql致命错误：无法为缓冲区p分配内存
weixin_39962341的博客
01-27 344
TLDRMysql无法重新启动，因为内存不足，请检查是否配置了适当的交换文件。帮不上忙？如果这不是你的问题，更适合继续研究的问题是：背景我在EC2上建立的第一个系统就遇到了这个问题，其特点是托管在那里的wordpress站点有时会出现“建立数据库连接时出错”的情况。日志显示的错误与OP发布的相同。我读取的错误(删除时间戳)是：内存不足错误：InnoDB: Fatal error: cannot a...
执行Runtime.exec异常: error=12,Cannot allocate memory
qsh123
03-12 242
转：http://blog.youkuaiyun.com/chifengxin/article/details/6573134 In the Linux circumstance, when the program executes till this place:Process p = Runtime.getRuntime().exec(cmdArr); it throws an exception...
Mysql cannot allocate memory for the buffer pool 解决方法（亲测有效！）
qq_61367293的博客
08-25 1810
mysql重启不了
Mysql cannot allocate memory for the buffer pool 解决方法
Mr_OOO的博客
11-28 8314
问题出现原因 解决方法 进一步优化 参考文档问题出现原因昨晚我修改了数据库，为字段添加了”FULLTEXT”索引，结果今天早上发现数据库连不上了，也没法重启，于是查看日志文件：cat /var/log/mysqld.log发现如下错误日志：130728 6:50:14 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(1373
java runtime shell,Java执行Runtime.exec(shell)报Cannot allocate memory
weixin_42516007的博客
03-20 461
在Linux下用java的Runtime.getRuntime().exec(cmd)方式，执行shell脚本时，遇到“Cannot allocate memory”的错误。网上查询资料整理如下：Cannot allocate memory在Linux上调试一个比较复杂的Java程序，称为JavaA吧，JavaA会频繁的通过Process proc = Runtime.getRuntime().e...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值