偶尔上一下自己的博客,发现最近总是出现mysql挂掉的现象,于是网上查了一下相关信息,查看mysql的错误日志,发现有
2019-11-13T09:37:10.347713Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-11-13T09:37:10.347721Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-11-13T09:37:10.347726Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-11-13T09:37:10.347763Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2019-11-13T09:37:10.347768Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2019-11-13T09:37:10.347772Z 0 [ERROR] Failed to initialize plugins.
2019-11-13T09:37:10.347775Z 0 [ERROR] Aborting
看样子像是内存不足造成的,修改一下my.cnf
将原来的innodb_buffer_pool_size = 512M 改为innodb_buffer_pool_size = 128M,再观察一下看看还会不会出现