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.

Options: ReplyQuote

Written By
Update and pruning
November 12, 2006 08:48AM
November 13, 2006 02:13PM
November 14, 2006 08:47AM
November 14, 2006 07:09PM
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.