Chapter 2. Performance Analysis

In this chapter, you'll get recommendations for how to achieve good performance, what tools to use, and MariaDB internal presentations for analyses purposes. The goal of this chapter is to help you find where a performance issue comes from.

The performance goal takes time and requires a lot of tests to make things as performant as possible. There are many situations, many possibilities, and different architectures, and all these complex things need to be answered with many tools. These tools will help you diagnose performance issues as fast as possible to find complex issues.

Tools are not the only solutions. You can do many other things to optimize your databases:

• Use good index types when it's necessary. Too many indexes will slow down your databases.
• Set the best column data type. For example, do not use a char column data type if it stores only integers.
• Avoid duplicated keys.
• Optimize your SQL queries as much as possible.

If these points...