Partitioning in MySQL 5.1

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.

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