MySQL crash randomly every few days.
Previously it has similar problem, but after I enabled the SWAP file, it actually solve the problem. But recently the similar error came out again and the Mysql crash randomly every few days. Error message as below: 131102 5:59:34 [Note] Plugin 'FEDERATED' is disabled. 131102 5:59:34 InnoDB: The InnoDB memory heap is disabled 131102 5:59:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131102 5:59:34 InnoDB: Compressed tables use zlib 1.2.7 131102 5:59:34 InnoDB: Using Linux native AIO 131102 5:59:34 InnoDB: Initializing buffer pool, size = 1.0G InnoDB: mmap(1098907648 bytes) failed; errno 12 131102 5:59:34 InnoDB: Completed initialization of buffer pool 131102 5:59:34 InnoDB: Fatal error: cannot allocate memory for the buffer pool 131102 5:59:34 [ERROR] Plugin 'InnoDB' init function returned error. 131102 5:59:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 131102 5:59:34 [ERROR] Unknown/unsupported storage engine: InnoDB 131102 5:59:34 [ERROR] Aborting 131102 5:59:34 [Note] /usr/sbin/mysqld: Shutdown complete My Droplet is 1GB ram with 2GB swap on. Should I enlarge the swap file? Any help will be greatly appreciate. Thanks.