《mysql InnoDB: Cannot allocate memory for the buffer poolMysql學習》要點：
本文介紹了mysql InnoDB: Cannot allocate memory for the buffer poolMysql學習，希望對您有用。如果有疑問，可以聯系我們。

1. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?The?InnoDB?memory?heap?is?disabled?
2. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?Mutexes?and?rw_locks?use?GCC?atomic?builtins?
3. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?Memory?barrier?is?not?used?
4. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?Compressed?tables?use?zlib?1.2.3?
5. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?Using?Linux?native?AIO?
6. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?Using?CPU?crc32?instructions?
7. 2017-09-03?17:38:21?20390?[Note]?InnoDB:?Initializing?buffer?pool,?size?=?128.0M?
8. InnoDB:?mmap(137363456?bytes)?failed;?errno?12?
9. 2017-09-03?17:38:21?20390?[ERROR]?InnoDB:?Cannot?allocate?memory?for?the?buffer?pool?
10. 2017-09-03?17:38:21?20390?[ERROR]?Plugin?‘InnoDB’?init?function?returned?error.?
11. 2017-09-03?17:38:21?20390?[ERROR]?Plugin?‘InnoDB’?registration?as?a?STORAGE?ENGINE?failed.?
12. 2017-09-03?17:38:21?20390?[ERROR]?Unknown/unsupported?storage?engine:?InnoDB?
13. 2017-09-03?17:38:21?20390?[ERROR]?Aborting?
14. 2017-09-03?17:38:21?20390?[Note]?Binlog?end?
15. 2017-09-03?17:38:21?20390?[Note]?Shutting?down?plugin?‘partition’?
16. 2017-09-03?17:38:21?20390?[Note]?Shutting?down?plugin?‘PERFORMANCE_SCHEMA’?

其中標為黃色的就比較重要了,百度Cannot allocate memory for the buffer pool都說是無法給innodb分配足夠的內存,大多數給出的解決的方案是：修改innodb_buffer_pool_size,但是我這個my.cnf里面沒有,那就加一個被唄,順便將這個字段設置成200M,重啟mysql發現一樣的結果,還是啟動不了,去看日志還是一樣的問題,還是太大咯?

用free -m看下

total??????? used??????? free????? shared? buff/cache?? available
Mem:??????????? 992???????? 574???????? 159?????????? 0???????? 258???????? 260
Swap:???????????? 0?????????? 0?????????? 0

只有185M的內存了,只能再改小點咯,改成64.

service mysqld restart,終于

Starting MySQL. [ OK ]MYSQL學習

轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/5029.html