List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:January 24 2012 5:02am
Subject:Re: MYD, MYI and TMD files
View as plain text  
I couldn't say.  I have not had particularly good luck doing MyISAM repairs.

 - md

On Mon, Jan 23, 2012 at 11:49 PM, kalin m <kalin@stripped> wrote:
>
> ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD file
> is about half the MYD/MYI file. although MYI is about a gig smaller than
> the MYD. which one has the TDM to reach in size in order for the repair
> to be complete?
>
> thanks.
>
>
> On 1/23/12 11:27 PM, Michael Dykman wrote:
>> This is still the list although more quiet than it used to be.
>>
>> Repairing a table is already a fragile process..  I would not try to
>> interrupt it if the data has no backup.
>>
>>  - michael dykman
>>
>> On Mon, Jan 23, 2012 at 11:04 PM, kalin m <kalin@stripped> wrote:
>>>
>>>
>>> hey. this list used to be pretty active. did anything change? is there
>>> another place to ask questions like these?
>>>
>>> thanks...
>>>
>>>
>>> On 1/23/12 5:02 PM, kalin m wrote:
>>>>
>>>>
>>>> hi all..
>>>>
>>>> i started a repair on a table that has an MYD file of 9.2 gigs. the MYI
>>>> file is 7.7 gigs. the TMD file, which i'm assuming is a temporary file
>>>> used in the repair process, is currently 400mb. this has been going on
>>>> for about 30 min now. the question is does the TMD file need to get
>>>> anywhere near the size of any of this MYD or MYI files in order to get
>>>> this repair done?! and if so why is it so slow?
>>>>
>>>> i'm not really planning to stop the repair command cause i read
>>>> somewhere that this might not be a good idea. can i stop it without
>>>> risking any data loss or table damage?
>>>>
>>>> thanks...
>>>>
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:    http://lists.mysql.com/mysql
>>>
>>
>>
>>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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