Mysql启动失败
报错如下
MySQL ERROR! The server quit without updating PID file
启动日志提示如下:
2020-09-08T08:45:53.168440Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2020-09-08T08:45:53.168450Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-09-08T08:45:53.168455Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-09-08T08:45:53.168474Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-09-08T08:45:53.168478Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-09-08T08:45:53.168483Z 0 [ERROR] Failed to initialize builtin plugins.
2020-09-08T08:45:53.168488Z 0 [ERROR] Aborting
原因:内存不足,innodb启动有内存要求,不满则无法启动。
处理:在主配置文件中添加innodb程序运行的内存配额。
innodb_buffer_pool_size = 50M