MySQL Forums
Forum List  »  Partitioning

Re: Partitioning Details
Posted by: Mikael Ronström
Date: June 21, 2005 08:49AM


Steven Roussey wrote:
> 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.

This is the goal of the optimisations to be done on the partitioning part.
However not sure exactly at which time it will be implemented. But I'll
keep an eye on it.

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

Thx for the input and welcome with more input.

Rgrds Mikael

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:

Options: ReplyQuote

Written By
June 17, 2005 02:03PM
June 18, 2005 02:04AM
June 20, 2005 08:33PM
Re: Partitioning Details
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.