To increase the memory size for a MySQL Server, follow these steps:
1.Enter management mode by typing your password and pressing Enter twice. Select Exit to terminal using the arrow keys and then press Enter
3.Locate the line innodb_buffer_pool_size = 1024M and change the number to 50% of RAM of the VM. 1024M means 1024 megabytes.
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.