MySQL Forums
Forum List  »  MyISAM

Re: Optimize Table Taking Forever
Posted by: Rick James
Date: May 01, 2012 10:14AM

I guess you are stuck with waiting.

.frm, .MYD, .MYI are the normal files for a MyISAM table
.TMD is the temp
.BAK sounds like something you did.

> old version (5.1.55)
That is not terribly old.

> switch the tables to innodb as this would hopefully reduce problems like this
ALTER TABLE is still an issue with InnoDB. But hopefully it would not be that painful. Switching is a good idea in general. An it _may_ help with this problem. Recommend innodb_file_per_table.

Caution: InnoDB will take up 2x-3x the disk space.

See this for subtle changes you might need in indexes, etc:
http://mysql.rjweb.org/doc.php/myisam2innodb

Options: ReplyQuote


Subject
Views
Written By
Posted
16387
April 27, 2012 03:03AM
8391
April 30, 2012 12:32AM
Re: Optimize Table Taking Forever
5209
May 01, 2012 10:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.