All Products
Search
Document Center

ApsaraDB RDS:Table partitioning limits for RDS for MySQL

Last Updated:Apr 02, 2025

ApsaraDB RDS for MySQL poses the following limits on table partitioning:

  • You can partition only an integer column in a table or a column that is converted to an integer column by using a partition function.

  • The number of partitions (including subpartitions) for a single table cannot exceed 8,192.

  • If the table contains a unique index or primary key, the partition key column must be included in the unique index or primary key.

  • Foreign keys are not supported.

  • Full-text indexes are not supported.