How to solve cannot allocate memory error on ec2 server centos

0
11
MySQL

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.

  1. Login to SSH
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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here