This chapter discusses user-defined partitioning, as implemented in MySQL 6.0.

An introduction to partitioning and partitioning concepts may be found in Section 19.1, “Overview of Partitioning in MySQL”.

MySQL supports several types of partitioning, which are discussed in Section 19.2, “Partition Types”, as well as subpartitioning, which is described in Section 19.2.5, “Subpartitioning”.

Methods of adding, removing, and altering partitions in existing partitioned tables are covered in Section 19.3, “Partition Management”.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related MySQL Links Downloads common doc downloads guilds img programs sources support tech-resources user-groups usingmysql workbench Request more information about Pantek

Table maintenance commands for use with partitioned tables are discussed in Section 19.3.3, “Maintenance of Partitions”.

The PARTITIONS table in the INFORMATION_SCHEMA database provides information about partitions and partitioned tables. See Section 25.19, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, see Section 19.2.6, “How MySQL Partitioning Handles NULL Values”.

The partitioning implementation in MySQL 6.0 is still undergoing development. For known issues with MySQL partitioning, see Section 19.5, “Restrictions and Limitations on Partitioning”, where we have noted these.

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 6.0 binaries are available from http://dev.mysql.com/downloads/mysql/6.0.html. However, for the latest partitioning bugfixes and feature additions, you can obtain the source from our Bazaar repository. To enable partitioning, you need to compile the server using the --with-partition option. For more information about building MySQL, see Section 2.9, “MySQL Installation Using a Source Distribution”. If you have problems compiling a partitioning-enabled MySQL 6.0 build, check the MySQL Partitioning Forum and ask for assistance there if you do not find a solution to your problem already posted.