{"id":68,"date":"2016-05-05T08:34:47","date_gmt":"2016-05-05T08:34:47","guid":{"rendered":"https:\/\/www.hostingahead.com\/blog\/?p=68"},"modified":"2016-05-06T07:27:31","modified_gmt":"2016-05-06T07:27:31","slug":"mysql-crash-fatal-error-cannot-allocate-memory-buffer-pool","status":"publish","type":"post","link":"https:\/\/www.hostingahead.com\/blog\/mysql-crash-fatal-error-cannot-allocate-memory-buffer-pool\/","title":{"rendered":"MySQL Crashed with Fatal error cannot allocate memory for the buffer pool"},"content":{"rendered":"<p>There are two reasons for this error &#8220;cannot allocate memory for the buffer pool&#8221;<br \/>\n1) The system has no enough RAM or SWAP<br \/>\n2) innodb_buffer_pool_size is bigger.<\/p>\n<p>To fix this problem you can try two things<\/p>\n<p>1) Add swap memory.<\/p>\n<p>2) Edit \/etc\/my.cnf, and add the following line under the [mysqld] heading.<br \/>\n[mysqld]<\/p>\n<blockquote><p>innodb_buffer_pool_size=64M<\/p><\/blockquote>\n<p>Now you can shutdown mysql server and start it again<\/p>\n<blockquote><p>mysqladmin -uroot -p shutdown<\/p>\n<p>service mysqld start<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>There are two reasons for this error &#8220;cannot allocate memory for the buffer pool&#8221; 1) The system has no enough RAM or SWAP 2) innodb_buffer_pool_size is bigger. To fix this problem you can try two things 1) Add swap memory. 2) Edit \/etc\/my.cnf, and add the following line under the [mysqld] heading. [mysqld] innodb_buffer_pool_size=64M Now &#8230;<\/p>\n","protected":false},"author":101012,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/posts\/68"}],"collection":[{"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/users\/101012"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":1,"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"predecessor-version":[{"id":69,"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/posts\/68\/revisions\/69"}],"wp:attachment":[{"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostingahead.com\/blog\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}