“Mysql troubleshooting”的版本间的差异

来自linux中国网wiki
跳到导航 跳到搜索
第15行: 第15行:
 
[https://blog.csdn.net/mr_ooo/article/details/78653523  Mysql cannot allocate memory for the buffer pool 解决方法]
 
[https://blog.csdn.net/mr_ooo/article/details/78653523  Mysql cannot allocate memory for the buffer pool 解决方法]
  
 +
 +
[https://cyberpersons.com/2020/01/25/innodb-cannot-allocate-memory-for-the-buffer-pool-solved/ InnoDB: Cannot allocate memory for the buffer pool [Solved<nowiki>]</nowiki>]
 
[[category:mysql]]
 
[[category:mysql]]

2022年5月24日 (二) 07:14的版本

InnoDB: Cannot allocate memory for the buffer pool

一台机器 配置低下 4G ram 还上 各种 es mysql   ng  于是 mysql 老是重启  看log看到 Cannot allocate memory for the buffer pool

solved

[mysqld]

#skip-grant-tables

default-storage-engine=INNODB

#加这一行 变 docker 重启 mysql  
innodb-buffer-pool-size = 50M

Mysql cannot allocate memory for the buffer pool 解决方法


InnoDB: Cannot allocate memory for the buffer pool [Solved]