MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
When can we have range partitioning to_hour?
4601
Michael Gargiullo
September 28, 2006 09:42AM
Re: When can we have range partitioning to_hour?
2491
Michael Gargiullo
September 28, 2006 10:13AM
Re: When can we have range partitioning to_hour?
2896
Peter Gulutzan
September 28, 2006 03:12PM


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.