Modifying Database Option Settings

Database level options can help determine the database characteristics and can be configured uniquely for each database.

Note: See Database Options for information about important distinctions between database process options and database system options. Note that database process options will not take effect until that process (TE, SM, or SSM) is restarted.

Options that should be specified per host (for example, options that might point at local directories) should be specified in the nuodb.config file.

NuoDB Manager

nuodb [domain] > show database config
Database: Database: test, ACTIVE, Status=RUNNING
  Variables: {HOST=fe597e42-201b-491f-ac94-b9906f777753}
  Options: {}
  Default Options: { "commit": "${COMMIT:remote:1}","backoff.reqMinUptime":"30000"}
  Process group options:
  Process group tag constraints:
  Archive Locations:
    ip-172-31-2-230/54.148.240.227:48004, requirements: SMs, region: us-west-2:
      archive: /var/opt/nuodb/production-archives/test
      journal-dir: /var/opt/nuodb/production-archives/test


 
nuodb [domain] > show database config
Database: test
Database: test,(unmanaged) ACTIVE, Status=RUNNING, 
  Variables: {HOST=fe597e42-201b-491f-ac94-b9906f777753}
  Options: {}
  Default Options: { "commit": "${COMMIT:remote:1}","backoff.reqMinUptime":"30000"}
  Process group options:
     SMs: {journal-max-directory-entries=500}
  Process group tag constraints:
  Archive Locations:
    ip-172-31-2-230/54.148.240.227:48004, requirements: SMs, region: us-west-2:
      archive: /var/opt/nuodb/production-archives/test
      journal-dir: /var/opt/nuodb/production-archives/test