List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:January 27 2012 11:00am
Subject:Re: MYD, MYI and TMD files
View as plain text  
----- Original Message -----
> From: "kalin m" <kalin@stripped>
> 
> thanks. it took about 15 hrs. but right now everything seems ok. does
> the check last as long as the repair?

No, a check (myisamcheck -c or "check table" in sql) is a read operation that verifies
structures, pointers and such but makes no changes.

A repair (myisamcheck -r or "repair table" in sql) will both run a check, and if errors
are found, will make a copy of the table with the data it manages to salvage. That means
both reading and writing roughly the same amount of data that is in your table already,
and on the same disk to boot - that's what takes so long :-)

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
MYD, MYI and TMD fileskalin m23 Jan
  • Re: MYD, MYI and TMD fileskalin m24 Jan
    • Re: MYD, MYI and TMD filesMichael Dykman24 Jan
      • Re: MYD, MYI and TMD fileskalin m24 Jan
        • Re: MYD, MYI and TMD filesMichael Dykman24 Jan
        • Re: MYD, MYI and TMD filesJohan De Meersman24 Jan
          • Re: MYD, MYI and TMD fileskalin m26 Jan
            • Re: MYD, MYI and TMD filesJohan De Meersman27 Jan