Changing MySQL Sizing on Linux

To adjust the MySQL memory, follow these steps:

By default, the MySQL installation does not create the configuration file, my.cnf. In this case, create it under /etc. If the file exists, update it based on your business needs.
Update or add the entry 'innodb_buffer_pool_size' under the '[mysqld]' section.
After updating the configuration file, restart MySQL for the new value to take effect.