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

Hint to size InnoDB REDO Log buffer

Details

    Description

      Documentation states:

      Attachments

        Activity

          oli Oli Sennhauser added a comment -

          In general I miss recommendations about how to size certain MariaDB/InnoDB parameters or what are signs that a specific parameter is not appropriately sized. For example:

          Documentation states for innodb_log_buffer_size:

          "Increasing this (innodb redo log buffer) means larger transactions can run without needing to perform disk I/O before committing."
          Source: https://mariadb.com/kb/en/innodb-system-variables/#innodb_log_buffer_size

          Documentation also states for innodb_log_waits:

          "Number of times InnoDB was forced to wait for log writes to be flushed due to the log buffer being too small."

          Source: https://mariadb.com/kb/en/innodb-status-variables/#innodb_log_waits

          So as a conclusion I would like to see a comment under innodb_log_buffer_size similar to: "And indication that InnoDB log buffer size is (sometimes) too small is an increased innodb_log_waits status variables counter"...

          oli Oli Sennhauser added a comment - In general I miss recommendations about how to size certain MariaDB/InnoDB parameters or what are signs that a specific parameter is not appropriately sized. For example: Documentation states for innodb_log_buffer_size: "Increasing this (innodb redo log buffer) means larger transactions can run without needing to perform disk I/O before committing." Source: https://mariadb.com/kb/en/innodb-system-variables/#innodb_log_buffer_size Documentation also states for innodb_log_waits: "Number of times InnoDB was forced to wait for log writes to be flushed due to the log buffer being too small." Source: https://mariadb.com/kb/en/innodb-status-variables/#innodb_log_waits So as a conclusion I would like to see a comment under innodb_log_buffer_size similar to: "And indication that InnoDB log buffer size is (sometimes) too small is an increased innodb_log_waits status variables counter"...

          People

            greenman Ian Gilfillan
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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