Documentation Index
Fetch the complete documentation index at: https://planetscale.com/docs/llms.txt
Use this file to discover all available pages before exploring further.
What this error means
UNSUPPORTED_PARTITIONING_FEATURE means a table uses a MySQL partitioning feature that PlanetScale does not support in schema linting.
Common messages include:
only RANGE, HASH, and KEY based partitioning is supported
SUBPARTITION is not supported
partition "p0" has unsupported storage engine MyISAM
SUBPARTITION for partition "p0" is not supported
Why PlanetScale rejects it
Vitess already provides horizontal sharding at the keyspace level. Some MySQL table partitioning features are difficult to apply safely through online schema changes or are not compatible with the schema deployment path.
How to fix it
Use only supported partitioning types: RANGE, HASH, or KEY. Remove LIST partitioning, subpartitioning, and non-InnoDB partition engines.
Invalid:
CREATE TABLE events (
id bigint unsigned NOT NULL,
region_id int NOT NULL,
PRIMARY KEY (id)
)
PARTITION BY LIST(region_id) (
PARTITION us VALUES IN (1, 2),
PARTITION eu VALUES IN (3, 4)
);
CREATE TABLE events (
id bigint unsigned NOT NULL,
created_at date NOT NULL,
PRIMARY KEY (id, created_at)
)
PARTITION BY RANGE COLUMNS(created_at) (
PARTITION p2026 VALUES LESS THAN ('2027-01-01')
);
Need help?
Get help from the PlanetScale Support team, or join our Discord community to see how others are using PlanetScale.
