1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Unable to defrag large file

Discussion in 'Windows XP' started by marty, 2007/01/05.

  1. 2007/01/05
    marty

    marty Inactive Thread Starter

    Joined:
    2002/01/20
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    106
    Location:
    Woodstock NY
    Computer Experience:
    experienced
    My E: partition has a 3GB file which I can't defragment. Have tried the XP home defrag and also Power Defrag, either way I end up with this (Mysql DB Index) file in hundreds of pieces, and that is a problem for me.

    Here's the Windows defrag report for that partition:

    Volume usr (E: )
    Volume size = 9.77 GB
    Cluster size = 4 KB
    Used space = 4.45 GB
    Free space = 5.32 GB
    Percent free space = 54 %

    Volume fragmentation
    Total fragmentation = 31 %
    File fragmentation = 62 %
    Free space fragmentation = 0 %

    File fragmentation
    Total files = 10,195
    Average file size = 591 KB
    Total fragmented files = 1
    Total excess fragments = 444
    Average fragments per file = 1.04

    Pagefile fragmentation
    Pagefile size = 0 bytes
    Total fragments = 0

    Folder fragmentation
    Total folders = 846
    Fragmented folders = 1
    Excess folder fragments = 0

    Master File Table (MFT) fragmentation
    Total MFT size = 86 MB
    MFT record count = 11,059
    Percent MFT in use = 12 %
    Total MFT fragments = 2

    --------------------------------------------------------------------------------
    Fragments File Size Files that cannot be defragmented
    445 2.78 GB \User\Mysql\data\mydata\bigdataset.MYI


    Marty
     
  2. 2007/01/05
    Bmoore1129

    Bmoore1129 Geek Member

    Joined:
    2002/06/11
    Messages:
    1,675
    Likes Received:
    3
    Trophy Points:
    358
    Location:
    Montgomery County Texas
    Computer Experience:
    Intermediate
    Looks like you have plenty of free space which is the usual thing about files that won't defrag.

    How about some attribute in the file itself that is not allowing defrag. Security permissions maybe?
     

  3. to hide this advert.

  4. 2007/01/05
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    11,825
    Likes Received:
    174
    Trophy Points:
    843
    Location:
    Dallas, TX
    Computer Experience:
    Experienced
    If any SQL services are running the file could be in use and not allowing it to be defragged.
     
  5. 2007/01/05
    marty

    marty Inactive Thread Starter

    Joined:
    2002/01/20
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    106
    Location:
    Woodstock NY
    Computer Experience:
    experienced
    Wanted to post back that I've fixed it. I don't think it was the mysql server running because I rebooted and tried again.

    What I did was make a network copy on another box, then went to that machine and defragmented the partition with the 3 gb file, but it was all in one piece anyway.

    Then I deleted my local copy, cleared the trash and defragged the partition. Then when copying again from the network share onto my local partition it came in as one piece. I ran defrag then fine but it wasn't even needed, ended almost immediately.

    Marty
     
  6. 2007/01/05
    Bill Castner

    Bill Castner Inactive

    Joined:
    2006/08/30
    Messages:
    1,980
    Likes Received:
    0
    Trophy Points:
    356
    Location:
    Chevy Chase, MD USA
    Computer Experience:
    Experienced
    Marty,

    Your way would surely work, but it does not have to be this hard.

    The issue defrag was having is that it needs at least 1.5 times the used space on the volume as working room, even for a single file.
    Used space = 4.45 GB
    Free space = 5.32 GB

    You do not fit.

    In the future use the freeware utility Microsoft/Sysinternal's Config for the individual file deframentation: http://www.microsoft.com/technet/sysinternals/FileAndDisk/Contig.mspx
     
  7. 2007/01/05
    marty

    marty Inactive Thread Starter

    Joined:
    2002/01/20
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    106
    Location:
    Woodstock NY
    Computer Experience:
    experienced
    Thanks Bill, I'll check it out.
     

Share This Page