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 (specified during ESET PROTECT VA configuration) 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.