MySQL crashes but Apache continues

Hello

I have recently moved one of my moderately active sites to a new Digital ocean droplet. Its wordpress with PHP and MySQL on a 1gb Droplet.

After a few hours of the system running, the MySQL server would stop responding. I restarted the system to get the MySQL database back up and running “sudo shutdown -r 0” and it would continue for a few more hours before crashing again.

First thing I tried was adding a 1gb swap file https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04 This did not resolve the issue and I continued to have the same issue.

I looked in the MySQL log file and found the following errors

131206 20:21:47 [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. 131206 20:21:47 [Note] Plugin ‘FEDERATED’ is disabled. 131206 20:21:47 InnoDB: The InnoDB memory heap is disabled 131206 20:21:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131206 20:21:47 InnoDB: Compressed tables use zlib 1.2.3.4 131206 20:21:47 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(135987200 bytes) failed; errno 12 131206 20:21:47 InnoDB: Completed initialization of buffer pool 131206 20:21:47 InnoDB: Fatal error: cannot allocate memory for the buffer pool 131206 20:21:47 [ERROR] Plugin ‘InnoDB’ init function returned error. 131206 20:21:47 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 131206 20:21:47 [ERROR] Unknown/unsupported storage engine: InnoDB 131206 20:21:47 [ERROR] Aborting 131206 20:21:47 [Note] /usr/sbin/mysqld: Shutdown complete

131206 20:21:48 [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. 131206 20:21:48 [Note] Plugin ‘FEDERATED’ is disabled. 131206 20:21:49 InnoDB: The InnoDB memory heap is disabled 131206 20:21:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131206 20:21:49 InnoDB: Compressed tables use zlib 1.2.3.4 131206 20:21:49 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(135987200 bytes) failed; errno 12 131206 20:21:49 InnoDB: Completed initialization of buffer pool 131206 20:21:49 InnoDB: Fatal error: cannot allocate memory for the buffer pool 131206 20:21:49 [ERROR] Plugin ‘InnoDB’ init function returned error. 131206 20:21:49 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 131206 20:21:49 [ERROR] Unknown/unsupported storage engine: InnoDB 131206 20:21:49 [ERROR] Aborting 131206 20:21:49 [Note] /usr/sbin/mysqld: Shutdown complete 131207 0:03:09 [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.

This line: " 131206 20:21:47 InnoDB: Fatal error: cannot allocate memory for the buffer pool " Makes it sound like I am currently running out of ram. So I am assuming that its a ram issue.

Next I installed sysstats at the suggestion of a friend, Its currently running every 10mins to hopefully tell me what is happening just before a crash.

I’m not sure what else to try at this point.

Any suggestions?