MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. The latest release, MySQL 5.5 enhances partitioning to make them even more user friendly and powerful. This tutorial explains the benefits of partitioning and shows in practice how to take advantage of its features. Attendees will get acquainted with partition types, the syntax to use them, the analysis and other preparatory work, how to run benchmarks, and how to manage partitions in practice. There will be an extensive explanation of the latest features, such as the COLUMNS option with RANGE and LIST, and their effect on performance and usability.Table of contents:
Giuseppe Maxia, a.k.a. “The Data Charmer” works as QA Director at Continuent.
He’s an active member of the MySQL community and long timer open source enthusiast.
During the past decades he has 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.
Works in cyberspace, with a virtual team.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).
View a complete list of O'Reilly MySQL Conference contacts.