Tuning Tips for NuoDB Configuration

For a given database, hosting each Transaction Engine (TE) and Storage Manager (SM) on a separate machine typically gives better performance despite the added network latency. You should benchmark both configurations, comparing the TE and the SM on same system versus having each and on a separate). For an overview of NuoDB architecture, see NuoDB At a Glance.

Set NuoDB processes to have as much memory as possible (see mem Database option), but do not set the mem option so high that swapping occurs.

For a SM, the journal-sync-method database option defines the file system synchronization mechanism to be used when the journal needs to ensure the durability of a transaction commit. The synchronization method has been specifically tuned for each supported operating system.

See also: Tuning Tips for Journal Performance.