Aliyun MySQL Aborting

放了wordpress的主機最近經常掛掉,提示無法連結數據庫,檢查log信息發現是因為內存不足,把InnoDB的buffer pool size改小後似乎好了一些,可今天還是出錯了,log信息如下:

151210  6:45:23 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151210  6:45:23 [Note] Plugin 'FEDERATED' is disabled.
151210  6:45:23 InnoDB: The InnoDB memory heap is disabled
151210  6:45:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151210  6:45:23 InnoDB: Compressed tables use zlib 1.2.8
151210  6:45:23 InnoDB: Using Linux native AIO
151210  6:45:23 InnoDB: Initializing buffer pool, size = 96.0M
InnoDB: mmap(103022592 bytes) failed; errno 12
151210  6:45:23 InnoDB: Completed initialization of buffer pool
151210  6:45:23 InnoDB: Fatal error: cannot allocate memory for the buffer pool
151210  6:45:23 [ERROR] Plugin 'InnoDB' init function returned error.
151210  6:45:23 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151210  6:45:23 [ERROR] Unknown/unsupported storage engine: InnoDB
151210  6:45:23 [ERROR] Aborting

further search了一下,有建議說增加SWAP交換空間來解決。於是查看了本機swap空間情況,發現原來沒有...

好吧,那就增加一個SWAP空間試一段時間看看好了,(參考:Ubuntu修改swap交换空间)。

Y Cheung

Y Cheung

Blogger, Programer & Traveler.
Shanghai