Online, USA
Dave Stokes, Percona’s Technical Evangelist, will present his talk MySQL Indexes and Histograms to Speed Up Your Queries on CakeFest 2022 on September 30th at 16:45 UTC.
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 assumes that you have little or no experience with MySQL query tuning, indexes, or database administration.
About the event.
Cakefest is a virtual event dedicated to CakePHP. For the past 10 years, the framework has been a benchmark for PHP development, providing developers with a full MVC stack solution to build powerful applications which scale. This, coupled with the amazing community backing and thousands of plugins, makes CakePHP the number one choice for those who love code.
