MySQL Forums
Forum List  »  Partitioning

Re: How can I decide which partition type can I chose
Posted by: Rick James
Date: September 12, 2010 03:11PM

"If I had to partition the table, what would be the best option." -- Do not partition a table without a goal in mind.

Two common goals:

* time series, where you want to delete old data

* performance -- for this we need to see all the relevant SELECTs, plus the table structure (pre-partitioned is ok).

There are many ways you _could_ partition the table; most do not provide any benefit.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How can I decide which partition type can I chose
1525
September 12, 2010 03:11PM


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.