1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
/*! @class doc_tune_durability_group_commit
WiredTiger automatically groups the flush operations for threads that
commit concurrently into single calls. This usually means
multi-threaded workloads will achieve higher throughput than
single-threaded workloads because the operating system can flush data
more efficiently to the disk. No application-level configuration is
required for this feature.
*/
/*! @class doc_tune_durability_flush_config
By default, log records are written to an in-memory buffer before
WT_SESSION::commit_transaction returns, giving highest performance but
not ensuring durability. The durability guarantees can be stricter but
will impact performance.
If \c transaction_sync=(enabled=false) is configured to ::wiredtiger_open,
log records may be buffered in memory, and only flushed to disk by
checkpoints, when log files switch or calls to WT_SESSION::begin_transaction
with \c sync=true. (Note that any call to WT_SESSION::begin_transaction
with \c sync=true will flush the log records for all committed transactions,
not just the transaction where the configuration is set.) This provides the
minimal guarantees, but will be significantly faster than other configurations.
If \c transaction_sync=(enabled=true), \c transaction_sync=(method)
further configures the method used to flush log records to disk. By
default, the configured value is \c fsync, which calls the operating
system's \c fsync call (of \c fdatasync if available) as each commit completes.
If the value is set to \c dsync, the \c O_DSYNC or \c O_SYNC
flag to the operating system's \c open call will be specified when the
file is opened. (The durability guarantee of the \c fsync and \c dsync
configurations are the same, and in our experience the \c open flags are
slower, this configuration is only included for systems where that may
not be the case.)
If the value is set to \c none, the operating system's \c write call
will be called as each commit completes but does not flush to disk.
This setting gives durability at the application level but not at
the system level.
When a log file fills and the system moves to the next log file, the
previous log file will always be flushed to disk prior to close. So
when running in a durability mode that does not flush to disk, the risk
is bounded by the most recent log file change.
Here is the expected performance of durability modes, in order from the
fastest to the slowest (and from the fewest durability guarantees to the
most durability guarantees).
<table>
@hrow{Durability Mode, Notes}
@row{<code>log=(enabled=false)</code>, checkpoint-level durability}
@row{<code>log=(enabled)\,transaction_sync=(enabled=false)</code>,
in-memory buffered logging configured; updates durable after
checkpoint or after \c sync is set in WT_SESSION::begin_transaction}
@row{<code>log=(enabled)\,transaction_sync=(enabled=true\,method=none)</code>,
logging configured; updates durable after application failure\,
but not after system failure}
@row{<code>log=(enabled)\,transaction_sync=(enabled=true\,method=fsync)</code>,
logging configured; updates durable on application or system
failure}
@row{<code>log=(enabled)\,transaction_sync=(enabled=true\,method=dsync)</code>,
logging configured; updates durable on application or system
failure}
</table>
*/
/*! @page tune_durability Commit-level durability
There are some considerations when configuring commit-level durability
that can affect performance.
@section tune_durability_group_commit Group commit
@copydoc doc_tune_durability_group_commit
@section tune_durability_flush_config Flush call configuration
@copydoc doc_tune_durability_flush_config
*/
|
