MySQL range partition (2), mysqlrange Partition

MySQL range partition (2), mysqlrange Partition

MySQL range partitions are used most often. For details, see section 1.

Example: Here is my personal learning Summary-> details --> if you have any questions, please come and talk about it.

Mysql Partitioned an existing table with code to help you modify it.

Change rance to RANGE.

What if the range partition method in mysql conflicts with the primary key? What is the impact of having no primary key in innodb?

If innodb does not have an index, a hidden clustered index Rowid is generated by default.

It depends on your business logic,

My opinion: removing the primary key will not affect the innodb. If you use a hidden index, you can consider increasing the partition size as much as possible and keep the write order as much as possible, which will also improve the efficiency.