Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Rick's RoTs (Rules of Thumb)

Rick's RoTs (Rules of Thumb)

 27 April - 3:00 PM - 3:50 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
Optimization
Tools and Techniques

Description

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 - internal and artificial; Hardware; and Data Warehousing. Your takeaways include a dozen tidbits you did not know; some of them directly applicable to development, tuning, DBAing, optimizing, etc.

Speakers

Rick James's picture

Rick James

Consultant, (self)

Biography:

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.

Share this talk