• Vladislav Vaintroub's avatar
    MDEV-13941 Fix high NTFS fragmentation on 10.2 · 96b9c617
    Vladislav Vaintroub authored
    Prior to this patch, creating or even opening any innodb file in 10.2
    would set a sparse flag on file. The file extension was done by setting
    end of file, without writing zeros. This technique is fine, however
    due to sparsedness, it created a hole at the end of the file, which
    lead to much higher fragmentation subsequently.
    
    The fix is only to use sparse flag for compressed tables, where holes
    are actually wanted, but not for normal tables.
    96b9c617
os0file.h 50.4 KB