When Presto is running, it uses the amount of memory allocated for it in the jvm.config files. The minimum is 16 GB of memory. To free memory for other processes on the system, stop Presto when you are not running queries.
You can stop and start Presto by logging in to the prestoadmin node as a prestoadmin user and using the following commands:
- ./presto-admin server stop
- ./presto-admin server start
To determine how much memory is allocated to Presto nodes, log in to the prestoadmin node and use the following commands to view the jvm.config files.
- cat /home/prestoadmin/.prestoadmin/coordinator/jvm.config
- cat /home/prestoadmin/.prestoadmin/workers/jvm.config