MySQL Forums
Forum List  »  Partitioning

Re: timestamp, datetime as default value as current_timestamp [PARTITION]
Posted by: Mannoj Kumar
Date: September 07, 2012 05:49AM

Well. I have decided to wait until 5.6.6 < features come to general availability. As the need which I came initially is to get timestamp datatype in a database default value as CURRENT_TIMESTAMP which is available on 5.6.6 also partitioning pruning on locks commences on this version M9, but its not gona be a much pain for partition sizes as I'm going to retain latest 6months records on the actual partitioned table by month wise. And rotate the table everymonth keeping latest six partitions on the table and rest moving out to another split by table_dd_mm_yyyy wise. Until then let me ask application team to go for stress test with DB on this version to find any bottlenecks or backward compatibility issues.



Edited 2 time(s). Last edit at 09/07/2012 06:08AM by Mannoj Kumar.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: timestamp, datetime as default value as current_timestamp [PARTITION]
1513
September 07, 2012 05:49AM


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.