Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

PARTITIONing - How-To vs. Don't-Bother

PARTITIONing - How-To vs. Don't-Bother

 19 April 5:15 PM - 05:40 PM @ Ballroom E
Experience level: 
Intermediate
Duration: 
25 minutes conference
Tracks:
Scalability/Performance
Topics:
MySQL
Optimization

Description

What are the _useful_ parts of PARTITIONing? Not much. I will briefly present the 'only' four use cases that exist for this decade-old feature of MySQL. I will give you insight into the written -- and unwritten -- limitations and gotchas of PARTITIONing. Plus a few hints about the "native" partitioning coming in 5.7 and where it is headed. Come to learn about PARTITIONing, or to understand why it is not doing all that you expected. Or come to challenge me with a 5th use case.

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