- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- Preface
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL and Virtualization
- 16 MySQL Load Balancer
- 17 Replication
- 18 MySQL Cluster
- 19 Partitioning
- 20 Spatial Extensions
- 21 Stored Procedures and Functions
- 22 Triggers
- 23 Event Scheduler
- 24 Views
- 25 INFORMATION_SCHEMA Tables
- 26 Precision Math
- 27 APIs and Libraries
- 28 Connectors
- 29 MySQL Proxy
- 30 Extending MySQL
- A MySQL 6.0 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- E Credits
- Index
Table of Contents [+/-]
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”.
Table maintenance commands for use with partitioned tables are discussed in Section 19.3.3, “Maintenance of Partitions”.
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:
-
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.
-
MySQL Partitioning Architect and Lead Developer Mikael Ronström frequently posts articles here concerning his work with MySQL Partitioning and MySQL Cluster.
-
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.
MySQL 6.0 binaries are now 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 BitKeeper 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.
User Comments
Add your own comment.