MySQL分区最大数量

Maximum number of partitions.  

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.

来自:http://dba86.com/docs/mysql/5.6/partitioning.html#partitioning-limitations

--鸽子--