2 ms·
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
by toledocavani 3mo 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.