Re: Corrupt ISAM table
Thanks, I'll try that! Robert On Tue, 2003-01-14 at 14:54, Dyego Souza do Carmo wrote: > Dobrý den, > terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste: > > RC> I'm new to administering MySQL, so bear with me: > > RC> We run a large MySQL database with one of the tables amassing > RC> over 40 million entries. It somehow got corrupt and now I'm > RC> running isamchk -o (-r failed) and it's in its 110th hour and > RC> it's getting slower. I'm running 3.23.38 and cannot upgrade > RC> due to compatibility issues. Also, the tables are quite old > RC> and are in ISAM format. Here's a couple of questions: > > RC> Will stopping the repair midway affect the data/table? > > Upgrade to 3.23.54 ( 3.23.54 is compatible with 3.23.38 ) > > RC> Can I convert a corrupted table to MyISAM? > > yes... run the command: ALTER TABLE table_name Type=MyISAM; > the mysql atomically creates a MyISAM table and new index to the table > > RC> How will that affect my data? > Your data in MyISAM is more safe than ISAM > > RC> Will myisamchk run faster in fixing the corruption (in general, > RC> I know there's not enough information)? > more less. > > Upgrade your mysql to 3.23.54 ( max ) and use the InnoDB tables ( > http://www.innodb.com ), this table type is VERY SECURE than MyISAM. > The InnoDB tables are stored in a tablespace and have a "crash > recovery". To convert your tables from ISAM to Innodb is simple. > > 1 - Configure the InnoDB options em my.cnf > 2 - run ALTER TABLE table_name Type=InnoDB; > > and have fun ! ;) > > ps: ISAM support is deprecated and is not present in next version of > mysql ( 4.x ) > > sql,query > > - > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > - > E S C R I B A I N F O R M A T I C A > - > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > -- > $ look into "my eyes" > look: cannot open my eyes > - >Reply: [EMAIL PROTECTED] > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Corrupt ISAM table
Dobrý den, terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste: RC> I'm new to administering MySQL, so bear with me: RC> We run a large MySQL database with one of the tables amassing RC> over 40 million entries. It somehow got corrupt and now I'm RC> running isamchk -o (-r failed) and it's in its 110th hour and RC> it's getting slower. I'm running 3.23.38 and cannot upgrade RC> due to compatibility issues. Also, the tables are quite old RC> and are in ISAM format. Here's a couple of questions: RC> Will stopping the repair midway affect the data/table? Upgrade to 3.23.54 ( 3.23.54 is compatible with 3.23.38 ) RC> Can I convert a corrupted table to MyISAM? yes... run the command: ALTER TABLE table_name Type=MyISAM; the mysql atomically creates a MyISAM table and new index to the table RC> How will that affect my data? Your data in MyISAM is more safe than ISAM RC> Will myisamchk run faster in fixing the corruption (in general, RC> I know there's not enough information)? more less. Upgrade your mysql to 3.23.54 ( max ) and use the InnoDB tables ( http://www.innodb.com ), this table type is VERY SECURE than MyISAM. The InnoDB tables are stored in a tablespace and have a "crash recovery". To convert your tables from ISAM to Innodb is simple. 1 - Configure the InnoDB options em my.cnf 2 - run ALTER TABLE table_name Type=InnoDB; and have fun ! ;) ps: ISAM support is deprecated and is not present in next version of mysql ( 4.x ) sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" look: cannot open my eyes - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Corrupt ISAM table
I'm new to administering MySQL, so bear with me: We run a large MySQL database with one of the tables amassing over 40 million entries. It somehow got corrupt and now I'm running isamchk -o (-r failed) and it's in its 110th hour and it's getting slower. I'm running 3.23.38 and cannot upgrade due to compatibility issues. Also, the tables are quite old and are in ISAM format. Here's a couple of questions: Will stopping the repair midway affect the data/table? Can I convert a corrupted table to MyISAM? How will that affect my data? Will myisamchk run faster in fixing the corruption (in general, I know there's not enough information)? Any help would be greatly appreciated! Robert Cantu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
