flush_log_at_trx_commit specifies the transaction log write policy at transaction commitment.
Note
This parameter is deprecated since OceanBase Database V4.0.0.
| Parameter | Description |
|---|---|
| Type | Integer |
| Default value | 1 |
| Value range | [0, 2] |
| Effective upon restart of OBServer node | No |
The policy varies with the value of flush_log_at_trx_commit:
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.