Session
B+Tree Indexes and InnoDB

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, 11:45 PM
Ludgate Suite

Abstract

Although a DBMS hides the internal mechanics of indexing. But to be able to create efficient indexes, you need to know how they work. This talk will help you understand the mechanics of the data structure used to store indexes and as to how it applies to InnoDB. At the end of the talk you will be able to learn how to use cost-analysis to pick and choose correct index definitions and will learn how to create indexes that will work efficiently with InnoDB.

Slides

Speaker

Ovais Tariq

Ovais Tariq

Support Engineer, Percona

Ovais Tariq works as a Support Engineer for Percona. Before joining Percona, he worked for different types of companies ranging from a startup to a big media organization. He has extensive experience in developing for and managing LAMP stack. He has worked in different roles, including that of a software engineer, development manager, dba and consultant. His particular fields of interest include high-performance systems, designing database/application architectures, high availability and fixing bottlenecks.

 

]]> ]]>