MySQL Forums
Forum List  »  Partitioning

Re: When can we have range partitioning to_hour?
Posted by: Michael Gargiullo
Date: September 28, 2006 10:13AM

Someone had suggested, dropping the indexes (ALTER TABLE LogsFirewall DISABLE KEYS) load the bulk file then enable the keys again (ALTER TABLE LogsFirewall ENABLE KEYS)... Yeah 22 minutes with dealing with keys while loading. We're currently at 26 Minutes and counting trying to drop keys, load, then build keys... I guess we'll skip that.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: When can we have range partitioning to_hour?
2372
September 28, 2006 10:13AM


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.