This chapter explains the basics of how to improve the performance of the queries that are executed on a MariaDB server. First, the important tools required to find slow queries are described. Once we find such queries, we will need to find out why they are slow. Thus, a description of how MariaDB uses indexes follows. Then, we will discuss the EXPLAIN command, which shows how MariaDB executes a query. Contextually, we will also discuss the main execution strategy.
The topics covered in this chapter are:
The slow query log
The
pt-query-digestcommand from Percona ToolkitIndexes
Table statistics
The
EXPLAINstatementImportant MariaDB optimizations