MySQL error every morning at 3am


#1

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.


#2
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  

#3
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


#4

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. :slight_smile:


#5