Related Documentation Download this Excerpt
PDF (US Ltr) - 338.2Kb
PDF (A4) - 339.5Kb


MySQL Partitioning

Abstract

This is the MySQL Partitioning extract from the MySQL 8.0 Reference Manual.

For legal information, see theLegal Notices.

For help with using MySQL, please visit theMySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2026-01-27 (revision: 84333)

Table of Contents

Preface and Legal Notices
1 Partitioning
2 Overview of Partitioning in MySQL
3 Partitioning Types
3.1 RANGE Partitioning
3.2 LIST Partitioning
3.3 COLUMNS Partitioning
3.3.1 RANGE COLUMNS partitioning
3.3.2 LIST COLUMNS partitioning
3.4 HASH Partitioning
3.4.1 LINEAR HASH Partitioning
3.5 KEY Partitioning
3.6 Subpartitioning
3.7 How MySQL Partitioning Handles NULL
4 Partition Management
4.1 Management of RANGE and LIST Partitions
4.2 Management of HASH and KEY Partitions
4.3 Exchanging Partitions and Subpartitions with Tables
4.4 Maintenance of Partitions
4.5 Obtaining Information About Partitions
5 Partition Pruning
6 Restrictions and Limitations on Partitioning
6.1 Partitioning Keys, Primary Keys, and Unique Keys
6.2 Partitioning Limitations Relating to Storage Engines
6.3 Partitioning Limitations Relating to Functions