MySQL Forums
Forum List  »  Partitioning

partition + disabled keys stills not working
Posted by: Ezequiel Guilleron
Date: June 27, 2007 05:41PM

Hi,
While importing millions of records on a MYSAIM table, I usually use the "ALTER TABLE t DISABLE KEYS / ALTER TABLE t ENABLE KEYS" in order to have better load speed. I have try using the same thing on a tables partitioned but it does nothing, the status says OK, but all index are rebuild during each insert on LOAD DATA ....

however I found a workaround on myisam doing something like this:

myisamchk --keys-used=0 -rq /db/data/d/t#P#pX

replace the X for each partition...

tested on: 5.1.19-beta-log Source distribution

There are one BUG report that says after 5.1.11 it should work, but at least for me it does not work.

http://bugs.mysql.com/bug.php?id=19502

is there anyone experimenting this behavior too?

Options: ReplyQuote


Subject
Views
Written By
Posted
partition + disabled keys stills not working
3767
June 27, 2007 05:41PM


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.