Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28766

MDEV-28111 breaks innodb_flush_log_at_trx_commit=2

Details

    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

          Activity

            axel Axel Schwenke created issue -
            axel Axel Schwenke made changes -
            Field Original Value New Value
            Description MDEV-28111 and specifically commit c4c88307091 breaks the meaning of
            axel Axel Schwenke made changes -
            Description MDEV-28111 and specifically commit c4c88307091 breaks the meaning of MDEV-28111 and specifically commit c4c88307091 breaks the meaning of {{innodb_flush_log_at_trx_commit = 0|2}} by enabling O_DIRECT for the redo log.

            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.
            axel Axel Schwenke made changes -
            Summary MDEV-28111 breaks innodb_flush_log_at_trx_commit != 1 MDEV-28111 breaks innodb_flush_log_at_trx_commit
            axel Axel Schwenke made changes -
            Assignee Marko Mäkelä [ marko ]
            axel Axel Schwenke made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            axel Axel Schwenke made changes -
            axel Axel Schwenke made changes -
            Fix Version/s 10.10 [ 27530 ]
            axel Axel Schwenke made changes -
            Attachment sysbench_insert.png [ 64102 ]
            axel Axel Schwenke made changes -
            Comment [  !sysbench_insert.png|thumbnail! ]
            axel Axel Schwenke made changes -
            Attachment sysbench_insert.png [ 64102 ]
            axel Axel Schwenke made changes -
            Attachment sysbench_insert.png [ 64103 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Environment Linux
            axel Axel Schwenke made changes -
            Attachment sysbench_insert2.png [ 64166 ]
            axel Axel Schwenke made changes -
            Attachment sysbench_insert3.png [ 64167 ]
            axel Axel Schwenke made changes -
            Summary MDEV-28111 breaks innodb_flush_log_at_trx_commit MDEV-28111 breaks innodb_flush_log_at_trx_commit=2
            axel Axel Schwenke made changes -
            Description MDEV-28111 and specifically commit c4c88307091 breaks the meaning of {{innodb_flush_log_at_trx_commit = 0|2}} by enabling O_DIRECT for the redo log.

            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.
            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.
            axel Axel Schwenke made changes -
            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.
            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.
            axel Axel Schwenke made changes -
            Attachment sysbench_insert3.png [ 64167 ]
            axel Axel Schwenke made changes -
            Attachment sysbench_insert3.png [ 64169 ]
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2022-06-14 16:07:05.0 2022-06-14 16:07:05.271
            marko Marko Mäkelä made changes -
            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 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -

            People

              marko Marko Mäkelä
              axel Axel Schwenke
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.