Shulou(Shulou.com)06/01 Report--

Mysql partitions are good for managing very large tables. There are four types of mysql partitions: range partition, list partition, hash partition and key partition. We use Navicat visualization tools to partition.

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

2. Open the design table to select options, and there is a partition below.

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

4. Check the information of the partition table through sql

5. Range partition, which indicates which field to partition by, which can be a field name or an expression operation such as year (create_time) on a field. The final value using range must be a number.

6. Check the table information of range partitions through sql. The other two partitions are more or less the same, so I won't go into details.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.