MySQL Forums
Forum List  »  Partitioning

Re: copy of SAP COPA
Posted by: Phil Hildebrand
Date: March 24, 2008 07:42AM

It makes sense if the majority of your queries for reporting include period so that the optimizer can take advantage of partition pruning. If this is the case, then, yes, it should improve performance. You should verify that the optimizer is able to do partition pruning by using explain partition with a set of your typical reporting queries against the table.

If you never delete rows, but data from older periods becomes less relevant over time, then you should consider creating larger partitions for older periods (say, quarterly or yearly), assuming you are using range partitions - this will help with the number of partitions needed over time.

I don't believe that MySQL currently processes partitions in parallel when it's scanning for matches in multiple partitions, but I'm not positive.

Options: ReplyQuote


Subject
Views
Written By
Posted
6585
March 24, 2008 02:06AM
Re: copy of SAP COPA
2673
March 24, 2008 07:42AM
2846
March 24, 2008 10:12AM


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.