CODEWITHSUNDEEP
mysqlmysql-5.6
roger moore
roger moore

Reputation: 571

Maximum number of partitions in a table MYSQL 5.6.10

I am looking to do a range partition on one of my tables, this would be range partition. I was wondering what are the maximum number of partitions we can have in a table. I am running MYSQL 5.6.10.

Ideally I am looking to create around 8000 partitions. Also can someone advise that if so many partitions will effect performance or some way hurt database. I am also using innodb_file_per_table=ON

Thanks

Upvotes: 2

Views: 4557

Answers (1)

Quassnoi
Quassnoi

Reputation: 425713

From the docs:

Prior to MySQL 5.6.7, the maximum possible number of partitions for a given table not using the NDB storage engine was 1024. Beginning with MySQL 5.6.7, this limit is increased to 8192 partitions. Regardless of the MySQL Server version, this maximum includes subpartitions.

Upvotes: 5

Related Questions