MySQL Forums :: Partitioning :: timestamp, datetime as default value as current_timestamp [PARTITION]


Advanced Search

timestamp, datetime as default value as current_timestamp [PARTITION]
Posted by: Mannoj Kumar ()
Date: August 29, 2012 01:21AM

I have a table column called 'recorddate' where it has timestamp datatype to default CURRENT_TIMESTAMP. Now I have few questions regarding maintenance part.

I should partition this table keeping recorddate as rangekey. But now it wouldn't allow partition key for timezone-dependent expressions in (sub)partitioning function.

If I change the timestamp datatype to datetime for recorddate the partition is created but it won't allow default CURRENT_TIMESTAMP database level.

2.1 . When I see forums stating MySQL 5.6.5 has datetime datatype can have CURRENT_TIMESTAMP, now(). Would it allow rangebykey for partition ? [Another thought that clings on my head is, would it be good to pick a distribution that is still under developement]

Any suggestions or work around, I really don't like the concept of triggers having to be on recordate upon insert if null. As it seeds records almost 5hundered thousands perday and peak time goes to 8 transactions per second on that table. That is the intent of falling on to partitions.

Thanks in advance!! Mannoj

Options: ReplyQuote


Subject Views Written By Posted
timestamp, datetime as default value as current_timestamp [PARTITION] 3159 Mannoj Kumar 08/29/2012 01:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1435 Aftab Khan 08/29/2012 04:21AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 2298 Mannoj Kumar 08/29/2012 04:32AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1294 Aftab Khan 08/29/2012 09:16AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1166 Rick James 08/30/2012 10:35PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1281 Aftab Khan 08/31/2012 01:58AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1147 Aftab Khan 08/31/2012 02:04AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1274 Rick James 08/31/2012 09:52AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1251 Mattias Jonsson 09/05/2012 12:36AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1186 Rick James 09/05/2012 08:29AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1201 Mannoj Kumar 09/03/2012 11:26PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1420 Rick James 09/04/2012 08:05PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1359 Mannoj Kumar 09/07/2012 05:49AM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1309 Mattias Jonsson 08/31/2012 06:00PM
Re: timestamp, datetime as default value as current_timestamp [PARTITION] 1110 Aftab Khan 09/03/2012 03:19AM


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.