Advanced MySQL 8

Partitions

Here are some tips:

• It is not recommended to use PARTITIONS until you know how it will help you
• Do not use PARTITIONS unless you have more than one million records
• Do not use more than 50 PARTITIONS on a table; otherwise, the performance will be impacted
• The PARTITION RANGE mode is the only method that is useful and perfect for your needs in general; it is also easy to manage
• SUB-PARTITIONS are not necessarily useful, except in specific cases
• The partition key should not be the first column of an index; otherwise, maintenance affects performance

Techniques:

It is wrong to claim that partitioning will solve performance problems. Partitioning divides a table into several small tables. However, the size of the table is rarely a ...