Guide to MySQL 5.1 Partitioning

Partitioning is a physical database design technique that many data modelers and DBAs are quite familiar with. Partitioning allows large objects within a database to be split into small, more manageable pieces. There are a number of benefits that come with partitioning, but the two main advantages are:

• Increased performance - during scan operations, the MySQL optimizer knows what partitions contain the data that will satisfy a particular query and will access only those necessary partitions during query execution.
• Simplified data management - partitioning allows a DBA to have more control over how data is managed inside of the database. By intelligently creating partitions, a DBA can simplify how certain data operations are performed.

Learn more about how MySQL 5.1 supports all the major forms of partitioning; Range, Hash, Key, List and Composite.

To receive a copy of this white paper, please complete the form below.

If you already have a MySQL.com account, save time by logging in now.