content_image/708758.jpg content_image/708757.jpg
## Chapter 24 Partitioning 

## Table of Contents 

<img src='content_image/708758.jpg'>

This chapter discusses user-defined partitioning . 

<img src='content_image/708757.jpg'>

## Note 

Table partitioning differs from partitioning as used by window functions. For information about window functions, see Section 12.21, “Window Functions” . 

In MySQL 8.0, partitioning support is provided by the InnoDB  and NDB  storage engines. 

MySQL 8.0 does not currently support partitioning of tables using any storage engine other than InnoDB or NDB , such as MyISAM . An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails with ER_CHECK_NOT_IMPLEMENTED . 

MySQL 8.0 Community binaries provided by Oracle include partitioning support provided by the InnoDB and NDB  storage engines. For information about partitioning support offered in MySQL Enterprise Edition binaries, see Chapter 30, MySQL Enterprise Edition . 

If you are compiling MySQL 8.0 from source, configuring the build with InnoDB  support is sufficient to produce binaries with partition support for InnoDB  tables. For more information, see Section 2.9, “Installing MySQL from Source” . 

Nothing further needs to be done to enable partitioning support by InnoDB  (for example, no special entries are required in the my.cnf  file). 

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

See Section 24.1, “Overview of Partitioning in MySQL” , for an introduction to partitioning and partitioning concepts. 

