Presented by:

E9879f77c9c0e6ae599cc22d5bf7c00d

Dave Stokes

from Percona

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!

Date:
2022 April 24 - 13:30
Duration:
45 min
Room:
Database
Conference:
LinuxFest Northwest 22
Language:
Track:
MySQL
Difficulty:
100-level

Happening at the same time:

  1. MySQL Indexes and Histogram For Faster Queries
  2. Start Time:
    2022 April 24 13:30

    Room:
    Database

  3. Snitching on Apps That Snitch On You
  4. Start Time:
    2022 April 24 13:30

    Room:
    Privacy/Security

  5. VSCode Dev-Containers Lab
  6. Start Time:
    2022 April 24 13:30

    Room:
    Code Lab