Mysql troubleshooting

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

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

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