MySQL Forums
Forum List  »  MyISAM

Re: Importing dump of huge table takes forever since 5.6.15
Posted by: Rick James
Date: January 12, 2014 05:00PM

You really should be switching to InnoDB from MyISAM.

The xx.MYI file contains the index(es) for the MyISAM table xx. ENABLE KEYS rebuilds the keys from scratch, which is likely to be more efficient that building them while inserting the rows.

The more INDEXes you have, the longer the rebuild will take. Let's see SHOW CREATE TABLE; we may be able to advise you on removing some redundant or unuseful indexes.

If you do a SHOW PROCESSLIST during the rebuild, it will say either (something like)
Reindexing by keycache, or
Reindexing by sort
The latter is likely to be the case, and likely to be faster (for big tables). If it is using the keycache, let's look at your settings (SHOW VARIABLES) to see what might need changing.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Importing dump of huge table takes forever since 5.6.15
1464
January 12, 2014 05:00PM


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.