Reorg

NAME

reorg - reorganizes and optionally resizes running database hash size

SYNOPSIS

/opt/asdic/bin/reorg [-s <size in elements>] [-p <size in percent of present>] <database>

DESCRIPTION

Reorganizes databases to gain access speed. Can also resize hash size. The database is locked during the reorganization, making it inaccessible for all clients, including the web user interface.

The hash size is related to access speed and database size. Optimally, it should be about the same size as the usage.

During reorg, the asdic process creates a flat file database named var/databasename.pdb. Due to heavy I/O during the reorg, the var subdirectory of the database directory is recommended to reside on its own physical disk. The flat file created during reorg is suitable for backup purposes, and can be imported via the import command.

OPTIONS

-s

New size of hash table in elements.

-p

New size of hash table in percent of current usage.

EXAMPLE

Reorganize the history database and readjust the hash size to reflect the current (100%) usage.

# reorg -p 100 history