HomeGetting StartedInstallation & SetupDevelopment & IntegrationDeployment & OperationsData ManagementTechnical SupportPlatform Updates
DocsDeployment & OperationsAdmin CLI Referencedb optimize

stardog-admin db optimize

Description

Optimizes the indexes of a database for query answering and disk utilization

Usage

stardog-admin [ --krb5 ] [ --krb5-disable-rdns ] [ --server <server url> ] db optimize [ --no-space-check ] [ --no-throttle ] [ {-o | --option} <options>... ] [ {-p | --passwd} <password> ] [ {-P | --ask-password} ] [ --run-as <username> ] [ --token <token> ] [ {-u | --username} <username> ] [ {-v | --verbose} ] [--] <database>

Options

Name, shorthandDescription
--krb5Use the Kerberos environment.
--krb5-disable-rdnsDisable reverse DNS lookup for Kerberos clients.
--no-space-checkOverride server's detection of too low storage space. Low storage space could force a server into read-only mode and subsequent restart.
--no-throttleDisable Stardog's default configuration to intentionally throttle the optimize operation.
-o <options>, --option <options>One or more configuration options to be used for optimization. Each option is a 'key=value' pair; multiple options are separated by whitespaces and the string should be quoted, e.g., '-o "option1=value1 option2=value2"'.
-p <password>, --passwd <password>Password.
-P, --ask-passwordPrompt for password.
--run-as <username>User to impersonate when running the command
--server <server url>URL of Stardog Server. If this option isn't specified, it will be read from JVM argument 'stardog.default.cli.server'. If the JVM arg isn't set, the default value 'http://localhost:5820' is used. If server URL has no explicit port value, the default port value '5820' is used. Example: 'stardog-admin --server http://12.34.56.78:5820 server stop'
--token <token>Stardog JWT token
-u <username>, --username <username>User name.
-v, --verboseFlag that can cause more detailed information to be printed such as errors and status. Exact output depends upon the command and options used.
--This option can be used to separate command-line options from the list of argument(s). (Useful when an argument might be mistaken for a command-line option)
<database>The name of the database for the operation

Discussion

Optimizes the indexes of a database for query answering and disk utilization after the database has been heavily modified. If a database has been modified with a large number of additions or removals, some internal structures may become less optimized for query answering. This utility will perform several operations that will help with query answering performance. Which operations are performed depends on the options given. Currently supported options:

  • optimize.statistics={true, false}: recomputes the selectivity statistics which is used for query optimization
  • optimize.compact={true, false}: compacts the index data structures after update operations
  • optimize.vacuum.data={true, false}: frees space by removing quads which have been previously deleted from the database
  • optimize.vacuum.dictionary={true, false}: optimizes internal encoding of RDF terms, removes terms which no longer appear in the data
  • optimize.search={true, false}: recomputes the full-text search index

Examples

Optimize the database 'myDb':

    $ stardog-admin db optimize myDb