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