MySQL Indexes and Histogram For Faster Queries
Yes, your queries can run faster!
Dave Stokes is a Technology Evangelist at Percona Corporation and started at MySQL as a PHP Developer in the MySQL Certification Group. He lives in Texas, is the author of MySQL and JSON: A Practical Programming Guide.
Nobody complains that that database is to fast. But when things get slow, wow do they complain. The two easiest (and most productive) ways to increase query speed are indexes and histograms. But there is a lot of bad/old information and superstition clouding the information on how to add indexes. This talk will cover what your indexing options are (and there are many), how they really work, why you need a PRIMARY KEY, and more. Histograms help speed queries too but they are best for data with a low churn rate and you will see how they can help the query optimizer do its work. So if you database is already too fast, this is not the session for you. But if you need faster queries then you know which session you need to attend!
- 2022 April 24 - 13:30
- 45 min
- LinuxFest Northwest 22