MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Pruning by month
Posted by: John Powell
Date: February 12, 2009 08:42AM

There are several posts that explain how to use the to_days function on a datetime field, for example.
http://dev.mysql.com/tech-resources/articles/testing-partitions-large-db.htm
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitioning_with_dates.html

There is also a handy perl script which will generate the partiion values for you at http://forge.mysql.com/wiki/Partition_Helper

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Pruning by month
10190
Alan Griffiths
October 23, 2008 04:56AM
Re: Pruning by month
4394
Michael Taggart
October 23, 2008 06:12PM
Re: Pruning by month
4645
Michael Taggart
October 23, 2008 06:17PM
Re: Pruning by month
4329
Michael Taggart
October 23, 2008 06:46PM
Re: Pruning by month
4264
Michael Taggart
October 23, 2008 07:21PM
Re: Pruning by month
4058
Alan Griffiths
October 25, 2008 06:42PM
Re: Pruning by month
3922
John Powell
February 12, 2009 08:42AM


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.