MySQL Forums :: Partitioning :: Range partition and unique key


Advanced Search

Re: Range partition and unique key
Posted by: Rick James ()
Date: September 27, 2014 08:25AM

> And partitionning is recommended in this situation...

That is not enough justification. To be blunt, I suggest that the person/book recommending PARTITIONing is wrong. Or did the recommendation include some qualifiers that you have not mentioned yet?

Since you are not DELETEing "old" rows, the primary use of PARTITIONing is unnecessary -- DROP PARTITION is much faster than DELETEing lots of rows.

You have not mentioned what the SELECTs are like -- a few (very few) SELECTs will benefit from PARTITIONing. Let's discuss your SELECTs and see if any of them could benefit. In doing so, I will need to see SHOW CREATE TABLE (assuming you left out some of the fields).

> I'm using MyIsam because I make only insert and select in db and have many entries so have better performance with MyIsam engine...

* Have you verified that performance is better with MyISAM? It used to be -- a decade ago.
* Has the system ever crashed -- leaving that MyISAM table in need of a multi-hour REPAIR TABLE? (InnoDB is self repairing and much faster.)

Options: ReplyQuote


Subject Views Written By Posted
Range partition and unique key 1870 Pierrick VODOZ 09/24/2014 08:42AM
Re: Range partition and unique key 957 Rick James 09/25/2014 09:59AM
Re: Range partition and unique key 990 Pierrick VODOZ 09/26/2014 03:40AM
Re: Range partition and unique key 1034 Rick James 09/27/2014 08:25AM


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.