You don't need to defragment with 364,329 fragments in one file...

[jamesd]

I've been doing some work on tracking down a performance problem with one IBD file per table. For comparison I created a version with all tables in one IBD file, some 26GB / 2,400 databases / 446,000 tables. That IBD file ended up having 364,329 fragments averaging 72k each but Windows said the drive didn't need to be defragmented. It would have

Comments

[galbinus_caeli]

NTFS probably just counts the number of fragmented files, without regard to how big or how fragmented each file is.