MySQL Forums
Forum List  »  Partitioning

Re: Am I doing this correctly?
Posted by: Rick James
Date: November 30, 2013 02:18PM

> Why did I have to add my field 'CreationDate' to the unique key?

Otherwise, it would have to check _all_ partitions whenever you insert a row. (This is to check the UNIQUEness.)

While your PARTITION+SUBPARTITION syntax may be correct, I see no use for it. What do you hope to achieve?...

Performance on INSERT? INSERTs are slowed down by PARTITIONing, especially with so many partitions?

Performance on SELECT? Let's see your SELECT(s). I suspect they will not benefit.

Purging old data? If you will do DROP PARTITION, then this is a big benefit.

Options: ReplyQuote


Subject
Views
Written By
Posted
2286
November 29, 2013 05:03AM
1310
November 29, 2013 06:22AM
Re: Am I doing this correctly?
1421
November 30, 2013 02:18PM
1219
December 04, 2013 12:38AM
1264
December 05, 2013 03:48AM
1319
December 05, 2013 10:21AM
1246
December 10, 2013 09:49AM
1290
December 05, 2013 03:51AM


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.