My server reporting program has been telling my site is down at 325am every morning the last 2 days. It results in my wordpress page displaying the error “Unable to establish a database connection.”
Just wondering if theres a way to provide more RAM to mysql so this doesnt happen again or install something to auto restart this when this happens. Please advise.
140515 3:21:20 [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.
140515 3:21:20 [Note] Plugin 'FEDERATED' is disabled.
140515 3:21:20 InnoDB: The InnoDB memory heap is disabled
140515 3:21:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140515 3:21:20 InnoDB: Compressed tables use zlib 1.2.8
140515 3:21:20 InnoDB: Using Linux native AIO
140515 3:21:20 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140515 3:21:20 InnoDB: Completed initialization of buffer pool
140515 3:21:20 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140515 3:21:20 [ERROR] Plugin 'InnoDB' init function returned error.
140515 3:21:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140515 3:21:20 [ERROR] Unknown/unsupported storage engine: InnoDB
140515 3:21:20 [ERROR] Aborting
140515 3:21:20 [Note] /usr/sbin/mysqld: Shutdown complete
InnoDB: Fatal error: cannot allocate memory for the buffer pool
Its seems like your buffer pool size is not enough
Please cross check server whats process running at 3AM
This issue is duplicate https://rtcamp.com/support/topic/mysql-shutting-down/
Please comment on above issue its easy for us to reply and fix the same issue
Hi @matthewlevy,
I hope your query is resolved. I am closing this support ticket for now.
Feel free to create a new support ticket if you have any queries further. 