How to Solve fatel error out of memory

0
12
MySQL

This example explains how to solve the issue of memory allocation (fatel error out of memory) 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(fatel error out of memory) in MySQL.

LEAVE A REPLY

Please enter your comment!
Please enter your name here