nico bistol.fi

Published on

Mysql crash problems on EC2 AWS micro instance

Authors

If you have the default mysql config probably you'll have some crash problems after a while running the instance.

I'm running a micro instance, with Ubuntu 12.04 and default mysql installation.

I've this logs reports:

\[Note\] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw\_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.7
InnoDB: Using Linux native AIO
InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
InnoDB: Completed initialization of buffer pool
InnoDB: Fatal error: cannot allocate memory for the buffer pool
\[ERROR\] Plugin 'InnoDB' init function returned error.
\[ERROR\] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
\[ERROR\] Unknown/unsupported storage engine: InnoDB
\[ERROR\] Aborting

\[Note\] /usr/sbin/mysqld: Shutdown complete

To solve it you need to add some lines on the /etc/mysql/my.cnf file after the [mysql] line:

innodb\_buffer\_pool\_size = 40M
key\_buffer\_size=10M
max\_connections=5

Also it's recommended to run a repair table on each of your databases after changing the mysql settings and restart the mysqld service.