Re: Building Indexes across partitioned tables longer each day

[Mattias Jonsson]

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.