Re: MYD, MYI and TMD files
- Original Message - > From: "kalin m" > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MYD, MYI and TMD files
thanks. it took about 15 hrs. but right now everything seems ok. does the check last as long as the repair? On 1/24/12 3:51 AM, Johan De Meersman wrote: > - Original Message - >> From: "kalin m" >> >> 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? > > The MYI file contains only indices, which are pretty much disposable. The MYD > contains the actual data, and is what myisamcheck will be reading in order to > salvage as much data as possible. It will basically try to copy every record > into the temp file, then switch out the files and do a full reindexing run. > It's not a bad idea to have a copy of your original MYD file, just in case > the repair doesn't quite yield what you'd hoped. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MYD, MYI and TMD files
- Original Message - > From: "kalin m" > > 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? The MYI file contains only indices, which are pretty much disposable. The MYD contains the actual data, and is what myisamcheck will be reading in order to salvage as much data as possible. It will basically try to copy every record into the temp file, then switch out the files and do a full reindexing run. It's not a bad idea to have a copy of your original MYD file, just in case the repair doesn't quite yield what you'd hoped. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MYD, MYI and TMD files
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 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 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 - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MYD, MYI and TMD files
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 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 >> > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MYD, MYI and TMD files
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 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 - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MYD, MYI and TMD files
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