Using Partitioning in MySQL 5.1 and 5.5

Giuseppe Maxia (Continuent)
Average rating: ****.
(4.17, 6 ratings)

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:

  • Benefits of partitioning
  • Limits of partitioning
  • Understanding the partitioning types (RANGE, LIST, HASH and KEY)
  • Partitioning pruning and EXPLAIN additions
  • Benchmarking partitions
  • How to partition by dates in 5.1 and 5.5
  • Partitioning with MyISAM, InnoDB, Archive tables
  • Partitions maintenance:
  • converting partitioned tables to normal ones;
  • adding and dropping partitions
  • reorganizing partitions
  • checking and repairing partitions
  • Advanced partitioning techniques
  • partition maintenance through events
  • the partition helper
Photo of Giuseppe Maxia

Giuseppe Maxia

Continuent

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.

Comments

Trevor Little
04/12/2010 1:15pm PDT

Great talk. Maxia was awesome.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

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).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.