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.
FLUSHoption. (MemSQL only caches memory when it is available and not under any duress. Hence, this practice may turn out to be counter-productive.)
SUPERprivileges can run this command.
TRIGGER GC FLUSH;