Maximum number of partitions.
MySQL :: MySQL 8.0 Reference Manual :: 23.6 Restrictions and Limitations on Partitioning /doc/refman/8.0/en/partitioning-limitations.html
最大文件打开数
Maximum number of partitions.The maximum possible number of partitions for a given table not using theNDBstorage engine is 8192. This number includes subpartitions.
The maximum possible number of user-defined partitions for a table using theNDBstorage engine is determined according to the version of the NDB Cluster software being used, the number of data nodes, and other factors. SeeNDB and user-defined partitioning, for more information.
If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such asGot error ... from storage engine: Out of resources when opening file, you may be able to address the issue by increasing the value of theopen_files_limitsystem variable. However, this is dependent on the operating system, and may not be possible or advisable on all platforms; seeSectionB.6.2.17, “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.