mysql 启动内存_启动mysql时内存不足引发的问题处理

最新推荐文章于 2024-07-30 02:09:15 发布

名门十三少

最新推荐文章于 2024-07-30 02:09:15 发布

阅读量397

点赞数

文章标签： mysql 启动内存

本文链接：https://blog.csdn.net/weixin_36332320/article/details/113912812

版权

报错信息如下：

Out of memory error: InnoDB: Fatal error: cannot allocate memory for the buffer pool

InnoDB can't start without enough memory [ERROR] Plugin 'InnoDB' init function returned error.[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.[ERROR] Unknown/unsupported storage engine: InnoDB[ERROR] Aborting

mysqld is shutting down, which in this context, really means failing to restart! [Note] /usr/sbin/mysqld: Shutdown complete

free -m 看下内存

官网说的启动mysql时的内存：512 M

MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by increasing the values of certain cache and buffer-related system variables. You can also modify the default configuration to run MySQL on systems with limited memory.

无法添加内存的情况下，那么使用如下方法：

vim /etc/my.cnf

添加：

performance_schema_max_table_instances=200

table_definition_cache=200

table_open_cache=128