MySQL Forums
Forum List  »  Partitioning

Re: Query to a partitioned table using all partitions
Posted by: Rick James
Date: November 12, 2016 05:55PM

PARTITIONing has a lot of bells and whistles, most of them do not provide any performance benefit. You found one of them.

Instead, do
PARTITION BY RANGE(TO_DAYS(EventTime))
and then plan on dealing with a sliding set of partitions. This necessitates doing DROP PARTITION and REORGANIZE PARTITION. More details: http://mysql.rjweb.org/doc.php/partitionmaint

If you would like to show us the main queries, I will critique the indexes you have. (There can be subtle issues with indexing with partitioning.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query to a partitioned table using all partitions
290
November 12, 2016 05:55PM


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.