MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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

MySQL Dev Zone
MySQL Server Documentation
Oracle

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Impact of larger partition number on database performance
4616
Kamal Joshi
April 04, 2007 07:36AM
Re: Impact of larger partition number on database performance
2821
Mikael Ronström
May 31, 2007 01:15AM
Re: Impact of larger partition number on database performance
2765
Niko Sten
June 06, 2007 05:52AM
Re: Impact of larger partition number on database performance
2629
Jonathan Stephens
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.