Note
This parameter had been rarely used since it was introduced. Therefore, it has been deprecated since OceanBase Database V4.0.0.
Description
flush_log_at_trx_commit specifies the transaction log write strategy adopted when transactions are committed.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 1 |
| Value range | [0, 2] |
| Effective upon OBServer node restart | No |
Considerations
The strategy varies with the value of the flush_log_at_trx_commit parameter. The parameter has the following valid values:
0: The system does not wait for the logs to be written to the buffer.1: The system waits for the logs to be written to the disk.2: The system waits for the logs to be written to the buffer but does not wait for the logs to be written to the disk.
