MySQL Forums
Forum List  »  Partitioning

Re: timestamp, datetime as default value as current_timestamp [PARTITION]
Posted by: Aftab Khan
Date: August 29, 2012 09:16AM

>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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: timestamp, datetime as default value as current_timestamp [PARTITION]
1964
August 29, 2012 09:16AM


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.