Increase memory size for MySQL Server

To increase the memory size for a MySQL Server, follow these steps:

1.Log in to the management mode by typing your password and pressing Enter twice. Select Exit to terminal using the arrow keys and then press Enter.

2.Type:
nano /etc/my.cnf

3.Locate the line innodb_buffer_pool_size=2G and change the number to 50% of RAM of the VM. 2G means two gigabytes.

4.Press Ctrl+X to exit the text editor, then press Y to save.

5.Reboot the appliance using the Restart system option in management mode.