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