MySQL Indexes and Histograms to Speed Up Your Queries by Dave Stokes

Nobody complains when the database is fast. But when it slows down, you may try using an index. But then you add another and things are even slower than before. This session covers how MySQL uses the two most popular ways to increase query speed - indexes and histograms -- so that you understand how they are really used, why the query optimizer does what it does, how to test your queries to see if your changes really improve things, and some other tricks. You will learn why histograms are not for data with high churn rates, why functional indexes can help with complex queries, and how to use multi-value indexes on JSON arrays. This session assume that you have little or no experience with MySQL query tuning, indexes, or database administration.