Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.
Triggers the garbage collector on the source aggregator and propagates to all the leaves.
TRIGGER [n] GC [FLUSH]
FLUSH: Releases all unused memory back to the operating system.
n: Specifies the number of passes of the GC to run. By default, MemSQL runs 3 passes of the GC.
SUPERprivileges can run this command.
FLUSHoption. (MemSQL only caches memory when it is available and not under any duress. Hence, this practice may turn out to be counter-productive.)
TRIGGER GC FLUSH;