Partitioning in MySQL 5.1

Architecture and Technology, Tutorial
Location: Ballroom A Level: Intermediate
Average rating: *****
(5.00, 4 ratings)

MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. This tutorial explains the benefits of partitioning and shows in practice how to take advantage of its features.

Topics include:

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

Users attending this tutorial will learn how to get started with
partitions, when to use and when to avoid partitioning, and how to deal with common partitioning problems.

Photo of Giuseppe Maxia

Giuseppe Maxia


Giuseppe Maxia is the MySQL community team lead.

A system analyst with 20 years of IT experience, he has worked as a database consultant and designer for several years.

He is a frequent speaker at open source events and the author of many articles.

He lives in Sardinia (Italy).

Photo of Sarah Sproehnle

Sarah Sproehnle

Cloudera, Inc.

Sarah Sproehnle is a Senior Instructor for MySQL/Sun. She has many years experience delivering training on various topics such as database administration, performance tuning, high availability, programming, and system administration.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL 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@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.