Fix MySQL stops unexpectedly with EC2 Micro Instance 解决MySQL在EC2无法启动的问题


If you had ever encountered the error as follows (tail /var/log/mysqld.log):
Screen Shot 2013-11-19 at 9.49.25 AM

120423 09:13:38 mysqld_safe mysqld from pid file /var/run/mysqld/ ended
120423 09:14:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120423  9:14:27 [Note] Plugin 'FEDERATED' is disabled.
120423  9:14:27 InnoDB: The InnoDB memory heap is disabled
120423  9:14:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120423  9:14:27 InnoDB: Compressed tables use zlib 1.2.3
120423  9:14:27 InnoDB: Using Linux native AIO
120423  9:14:27 InnoDB: Initializing buffer pool, size = 512.0M
InnoDB: mmap(549453824 bytes) failed; errno 12
120423  9:14:27 InnoDB: Completed initialization of buffer pool
120423  9:14:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120423  9:14:27 [ERROR] Plugin 'InnoDB' init function returned error.
120423  9:14:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120423  9:14:27 [ERROR] Unknown/unsupported storage engine: InnoDB
120423  9:14:27 [ERROR] Aborting

That’s because the micro instance doesn’t bring with Swap page.

Solution is here. Run the command:

sudo dd if=/dev/zero of=/swapfile bs=1M count=1024 && sudo mkswap /swapfile && sudo swapon /swapfile


Finally, add this line /swapfile swap swap defaults 0 0 to /etc/fstab
最后,在/etc/fstab 这个文件添加此行:

/swapfile swap swap defaults 0 0


Now you can restart mysqld by running: sudo service mysqld restart
现在你可以重启mysqld了: sudo service mysqld restart


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.