关于Linux服务器不足引发的mysql宕机
2018-04-27 本文已影响0人
全汪汪
日志打印:(var/log/mysql.log)
[ERROR] InnoDB: Cannot allocate memory for the buffer pool
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
问题:由于服务器内存不足引发的错误。本人使用腾讯云1G,可用内存400M
解决方法:
在etc/my.cnf配置文件配置
performance_schema_max_table_instances=200
table_definition_cache=200
table_open_cache=128
文章链接:https://blog.csdn.net/qq648472886/article/details/78936040