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.
Watch video MySQL Indexes and Histograms to Speed Up Your Queries by Dave Stokes online without registration, duration hours minute second in high quality. This video was added by user CakePHP 06 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 626 once and liked it 11 people.