728x90
반응형
vi /ect/mysql/my.cnf
# innodb 설정 값 중 메모리량을 적절하게 변경
innodb_buffer_pool_size = 5120M
innodb_data_file_path = ibdata1:1000M:autoextend
2018-07-13 14:00:43 21419 [Note] InnoDB: Initializing buffer pool, size = 5.0G
InnoDB: mmap(686817280 bytes) failed; errno 12
2018-07-13 14:00:44 21419 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-07-13 14:00:44 21419 [ERROR] Plugin 'InnoDB' init function returned error.
2018-07-13 14:00:44 21419 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-07-13 14:00:44 21419 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-07-13 14:00:44 21419 [ERROR] Aborting
총 메모리량이 적어서 에러가 발생
728x90
반응형
'Database > MySQL' 카테고리의 다른 글
MySQL Replication 연결 (0) | 2019.10.22 |
---|---|
MySQL DB 명세서 쿼리 작성 (0) | 2019.10.22 |
MySQL 프로시저 디버그 (0) | 2019.10.22 |
MySQL error 1364 Field doesn't have a default values (0) | 2019.10.22 |
MySQL Dump시 테이블 Lock 에러 (0) | 2019.10.22 |