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

innodb_flush_neighbors=ON should be ignored on SSD

    Details

      Description

      innodb_flush_neighbors was an optimization for rotating disk, to have larger IO size. It costs CPU, and it does not bring anything for the SSD. I think OFF is now a good default (and also it has good in the past couple of years)

      See for example
      https://stackoverflow.com/questions/40732595/is-there-any-configuration-option-for-innodb-that-increase-the-performance-for-s

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                wlad Vladislav Vaintroub
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: