MySQL Forums
Forum List  »  Partitioning

Re: Partitioning by year and day
Posted by: Rick James
Date: June 17, 2011 09:34AM

> This still leaves me with the problem of having to change the table I'm selecting from.
You do nothing to pick which partition to INSERT/SELECT -- record_date, if present, controls which subtable. If missing, all partitions will be looked at.

A daily script to create a new partition and DROP the oldest partition is required, but not provided.

How many rows in this table? If less than a million, do not bother with PARTITIONing.

If you are hitting the 1024 limit, consider partitioning by week, not day.

Options: ReplyQuote

Written By
June 16, 2011 01:52AM
Re: Partitioning by year and day
June 17, 2011 09:34AM
June 17, 2011 09:48AM

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.