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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13612 Startup takes longer than 5 - 50 minutes after update from MariaDB 5.5.x to 10.2.6

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14554 MariaDB server 10.2.10 doesn't repond on some requests

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11520 Extending an InnoDB data file unnecessarily allocates a large memory buffer on Windows

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14244 MariaDB 10.2.10 fails to run on Debian Stretch with ext3 and O_DIRECT

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          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.