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. |