Partitioning: the "other" performance method

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

Experience level: 
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.


Quality Assurance Architect, VMware
Quality Assurance Architect at VMware. Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle. Then at Continuent, Inc and currently at VMware through a merge. I am active member of the MySQL community and long timer open source enthusiast. During the past decades I have worked in various IT related fields, with focus on databases, object oriented programming, system administration, quality assurance. Fluent in Italian, English, Perl, Python, SQL, Spanish, C, Bash, and good speaker of C , French, Java. I work in cyberspace, with a virtual team.