MySQL Forums
Forum List  »  Partitioning

Re: Fortnight partitions
Posted by: Rick James
Date: November 21, 2012 08:54PM

I have no experience with PARTITION BY LIST. Suggest you experiment with a small table. Do EXPLAIN PARTITIONS SELECT... to verify that partition pruning actually works for your queries. (Otherwise, the SELECTs may be slowed down rather than sped up.)

`part_id` seems feasible.

DROP PARTITION is "instantaneous". DELETEing the rows from a large partition is painfully slow.

Options: ReplyQuote


Subject
Views
Written By
Posted
3343
November 19, 2012 11:24PM
2024
November 20, 2012 10:56PM
1319
November 20, 2012 11:23PM
Re: Fortnight partitions
1455
November 21, 2012 08:54PM
1424
November 23, 2012 12:04AM


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.