Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Rick James

Rick James's picture

Rick James

Consultant, (self)


Rick James worked for Yahoo for 14 years. A main task was rooting out slowness on hundreds of different MySQL systems and proposing ways to speed them up -- tuning, schema changes, adding indexes, reformulating queries, even rearchitecting. Rick has addressed over 15K questions on various forums. Rick now does MySQL consulting, mostly in scaling and performance.


27 April - 3:00 PM - 3:50 PM at Ballroom C
These are distilled from watching MySQL users -- from newbies to experts -- successfully (or unsuccessfully) tune, index, optimize, and query. Some you already know; some you have been wondering about; and some will surprise you. Topics covered: SELECTs-do's & don'ts; INDEXing; ENGINE diffs; Optimizations (or not); PARTITIONing; Memory Usage; Character sets; Datatypes -... [read more]
26 April - 11:10 AM - 12:00 PM at Ballroom B
Indexing is a black art? Not really. But there are a lot of subtle issues and interactions to learn. This tutorial presents virtually everything there is to know about indexes. It takes the "cookbook" approach of saying "this SELECT begs for this INDEX", then deep dives into "why". This lecture moderately fast-paced. The novice will learn the basics that... [read more]