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

Innodb/Windows, 10.2 : High NTFS fragmentation

    XMLWordPrintable

Details

    Description

      High NTFS fragmentation, and IO error was reported by on stackexchange
      https://dba.stackexchange.com/questions/186895/ntfs-filesystem-fragmentation-issue-occur-after-migrating-mysql-5-6-database-to

      This is for 10.2. There are 2 things that have changed as compared with to previous version

      1. all files are made sparse "when opening", this was ported from Innodb 5.7
      2. when tablespace is extended, we do not write binary zeros anymore to the file, but instead
        SetFileInformationByHandle with FileEndOfFileInfo

      Together, those changes might create a "hole" at the end of file, even if compression is not on. Also some investigation should be done on whether to write binary zeroes is necessary, and on how exactly to grow file. There are several options - write zeroes, SetEndOfFile, SetFileInformationByHandle(), DeviceIoControl(FSCTL_SET_ZERO_RANGE) . Some details can be found in https://stackoverflow.com/questions/46458151/setendoffile-vs-setfileinformationbyhandle-to-extend-file)

      Attachments

        Issue Links

          Activity

            People

              wlad Vladislav Vaintroub
              wlad Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.