Join the SingleStore 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. In practice, always use 3 passes of the GC.
SUPERprivileges can run this command.
TRIGGER 3 GC FLUSH;