MariaDB Indexes Revisited: Beyond the Documentation

Abstract

Applying indexes of any type in MariaDB is nuanced task – they are used to speed up the performance of our search queries at the expense of having to be maintained when data is added, changed, or deleted.
In this talk, Lukas will distill his expertise shared in a series of blog posts based on indexes into an hour of indexing gems: you will learn how to understand what indexes do in a variety of scenarios and when and how to rewrite queries to achieve better performance.

Lukas Vileikis

Lukas is a long-time MariaDB user, a database guru and a security expert.
These days, Lukas can be found spreading knowledge through writing and video content, as well as speaking at events and training technology professionals on how to break, optimize, and secure their applications and database instances.
Lukas runs his own blog at lukasvileikis.com and he is also the author of the book “Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case.”