Name | Effect | Values |
async = ( | asynchronous operations configuration options. | a set of related configuration options defined below. |
enabled | enable asynchronous operation. | a boolean flag; default false . |
ops_max | maximum number of expected simultaneous asynchronous operations. | an integer between 10 and 4096; default 1024 . |
threads | the number of worker threads to service asynchronous requests. | an integer between 1 and 20; default 2 . |
) | | |
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 . |
checkpoint = ( | periodically checkpoint the database. | a set of related configuration options defined below. |
name | the checkpoint name. | a string; default "WiredTigerCheckpoint" . |
wait | seconds to wait between each checkpoint; setting this value above 0 configures periodic checkpoints. | an integer between 0 and 100000; default 0 . |
) | | |
error_prefix | prefix string for error messages. | a string; default empty. |
eviction = ( | eviction configuration options. | a set of related configuration options defined below. |
threads_max | maximum number of threads WiredTiger will start to help evict pages from cache. The number of threads started will vary depending on the current eviction load. | an integer between 1 and 20; default 1 . |
threads_min | minimum number of threads WiredTiger will start to help evict pages from cache. The number of threads currently running will vary depending on the current eviction load. | an integer between 1 and 20; default 1 . |
) | | |
eviction_dirty_target | continue evicting until the cache has less dirty memory than the value, as a percentage of the total cache size. 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 has less total memory than the value, as a percentage of the total cache size. Must be less than eviction_trigger . | an integer between 10 and 99; default 80 . |
eviction_trigger | trigger eviction when the cache is using this much memory, as a percentage of the total cache size. | 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. |
chunk | the granularity that a shared cache is redistributed. | an integer between 1MB and 10TB; default 10MB . |
name | name of a cache that is shared between databases. | a string; default empty. |
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 . |
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 . |
statistics_log = ( | log any statistics the database is configured to maintain, to a file. See Statistics for more information. | a set of related configuration options defined below. |
on_close | log statistics on database close. | a boolean flag; default false . |
path | the pathname to a file into which the log records are written, may contain ISO C standard strftime conversion specifications. If the value is not an absolute path name, the file is created relative to the database home. | a string; default "WiredTigerStat.%d.%H" . |
sources | if non-empty, include statistics for the list of data source URIs, if they are open at the time of the statistics logging. The list may include URIs matching a single data source ("table:mytable"), or a URI matching all data sources of a particular type ("table:"). | a list of strings; default empty. |
timestamp | a timestamp prepended to each log record, may contain strftime conversion specifications. | a string; default "%b %d %H:%M:%S" . |
wait | seconds to wait between each write of the log records. | an integer between 0 and 100000; default 0 . |
) | | |
verbose | enable messages for various events. Only available if WiredTiger is configured with –enable-verbose. Options are given as a list, such as "verbose=[evictserver,read]" . | a list, with values chosen from the following options: "api" , "block" , "checkpoint" , "compact" , "evict" , "evictserver" , "fileops" , "log" , "lsm" , "metadata" , "mutex" , "overflow" , "read" , "readserver" , "reconcile" , "recovery" , "salvage" , "shared_cache" , "split" , "verify" , "version" , "write" ; default empty. |