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

[Aftab Khan]

>KEY `PriorityIndex` (`status`,`priority`,`keyvendor`),
>KEY `NewIndex1` (`keyvendor`,`status`),

Doesn't look good. Can we see 'SELECTs' that you intend to run against this table? So that we can review indexes. Also, can you provide SHOW KEYS FROM contentq_par?

>As it seeds records almost 5hundered thousands perday and peak time goes to 8 transactions per second on that table

Did you run benchmarks with and without table partitioning?

In 5.5 you can also use RANGE COLUMNS partitioning without TO_DAYS():
PARTITION BY RANGE COLUMNS (recorddate)

>show table status
Is it from PROD database?

-> `message` text,
-> `udh` text,
-> `callback_url` text,
What's the average length of these columns?