Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  Partitioning

Chapter 26 Partitioning

This chapter discussesuser-defined partitioning.

Note

Table partitioning differs from partitioning as used by window functions. For information about window functions, seeSection 14.20, “Window Functions”.

In MySQL 8.0, partitioning support is provided by theInnoDB andNDB storage engines.

MySQL 8.0 does not currently support partitioning of tables using any storage engine other thanInnoDB orNDB, such asMyISAM. An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails withER_CHECK_NOT_IMPLEMENTED.

MySQL 8.0 Community binaries provided by Oracle include partitioning support provided by theInnoDB andNDB storage engines. For information about partitioning support offered in MySQL Enterprise Edition binaries, seeChapter 32,MySQL Enterprise Edition.

If you are compiling MySQL 8.0 from source, configuring the build withInnoDB support is sufficient to produce binaries with partition support forInnoDB tables. For more information, seeSection 2.8, “Installing MySQL from Source”.

Nothing further needs to be done to enable partitioning support byInnoDB (for example, no special entries are required in themy.cnf file).

It is not possible to disable partitioning support by theInnoDB storage engine.

SeeSection 26.1, “Overview of Partitioning in MySQL”, for an introduction to partitioning and partitioning concepts.

Several types of partitioning are supported, as well as subpartitioning; seeSection 26.2, “Partitioning Types”, andSection 26.2.6, “Subpartitioning”.

Section 26.3, “Partition Management”, covers methods of adding, removing, and altering partitions in existing partitioned tables.

Section 26.3.4, “Maintenance of Partitions”, discusses table maintenance commands for use with partitioned tables.

ThePARTITIONS table in theINFORMATION_SCHEMA database provides information about partitions and partitioned tables. SeeSection 28.3.21, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, seeSection 26.2.7, “How MySQL Partitioning Handles NULL”.

For known issues with partitioning in MySQL 8.0, seeSection 26.6, “Restrictions and Limitations on Partitioning”.

You may also find the following resources to be useful when working with partitioned tables.

Additional Resources.  Other sources of information about user-defined partitioning in MySQL include the following:

  • MySQL Partitioning Forum

    This is the official discussion forum for those interested in or experimenting with MySQL Partitioning technology. It features announcements and updates from MySQL developers and others. It is monitored by members of the Partitioning Development and Documentation Teams.

  • PlanetMySQL

    A MySQL news site featuring MySQL-related blogs, which should be of interest to anyone using my MySQL. We encourage you to check here for links to blogs kept by those working with MySQL Partitioning, or to have your own blog added to those covered.