MySQL Forums
Forum List  »  Partitioning

Re: Building Indexes across partitioned tables longer each day
Posted by: Mattias Jonsson
Date: December 22, 2009 02:48AM

Could you elaborate a bit further?

What does date_id stand for? (is it a new partition for each day, or adding to previous data)

If you test to load data to a non partitioned myisam table (only what would go into a specific partition) do you get the same result?

How do you 'load'? (small inserts updates the index, large disables indexex, inserts and then rebuilds them and enables them again).

If you are appending data to a partition (or table) it will take longer and longer to update/generate the index, since it is increasing in size.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Building Indexes across partitioned tables longer each day
2358
December 22, 2009 02:48AM


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.