|
|
|
|
|
by toledocavani
27 days ago
|
|
And the post did mention it, argueing it may be better to partition by auto-incremented ID with the support of catch-all range and partution monitoring. > The primary key already exists. For tables using BIGINT AUTO_INCREMENT, it’s monotonically increasing: newer rows have larger IDs. That’s the property range partitioning needs. The primary key is the partition key. |
|