| Name | Effect | Values |
cache_size | maximum heap memory to allocate for the cache. A database should configure either a cache_size or a shared_cache not both. | an integer between 1MB and 10TB; default 100MB. |
error_prefix | prefix string for error messages. | a string; default empty. |
eviction_dirty_target | continue evicting until the cache has less dirty pages than this (as a percentage). Dirty pages will only be evicted if the cache is full enough to trigger eviction. | an integer between 10 and 99; default 80. |
eviction_target | continue evicting until the cache becomes less full than this (as a percentage). Must be less than eviction_trigger. | an integer between 10 and 99; default 80. |
eviction_trigger | trigger eviction when the cache becomes this full (as a percentage). | an integer between 10 and 99; default 95. |
shared_cache = ( | shared cache configuration options. A database should configure either a cache_size or a shared_cache not both. | a set of related configuration options defined below. |
enable | whether the connection is using a shared cache. | a boolean flag; default false. |
chunk | the granularity that a shared cache is redistributed. | an integer between 1MB and 10TB; default 10MB. |
reserve | amount of cache this database is guaranteed to have available from the shared cache. This setting is per database. Defaults to the chunk size. | an integer; default 0. |
name | name of a cache that is shared between databases. | a string; default pool. |
size | maximum memory to allocate for the shared cache. Setting this will update the value if one is already set. | an integer between 1MB and 10TB; default 500MB. |
) | | |
statistics | Maintain database statistics, which may impact performance. Choosing "all" maintains all statistics regardless of cost, "fast" maintains a subset of statistics that are relatively inexpensive, "none" turns off all statistics. The "clear" configuration resets statistics after they are gathered, where appropriate (for example, a cache size statistic is not cleared, while the count of cursor insert operations will be cleared). When "clear" is configured for the database, gathered statistics are reset each time a statistics cursor is used to gather statistics, as well as each time statistics are logged using the statistics_log configuration. See Statistics for more information. | a list, with values chosen from the following options: "all", "fast", "none", "clear"; default none. |
verbose | enable messages for various events. Options are given as a list, such as "verbose=[evictserver,read]". | a list, with values chosen from the following options: "block", "ckpt", "compact", "evict", "evictserver", "fileops", "hazard", "log", "lsm", "mutex", "overflow", "read", "readserver", "reconcile", "recovery", "salvage", "shared_cache", "verify", "version", "write"; default empty. |