MySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries

Dave Stokes

Thursday 20 February 2020 from 10:15 to 12:30

Workshop in English - UK at PHP UK Conference 2020
Track Name: Velocity Track
Short URL: https://joind.in/talk/57002 (QR-Code (opens in new window))

Avg. Rating

Slow query? Add an index or two! But things are suddenly even slower! Indexes are great tools to speed data lookup but have overhead issues. Histograms don’t have that overhead but may not be suited. And how you lock rows also effects performance. So what do you do to speed up queries smartly?

Slides available at https://www.slideshare.net/davestokes/php-uk-2020-tutorial-mysql-indexes-histograms-and-other-ways-to-speed-up-your-queries

Comments

Comments are closed.

John Kleiser at 13:47 on 20 Feb 2020 (via Web2 LIVE)

Great, thanks.

David Carr at 13:19 on 21 Feb 2020 (via Web2 LIVE)

really great tutorial, a detailed overview of MySQL and great references for further research.

Chris Hogben at 17:34 on 21 Feb 2020 (via Web2 LIVE)

Lots of useful information about the new performance features in MySQL and how they work and operate in the background. Would have maybe like to have seen one or two hands-on, or live examples as it was a tutorial session, but otherwise a great session and fantastic presentation style. Thanks! :)