“Mysql troubleshooting”的版本间的差异
跳到导航
跳到搜索
（→solved） |
（→solved） |
||
| （未显示同一用户的1个中间版本） | |||
| 第1行： | 第1行： | ||
= InnoDB: Cannot allocate memory for the buffer pool= | = InnoDB: Cannot allocate memory for the buffer pool= | ||
一台机器 配置低下 4G ram 还上 各种 es mysql ng 于是 mysql 老是重启 看log看到 Cannot allocate memory for the buffer pool | 一台机器 配置低下 4G ram 还上 各种 es mysql ng 于是 mysql 老是重启 看log看到 Cannot allocate memory for the buffer pool | ||
| − | == | + | == Solution== |
<pre> | <pre> | ||
[mysqld] | [mysqld] | ||
| 第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
Solution
[mysqld] #skip-grant-tables default-storage-engine=INNODB #加这一行 变 docker 重启 mysql innodb-buffer-pool-size = 50M
