Partitioning: the "other" performance method

Database Administration
2 April 4:50PM - 5:40PM @ Ballroom H

Experience level: 
Intermediate
Duration: 
50 minutes conference
Partitioning is a feature of MySQL that has been around since version 5.1. It is a method of improving database speed beyond the limits of indexes and available memory. When used appropriately, it can increase performance by several orders of magnitude. Amid some doubts, it was overshadowed by more flamboyant features in MYSQL 5.5. and 5.6, and it has not got the attention it deserves. There are situations, even in the current abundance of performance features, where partitioning is the right tool to use. This session explains the principles of MySQL partitions, the associated features introduced in MySQL 5.5 and 5.6, and how to use partitions wisely to improve performance in some heavy tasks. We will cover: * Partitioning principles; * Why and how to use indexes for partitioning; * How to associate partitioning and replication for optimal performance; * Some tools, tips, and tricks to use partitioning more easily.


Speakers

QA Director, Continuent
Biography: 
QA Director at Continuent I am active member of the MySQL community and long timer open source enthusiast. During the past 25 years I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C , French, Spanish, Java. I work in cyberspace, with a virtual team.

Slides