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

Innodb/Windows, 10.2 : High NTFS fragmentation

    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

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                wlad Vladislav Vaintroub
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: