How to solve cannot allocate memory error on ec2 server centos

April 11, 2019

This example explains how to solve the issue of memory allocation on EC2 Server

You need to change input buffer pool size MySQL in your configuration.

sudo -i

2. Open my.cnf file

nano /etc/my.cnf

3. Write the following line below [mysqld]

innodb_buffer_pool_size=1G // if you want to allot in GB

4. If you want to allot in bytes then you can assign directly value.

innodb_buffer_pool_size=204800000

5. Restart the mysqld service

service mysqld restart

6. Check the value in PHPMyAdmin

SHOW GLOBAL VARIABLES LIKE 'innodb_buffer_pool_size';

This will show the input buffer pool size for Mysql. This will solve the issue of Memory allocation in MySQL.