☰

InnoDB：mmap（68878336 字节）失败；errno 12

tag-icon • tag-icon centos mysql innodb centos7 mariadb
InnoDB：mmap（68878336 字节）失败；errno 12

屏幕截图解释了一切，首先我尝试启动它，但它无法启动，所以我检查状态，然后检查日志。

错误 在此处输入图片描述 在此处输入图片描述

在遵循了我之前在 StackExchange 上提出的许多建议之后，my.cnf 的内容如下：

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
performance_schema=off
innodb_buffer_pool_size=64MB
innodb_purge_threads=0

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

答案1

使用较小的值来更改您的配置文件innodb_buffer_pool_size。

例如，使用innodb_buffer_pool_size = 8M

答案2

这篇文章可能会对你有所帮助。基本上，你的内存不足。尝试降低 max_connection 变量和其他参数。

https://dba.stackexchange.com/questions/1927/why-does-mysql-say-im-out-of-memory

相关内容