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.
Subject
Views
Written By
Posted
2667
March 26, 2013 06:41AM
Re: Performance doubt
1473
March 28, 2013 12:34AM
1147
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.