Solution to MySQL being unable to start due to excessive memory configuration

Problem Description

MySQL reports an error when starting. Check the error log.

[ERROR] InnoDB: Cannot allocate memory for the buffer pool

(Memory required by the InnoDB engine cannot be allocated from the cache pool)

Solution

You need to adjust the size settings of innodb_buffer_pool_size and key_buffer_size in the MySQL configuration file my.cnf, and increase the memory allocation appropriately, generally adjusted to half of the system memory.

First use free -m to check the system memory size and check that it is 1G memory

Then vi /etc/my.cnf and adjust innodb_buffer_pool_size、key_buffer_size to 500M each.

Note: my.cnf is subject to the actual configuration file path.

Restart OK

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.