sqlf compact-all-disk-stores

Perform online compaction of SQLFire disk stores.


sqlf compact_all_disk_stores
 [-mcast-port=<port>] [-mcast-address=<address>]
 [-locators=<addresses>] [-bind-address=<address>] [-<prop-name>=<prop-value>]*

The table describes options for sqlf compact_all_disk_stores. If no multicast or locator options are specified on the command-line, then the command uses the sqlfire.properties file (if available) to determine the distributed system to which it should connect.

Option Description

Multicast port used to communicate with other members of the distributed system. If zero, multicast is not used for member discovery (specify -locators instead).

Valid values are in the range 0–65535, with a default value of 10334.


Multicast address used to discover other members of the distributed system. This value is used only if the -locators option is not specified.

The default multicast address is


List of locators used to discover members of the distributed system. Supply all locators as comma-separated host:port values.

-bind-address The address to which this peer binds for receiving peer-to-peer messages. By default sqlf uses the hostname, or localhost if the hostname points to a local loopback address.

Any other SQLFire distributed system property.


When a CRUD operation is performed on a persistent/overflow table, the data is written to the log files. Any pre-existing operation record for the same row becomes obsolete, and SQLFire marks it as garbage. It compacts an old operation log by copying all non-garbage records into the current log and discarding the old files.

Manual compaction can be done for online and offline disk stores. For the online disk store, the current operation log is not available for compaction, no matter how much garbage it contains.

Offline compaction runs essentially in the same way, but without the incoming CRUD operations. Also, because there is no current open log, the compaction creates a new one to get started.

Online Compaction

To run manual online compaction, allow-force-compaction should be true. You can run manual online compaction at any time while the system is running. Oplogs eligible for compaction based on the compaction-threshold are compacted into the current oplog.