mysql启动报InnoDB: mmap(xxxxxx bytes) failed; errno 12错误

发表于由

报错如下:

2021-06-16T18:08:56.257967+08:00 0 [ERROR] InnoDB: mmap(68714496 bytes) failed; errno 12
2021-06-16T18:08:56.257974+08:00 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-06-16T18:08:56.257983+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-16T18:08:56.257999+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-16T18:08:56.258004+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-16T18:08:56.258010+08:00 0 [ERROR] Failed to initialize builtin plugins.
2021-06-16T18:08:56.258013+08:00 0 [ERROR] Aborting

增加swap空间

$ sudo dd if=/dev/zero of=/swapfile bs=1M count=1024 #增加1G的SWAP进去
$ sudo mkswap /swapfile
$ sudo swapon /swapfile
$ free

修改/etc/my.cnf

innodb_buffer_pool_size=8MB