Session
Practical MySQL indexing guidelines

Sponsors
Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Booking.com Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 25th, 4:30 PM
Fleet Suite

Abstract

In many production systems, indexes are designed empirically and without instrumentation to check their efficiency, resulting in poor performance and increased hardware needs. Learn in this talk the fundamental ideas behind indexing, the errors you should avoid and the tools that can help you harness the full power of indexes. The following topics will be covered:

  • strengths and limitations of indexes in MySQL
  • performance degradation caused by bad indexes
  • guidelines to design efficient indexes
  • tools and methods to identify and remove unnecessary indexes
  • Slides

    Speaker

    Stéphane Combaudon

    Stéphane Combaudon

    MySQL DBA, Dailymotion

    Stéphane is a MySQL DBA at Dailymotion, one of the leading video-sharing websites in the world. He has been using the LAMP platform for almost 10 years in various companies and is particularly enthusiastic about MySQL. He is a regular speaker at conferences on MySQL and on free software.

     

    ]]> ]]>