Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.
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, SingleStore DB runs 3 passes of the GC.
FLUSHoption. (SingleStore DB 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;