Tips and techniques

The tips and techniques which I am sharing with you come from two decades of improving and optimizing MySQL performance in thousands of situations. These tips and techniques can help you better understand how to make your MySQL servers more efficient.

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...