MySQL Forums
Forum List  »  Partitioning

Re: Partitioning Details
Posted by: Steven Roussey
Date: June 20, 2005 08:33PM

As far as the table type, I was talking aoubt MyISAM. I would hope that if an update was happening on a primary key and the PK was the source of how the partitions are done, that MySQL would be able to lock just that partition (automatically, since it knows that only that one partition is affected). I'm generally thinking of the specific case where there is only one partition involved. If several are involved in an update, then a complete table lock is fine.

As for maintenance, yes, being able to specify which partition is very important.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
3702
June 17, 2005 02:03PM
2876
June 18, 2005 02:04AM
Re: Partitioning Details
2414
June 20, 2005 08:33PM
2562
June 21, 2005 08:49AM


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.