mysql分区问题

本帖最后由 johnjobe123 于 2011-07-20 15:21 编辑

mysql edition  5.5
    由于项目的需要，我们要创建比较多的分区（差不多要有20000个吧），但是通过查看文档，发现其最多可以支持1024（加上子分区）各分区，
是不是可以调整，怎么调整，请高手指点。。。。



附文档关于分区个数的内容：

Maximum number of partitions.  The maximum possible number of partitions for a given table is 1024. This includes subpartitions.

If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got error ... from storage engine: Out of resources when opening file, you may be able to address the issue by increasing the value of the open_files_limit system variable. However, this is dependent on the operating system, and may not be possible or advisable on all platforms; see Section C.5.2.18, “'File' Not Found and Similar Errors”, for more information. In some cases, using large numbers (hundreds) of partitions may also not be advisable due to other concerns, so using more partitions does not automatically lead to better results.

Waiting for you answer !!! Thank you !