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?