MySQL Forums
Forum List  »  Partitioning

Re: Impact of larger partition number on database performance
Posted by: Jonathan Stephens
Date: June 14, 2007 03:42PM

> Is there upper limit for number of partitions?

"The maximum number of partitions possible for a given table is 1024. This includes subpartitions." http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Impact of larger partition number on database performance
2488
June 14, 2007 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.