MySQL Forums
Forum List  »  Partitioning

Re: Reasonable number of partitions?
Posted by: Barry Boes
Date: September 20, 2007 08:36PM

Why not take advantage of InnoDB's primary key based on-disk ordering to help this performance? If you start the PK with the account# then the data will physically order itself into "partitions" on disk.

Options: ReplyQuote


Subject
Views
Written By
Posted
6656
March 08, 2007 10:09AM
4953
March 14, 2007 12:34PM
Re: Reasonable number of partitions?
3631
September 20, 2007 08:36PM
3421
September 12, 2007 11:26AM


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.