MySQL partitioning practice through Navicat

MySQL partitioning is helpful for managing very large tables. There are four types of MySQL partitioning: range partitioning, list partitioning, hash partitioning, and key partitioning. We use the Navicat visualization tool to partition

1. Open Navicat, find the specified database, and design the table

2. Open the design table and select the option. There are partitions below.

3. First look at hash partitioning, and distribute data to different partitions based on the given number of partitions

4. Check the partition table information through sql.

5. Range partitioning, which indicates the field to be partitioned. It can be a field name or an expression operation on a field, such as year(create_time). The final value of range must be a number.

6. Check the table information of range partition through SQL. The other two partitions are similar, so I won’t go into details.