Re: timestamp, datetime as default value as current_timestamp [PARTITION]

[Aftab Khan]

Please provide SHOW CREATE TABLE and SHOW TABLE STATUS info.
Note: MySQL 5.6 is not production ready but you are welcome to use it in your test environment.
What MySQL version are you using now? 5.5?
>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.

Do do single inserts or batch insert? Inserting single rows in partitions is slow. Whenever you insert a record, the partitioning engine locks the entire table (all-partitions), the partitioning engine will lock all partitions before the insert, and unlock them after the insert.

How many partitions do you intent to use? Partitioning performance drops drastically with hundreds of partitions,
http://bugs.mysql.com/bug.php?id=37252

Do you purge historic data from the table in question?

Please provide SELECTs that you run against the table.