MySQL Forums
Forum List  »  Partitioning

Update and pruning
Posted by: Jens Tandstad
Date: November 12, 2006 08:48AM

I have a very straightforward question:
I have table partitioned by parentID. If I change the parentID and the new parentID requires the row to be moved to a different partition. Does this happen automatically if i use the SQL below?

UPDATE person.parentID = 22 where parentID = 10;

Does the system identify if the row is now in violation with the partition it is currently in, and move it? If yes, is the previous partition reordered (defragmented) or is there an empty row in it? And is there a defragmentation function for this kind of situtation that can be scheduled for running during the night. I have a system where that requires fast access to data (pruning helps) but it also requires a great deal of updating.

I am grateful for any help.
Regards
Jens

Options: ReplyQuote


Subject
Views
Written By
Posted
Update and pruning
3230
November 12, 2006 08:48AM
2147
November 13, 2006 02:13PM
2164
November 14, 2006 08:47AM
2033
November 14, 2006 07:09PM
2065
November 18, 2006 01:02PM


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.