Skip to Main Content
The world's most popular open source database
Contact MySQL  | 
Login  |  Register
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL Partitioning
  • Preface and Legal Notices
  • Partitioning
  • Overview of Partitioning in MySQL
  • Partitioning Types
    • RANGE Partitioning
    • LIST Partitioning
    • COLUMNS Partitioning
      • RANGE COLUMNS partitioning
      • LIST COLUMNS partitioning
    • HASH Partitioning
      • LINEAR HASH Partitioning
    • KEY Partitioning
    • Subpartitioning
    • How MySQL Partitioning Handles NULL
  • Partition Management
    • Management of RANGE and LIST Partitions
    • Management of HASH and KEY Partitions
    • Exchanging Partitions and Subpartitions with Tables
    • Maintenance of Partitions
    • Obtaining Information About Partitions
  • Partition Pruning
  • Restrictions and Limitations on Partitioning
    • Partitioning Keys, Primary Keys, and Unique Keys
    • Partitioning Limitations Relating to Storage Engines
    • Partitioning Limitations Relating to Functions
    • Partitioning and Locking
Related Documentation
MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
Download this Excerpt
PDF (US Ltr) - 365.9Kb
PDF (A4) - 367.8Kb


version 5.7
8.3
8.0  current

MySQL Partitioning

Abstract

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

For legal information, see the Legal Notices.

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

Document generated on: 2025-05-02 (revision: 81874)


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
6.4 Partitioning and Locking

HOME   NEXT
Related Documentation
MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
Download this Excerpt
PDF (US Ltr) - 365.9Kb
PDF (A4) - 367.8Kb
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2025 Oracle

  • Products
  • HeatWave
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • Blogs
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2025 Oracle
Privacy / Do Not Sell My Info | Terms of Use | Trademark Policy |