MySQL Forums
Forum List  »  Partitioning

Re: selecting partition
Posted by: Mikael Ronström
Date: March 28, 2006 03:58AM

Hi,

janota.m wrote:
> I have the following problem:
> I have partitioned table by range (unix_time)
> Every day I'd like to create new partition, then
> backup the oldest partition and drop it.
>

This is possible but you need to know the range you
used for the oldest partition and use this in the backup
query. You also need to know the name of the last
partition to drop it.


> Is this too complicated? How can I select the
> oldest partition without remembering unix_time
> value?
> Is there any way how to select a particular
> partition?

No, one uses a WHERE clause that covers the range
for the partition.

Rgrds Mikael

> Thanks for any sugestions.

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2787
March 23, 2006 06:19AM
Re: selecting partition
2179
March 28, 2006 03:58AM
2202
March 28, 2006 11:44AM


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.