MySQL Forums :: Partitioning :: Query to a partitioned table using all partitions


Advanced Search

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
Query to a partitioned table using all partitions 453 Raghupradeep Aravindakshan 11/06/2016 11:22PM
Re: Query to a partitioned table using all partitions 250 Rick James 11/12/2016 05:55PM
Re: Query to a partitioned table using all partitions 233 Raghupradeep Aravindakshan 11/18/2016 03:16AM
Re: Query to a partitioned table using all partitions 194 Rick James 11/19/2016 03:42PM


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.