Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.8.3, 10.9.1
-
None
-
Linux
Description
MDEV-28111 and specifically commit c4c88307091 breaks the meaning of innodb_flush_log_at_trx_commit = 2 by enabling O_DIRECT for the redo log.
O_DIRECT should not be used when innodb_flush_log_at_trx_commit = 2 is set. Since this variable is dynamic, it has not only to be checked at server startup, but each time the variable is written to.
Attachments
Issue Links
- is caused by
-
-
- Closed
-
- relates to
-
MDEV-30136 Map innodb_flush_method to new settable Booleans innodb_{log,data}_file_{buffering,write_through}
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
|
| Description |
|
O_DIRECT should not be used when {{innodb_flush_log_at_trx_commit = 0}} (or = 2) is set. Since this variable is dynamic, it has not only to be checked at server startup, but each time the variable is written to. |
| Summary |
|
|
| Assignee | Marko Mäkelä [ marko ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Link | This issue relates to PERF-185 [ PERF-185 ] |
| Fix Version/s | 10.10 [ 27530 ] |
| Attachment | sysbench_insert.png [ 64102 ] |
| Comment | [ !sysbench_insert.png|thumbnail! ] |
| Attachment | sysbench_insert.png [ 64102 ] |
| Attachment | sysbench_insert.png [ 64103 ] |
| Link |
This issue is caused by |
| Environment | Linux |
| Attachment | sysbench_insert2.png [ 64166 ] |
| Attachment | sysbench_insert3.png [ 64167 ] |
| Summary |
|
|
| Description |
O_DIRECT should not be used when {{innodb_flush_log_at_trx_commit = 0}} (or = 2) is set. Since this variable is dynamic, it has not only to be checked at server startup, but each time the variable is written to. |
O_DIRECT should not be used when {{innodb_flush_log_at_trx_commit = 2}} is set. Since this variable is dynamic, it has not only to be checked at server startup, but each time the variable is written to. |
| Description |
O_DIRECT should not be used when {{innodb_flush_log_at_trx_commit = 2}} is set. Since this variable is dynamic, it has not only to be checked at server startup, but each time the variable is written to. |
O_DIRECT should not be used when {{innodb_flush_log_at_trx_commit = 2}} is set. Since this variable is dynamic, it has not only to be checked at server startup, but each time the variable is written to. |
| Attachment | sysbench_insert3.png [ 64167 ] |
| Attachment | sysbench_insert3.png [ 64169 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2022-06-14 16:07:05.0 | 2022-06-14 16:07:05.271 |
| Fix Version/s | 10.8.4 [ 27503 ] | |
| Fix Version/s | 10.9.2 [ 27115 ] | |
| Fix Version/s | 10.10.0 [ 27912 ] | |
| Fix Version/s | 10.8 [ 26121 ] | |
| Fix Version/s | 10.9 [ 26905 ] | |
| Fix Version/s | 10.10 [ 27530 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link |
This issue relates to |