MySQL Forums
Forum List  »  Partitioning

Re: Performance doubt
Posted by: Rick James
Date: March 28, 2013 12:34AM

> Will this extra partitions slow down the queries of affect any other processes?

Yes! ALL partitions are opened for many operations, even before partition 'pruning' takes place. (This is a 'bug'; 5.6 improves on it. Mattias, if you are listening, can you clarify how far 5.6 improved it?)

Use RANGE partitioning.

> Cons: We'll have to add a new partition set every time we approach the last yearmonth.

Yes, it is a nuisance. Here's advice, discussion, and code:
http://mysql.rjweb.org/doc.php/partitionmaint

If you already have a DATE or DATETIME field, there is no need to create the extra yearmonth field just for PARTITIONing.

Options: ReplyQuote


Subject
Views
Written By
Posted
2300
March 26, 2013 06:41AM
Re: Performance doubt
1265
March 28, 2013 12:34AM
939
April 09, 2013 01:49AM


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.