| CARVIEW |
Recommended Servers for MySQLThe world's most popular open source database
- 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 Enterprise Monitor
- 16 Replication
- 17 Partitioning
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 Extending MySQL
- A MySQL 6.0 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- 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 17.1, “Overview of Partitioning in MySQL”.
MySQL supports several types of partitioning, which are discussed in Section 17.2, “Partition Types”, as well as subpartitioning, which is described in Section 17.2.5, “Subpartitioning”.
Methods of adding, removing, and altering partitions in existing partitioned tables are covered in Section 17.3, “Partition Management”.
Table maintenance commands for use with partitioned tables are discussed in Section 17.3.3, “Maintenance of Partitions”.
The PARTITIONS table in the
INFORMATION_SCHEMA database provides information
about partitions and partitioned tables. See
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some
examples of queries against this table, see
Section 17.2.6, “How MySQL Partitioning Handles NULL”.
The partitioning implementation in MySQL 6.0 is still undergoing development. For known issues with MySQL partitioning, see Section 17.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 available from
https://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.
User Comments
Add your own comment.