There is now GP-CLI available to help you easily configure these settings on the command line. You can learn more about how it all works in this article:
Configure Monit Service Management and Notifications with GP-CLI
To configure Monit settings for MySQL the commands begin with: gpmonit mysql.
Increase Memory Allocation
For this example, we could use the following settings to allow MySQL to run with 50% of the RAM:
gpmonit mysql \
-mem-high-mb 900 \
-mem-restart-mb 1024 This command raises how much memory MySQL is allowed to consume before Monit restarts the service, and adjust the notifications accordingly as well.
Keep in mind that the more memory you allocate to one service, the less memory other services potentially have access to.