Amazon EC2, mysql aborting start because InnoDB: mmap (x bytes) failed; errno 12

by

I met the same problem when I tried to run a wordpress on my micro instance without RDS.

Adding a Swap page solved the problem for me.

You can follow steps below to setup the swap space.

If it still doesn’t work for you, consider using the RDS service.

===============================================

I copied the content of the blog for the record. Credit goes to the blog author pmoubed:

Amazon EC2 Micro Instance Swap Space – Linux

I have a Amazon EC2 Linux Micro instance. Since Micro instances have only 613MB of memory, MySQL crashed every now and then. After a long search about MySQL, Micro Instance and Memory Managment I found out there is no default SWAP space for Micro instance. So if you want to avoid the crash you may need to setup a swap space for your micro instance. Actually performance wise is better to enable swap.

Steps below show how to make a swap space for your Micro instance. I assume you have AWS Account with a Micro instance running.

  1. Run dd if=/dev/zero of=/swapfile bs=1M count=1024
  2. Run mkswap /swapfile
  3. Run swapon /swapfile
  4. Add this line /swapfile swap swap defaults 0 0 to /etc/fstab

Step 4 is needed if you would like to automatically enable swap file after each reboot.

Some useful command related to SWAP space:

$ swapon -s   
$ free -k

$ swapoff -a
$ swapon  -a

References:

  1. http://www.thegeekstuff.com/2010/08/how-to-add-swap-space/
  2. http://cloudstory.in/2012/02/getting-the-best-out-of-amazon-ec2-micro-instances/
  3. http://cloudstory.in/2012/02/adding-swap-space-to-amazon-ec2-linux-micro-instance-to-increase-the-performance/
  4. http://aws.amazon.com/ec2/instance-types/

More Related Contents:

  1. Connect to mysql on Amazon EC2 from a remote server
  2. Can’t connect to RDS instance from EC2 instance
  3. How to store Emoji Character in MySQL Database
  4. MySQL: Quick breakdown of the types of joins [duplicate]
  5. Any way to select without causing locking in MySQL?
  6. Log all queries in mysql
  7. Truncate all tables in a MySQL database in one command?
  8. Cast from VARCHAR to INT – MySQL
  9. Find distance between two points using latitude and longitude in mysql
  10. How to convert result table to JSON array in MySQL
  11. Adding multiple columns AFTER a specific column in MySQL
  12. MySQL varchar index length
  13. DOUBLE vs DECIMAL in MySQL
  14. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  15. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  16. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  17. Terminating idle mysql connections
  18. MySQL – Fetching lowest value
  19. How to alias a field or column in MySQL?
  20. SELECT query return 1 row from each group
  21. MySql Single Table, Select last 7 days and include empty rows
  22. How can I check MySQL engine type for a specific table?
  23. mysql SQL: specific item to be first and then to sort the rest of the items
  24. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  25. Where does MySQL store database files on Windows and what are the names of the files?
  26. When is a timestamp (auto) updated?
  27. Should I normalize my DB or not?
  28. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  29. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  30. MySQL Multiple Joins in one query?

Leave a Comment