You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

TRIGGER GC

Triggers the garbage collector on the source aggregator and propagates to all the leaves.

Syntax

TRIGGER <n> GC [FLUSH]

Arguments

  • 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.

Remarks

  • This command can be run on any aggregator.
  • Only users with SUPER privileges can run this command.

Examples

TRIGGER 3 GC FLUSH;