Optimizing and tuning MariaDB
Tuning and optimizing MariaDB, and the applications that connect to it, for maximum performance is a subject worthy of a book in itself. We won't go into the details of specific strategies here because it's generally not necessary when we're just getting started with MariaDB. But it is useful to know a little about the subject, which is the purpose of this section.
The basic process of tuning and optimizing MariaDB starts with identifying the choke points: that is, the places that are causing unnecessary slowdowns. Using the slow query log discussed previously in this chapter, to identify these choke points is a good place to start.
Once a problem query, or set of queries, has been identified, the next step is to implement ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access