Categories: Mysql

MySQL Crashed with Fatal error cannot allocate memory for the buffer pool

There are two reasons for this error “cannot allocate memory for the buffer pool”
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 you can shutdown mysql server and start it again

mysqladmin -uroot -p shutdown

service mysqld start

Hosting Ahead

Share
Published by
Hosting Ahead

Recent Posts

Run composer with different PHP version

If multiple PHP versions are installed on your server you need to tell the composer…

2 years ago

How to Install WordPress using WordPress Toolkit in cPanel

Wordpress toolkit allows the installation, configuration, and management of Wordpress. The first step is to…

3 years ago

Configure OpenVPN Client Devices for Andriod

These instructions cover installing and configuring the OpenVPN Connect app  Client-Side Configurations: Android There are…

3 years ago

The certificate chain was issued by an authority that is not trusted | SQL Server

This error may appear when you try to connect to Microsft SQL server or you…

4 years ago

Free website hosting support in this COVID pandemic

Hello everyone, The COVID-19 should have affected almost everyone in a way or another. When…

4 years ago

Amazon workspaces to build a secure work from home cloud infrastructure

Based on the current Covid19 scenario, several companies asked employees to work from home. Google…

4 years ago