MySQL Forums
Forum List  »  Partitioning

Row movement for MySQL partitionned tables
Posted by: jongse park
Date: October 10, 2012 11:14PM

I am currently considering partitionning tables on my company's application and i was unable to find anywhere in the documentation anything about row movement.

How does MySQL partitionned tables handle updates on records that would move the record from one partition to another?

Exemple : table1 is a InnoDB table partitionned on the value of col1 which is an integer value.

The value of col1 for each record of table one will increase from 0 to 6 at different point of the time through UPDATE queries.
What happends when a record is updated to have its col1 value change from 0 to 1 ? Does it trigger an error? Does MySQL delete the record from p0 and inserts a new one into p1?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Row movement for MySQL partitionned tables
3051
October 10, 2012 11:14PM


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.