Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Indexes - what you need to know to get the most out of them

Indexes - what you need to know to get the most out of them

 25 April - 11:55 AM - 12:20 AM @ Room 209
Experience level: 
Beginner
Duration: 
25 minutes conference
Tracks:
Operations
Topics:
MySQL

Description

Proper indexing is key to database performance. Find out how MySQL uses indexes for query execution, then come up with an optimal index strategy. In this session you’ll also learn how to know when you need an index, and to also get rid of indexes that you don’t need to speed up queries.

Speakers

Matthew Boehm's picture

Matthew Boehm

MySQL Architect, Percona

Biography:

Matthew joined Percona in the fall of 2012 as a MySQL consultant. He quickly rose to Architect and became one of Percona's training instructors. His areas of knowledge include the traditional Linux/Apache/MySQL/PHP stack, memcached, MySQL Cluster (NDB), massive sharding topologies, PHP development and a bit of MySQL-C-API development.

Share this talk