To use the partition function PARTITION BY RANGE/LIST (TO_DAYS(a_date_field))
will have a very good effect on the optimizer since it will then know that it can apply
range optimisations.
A new feature recently added to 5.1 is the ability to create SQL events. So you could
define an event that on a daily basis adds a new partition and if you want other
regular activities for dropping and reorganizing your partitions that can be done as well.
Check the new devzone article on this:
http://dev.mysql.com/tech-resources/articles/event-feature.html
Rgrds Mikael
Jason Lewis wrote:
> Partitioning by day was what I was looking for
> initially, and I could manually do it a couple of
> ways. Since all my dates are already Unix time, i
> figured that would make it easy on me during
> INSERTS.
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com