In this chapter, we will cover the following recipes:
- The explain plan
- Benchmarking queries and the server
- Adding indexes
- Invisible index
- Descending index
- Analyzing slow queries using pt-query-digest
- Optimizing datatypes
- Removing duplicate and redundant indexes
- Checking index usage
- Controlling the query optimizer
- Using index hints
- Indexing for JSON using generated columns
- Using resource groups
- Using performance_schema
- Using the sys schema
