MySQL database crashes, unable to start

View MySQL Error tips

170329  ,: -: atMysqld_safe number of processes running now:0170329  ,: -: atMysqld_safe mysqld restarted170329  8: -: at[Note]/usr/local/mysql/bin/mysqld (mysqld5.5. --log) starting asProcess4353 ...170329  8: -: at[Note] Plugin'Federated'  isdisabled.170329  8: -: atInnodb:the InnoDB Memory Heap isDisabled170329  8: -: atinnodb:mutexes and Rw_locks use GCC atomic builtins170329  8: -: atinnodb:compressed Tables Use Zlib1.2.3170329  8: -: atInnodb:initializing buffer pool, size =4. 0ginnodb:mmap (4395630592bytes) failed; Errno A170329  8: -: atinnodb:completed initialization of buffer pool170329  8: -: atInnodb:fatal Error:cannot Allocate Memory forThe buffer pool170329  8: -: at[ERROR] Plugin'InnoDB'init function returned error.170329  8: -: at[ERROR] Plugin'InnoDB'Registration asa STORAGE ENGINE failed.170329  8: -: at[ERROR] unknown/Unsupported Storage Engine:innodb170329  8: -: at[ERROR] aborting170329  8: -: at[Note]/usr/local/mysql/bin/Mysqld:shutdown Complete170329  ,: -: atMysqld_safe mysqld fromPID file/usr/local/mysql/var/104- --159- the.Static. Gorillaservers.com.pid Ended

Workaround: Set the Innodb_buffer_pool_size value to a small point in the my.cnf.

Reference:

Http://serverfault.com/questions/379714/unknown-unsupported-storage-engine-innodb-mysql-ubuntu

http://blog.csdn.net/psiitoy/article/details/40106735

MySQL database crashes, unable to start