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.
- 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.