In the previous chapters, we learned how to use indexes, and execution plans, and looked at the best way to analyze a table structure. In this chapter, we will be learning how to analyze and optimize large MySQL queries, and look at some tips and techniques.
We all know that a full scan on a huge table will impact your database performance, and we will learn how to avoid it. We will also review the new MySQL 8.0 partition features and improvements.
This chapter will cover the following:
- The most important variables are full scan indicators
- Partitioning a table:
- Overview of partitioning in MySQL 8.0
- Partitioning types available
- Horizontally partitioning your data
- Managing partitions:
- Option #1: RANGE partitioning
- Option #2: LIST partitioning
- Option #3: HASH partitioning
- Option #4: KEY partitioning
- Using partitions:
- Partition pruning...