MySQL 5.1 Whitepapers

What's New in MySQL 5.1

MySQL 5.1 provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for data warehousing and business intelligence, applications having extreme high-availability requirements, and systems needing a powerful but autonomous-running database that requires little attention to continually service thousands of user requests per second. This white paper covers these enhancements in detail.

More »

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.

More »