MySQL Forums
Forum List  »  Partitioning

indexing on partitioned table after load file not working?
Posted by: mark devaney
Date: May 13, 2009 08:38AM

We have a 700M+ row table "list" partitioned by one column. We do an initial bulk
load with indexing turned off:

alter table disable keys;
load data infile ....
alter table enable keys;

Then we incrementally add a new partition and load data into it:
alter table ... add partition (partition np) values in (x);
load data local infile ....

The newly-loaded data only goes into the newly-created partition.

The problem is that the new partitions are not indexed even though indexing has been re-enabled. The .MYI files on those subsequently-added partitions are 1/2 the size of the partitions added prior to re-enabling keys. Selecting from the new partitions is 10x slower than the earlier partitions so indexing is definitely not working as all the partitions are of the same size and have the same key distributions.

Has anyone else seen this behavior?

Thank you.

Options: ReplyQuote

Written By
indexing on partitioned table after load file not working?
May 13, 2009 08:38AM

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.