在mysql5.5中关于分区表最大数量的描述如下：
Maximum number of partitions. The maximum possible number of partitions for a given table (that does not use the NDB storage engine) is 1024. This number includes subpartitions.
讨教下大家有没有办法提高这个1024的值。不考虑换更高版本的数据库，例如在mysql5.6的文档里面有描述：
Maximum number of partitions. The maximum possible number of partitions for a given table not using the NDB storage engine is 8192. This number includes subpartitions.
Maximum number of partitions. The maximum possible number of partitions for a given table (that does not use the NDB storage engine) is 1024. This number includes subpartitions.
讨教下大家有没有办法提高这个1024的值。不考虑换更高版本的数据库，例如在mysql5.6的文档里面有描述：
Maximum number of partitions. The maximum possible number of partitions for a given table not using the NDB storage engine is 8192. This number includes subpartitions.
解决方案
100
升级应该是最简单的方法。
CodeBye 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明大家有没有遇到过mysql5.5中表的分区数量超过1024的问题！