InnoDB: mmap(137363456 bytes) failed; errno 12

갑자기 mysql 데몬이 올라오지 않음.

로그 확인

]# cat /var/log/mysqld.log 

2016-09-06 03:31:51 0 [Note] /usr/sbin/mysqld (mysqld 5.6.31) starting as process 6388 ...

2016-09-06 03:31:52 6388 [Note] Plugin 'FEDERATED' is disabled.

2016-09-06 03:31:52 6388 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-09-06 03:31:52 6388 [Note] InnoDB: The InnoDB memory heap is disabled

2016-09-06 03:31:52 6388 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-09-06 03:31:52 6388 [Note] InnoDB: Memory barrier is not used

2016-09-06 03:31:52 6388 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-09-06 03:31:52 6388 [Note] InnoDB: Using Linux native AIO

2016-09-06 03:31:52 6388 [Note] InnoDB: Using CPU crc32 instructions

2016-09-06 03:31:52 6388 [Note] InnoDB: Initializing buffer pool, size = 128.0M

InnoDB: mmap(137363456 bytes) failed; errno 12

2016-09-06 03:31:52 6388 [ERROR] InnoDB: Cannot allocate memory for the buffer pool

2016-09-06 03:31:52 6388 [ERROR] Plugin 'InnoDB' init function returned error.

2016-09-06 03:31:52 6388 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2016-09-06 03:31:52 6388 [ERROR] Unknown/unsupported storage engine: InnoDB

2016-09-06 03:31:52 6388 [ERROR] Aborting

버퍼 풀 메모리가 너무 커서 생긴 문제였음 (서버 메모리 : 512메가)

Mysql 환경설정 파일을 열어서

]# vi etc/my.cnf

innodb_buffer_pool_size = 64M 로 수정

수정 후 데몬 실행!

]# service mysqld start

Starting mysqld:                                           [  OK  ]

Ps. 여건이 되는대로 서버 메모리를 올리시면 해결가능

참고 : http://pat.im/1033