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

Find and fix word Press vulnerabilities using WP Toolkit

If you purchased hosting services from us, you can use the WP Toolkit to scan…

2 years ago

Run composer with different PHP version

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

3 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…

4 years ago

Configure OpenVPN Client Devices for Andriod

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

4 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…

5 years ago