MySQL Forums
Forum List  »  Partitioning

Re: How to handle secondary keys in partitioning?
Posted by: Mattias Jonsson
Date: May 09, 2010 04:37AM

Moving pruning before open and lock is in my plan, and I will probably start with
https://intranet.mysql.com/worklog/Server-RawIdeaBin/?tid=5217 (i.e. explicit pruning in FROM clause) and also allow pruning on INSERT/UPDATE/DELETE.

When that is done it should be possible to extend the current automatic pruning to be done before open/lock and as well include support for insert/update/delete.

The worklog for fixing bug#37252 is either:
http://forge.mysql.com/worklog/task.php?id=3513 (which is not really correct description, since there are only one .frm file per table.)
or
https://intranet.mysql.com/worklog/Server-RawIdeaBin/?tid=4443 (which had 'delayed' locking in mind.)

So yes, it is in the plans, but I can not give any estimate when it is completed, but since it is new development, it will probably not be a part of 5.5.

Options: ReplyQuote




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.