MySQL Forums
Forum List  »  Partitioning

Re: Rolling partitions
Posted by: Rick James
Date: March 31, 2012 11:22AM

Alas, there is no one-size-fits-all PARTITION maintenance script.

If you would like to show us SHOW CREATE TABLE and
SELECT  PARTITION_NAME name, PARTITION_ORDINAL_POSITION ord,
        PARTITION_DESCRIPTION ltval, TABLE_ROWS,
        DATA_LENGTH, INDEX_LENGTH, DATA_FREE
    FROM  PARTITIONS
    WHERE  TABLE_SCHEMA = '...'  -- fill these in
      AND  TABLE_NAME = '...';
then we could advise you more specifically.

Also describe the pattern you desire in the PARTITION changes (daily?/etc?)



Edited 1 time(s). Last edit at 03/31/2012 01:47PM by Rick James.

Options: ReplyQuote


Subject
Views
Written By
Posted
2628
March 29, 2012 02:19AM
Re: Rolling partitions
1536
March 31, 2012 11:22AM


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.