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 »

MySQL 5.1 for ISV/OEM Solutions

The MySQL 5.1 server continues to move MySQL and Sun ahead in its mission to make sophisticated database management available and affordable to all. With the release of MySQL 5.1, the MySQL database server provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for:

• Managing larger volumes of data
• Applications that have high-availability requirements
• Systems needing a powerful but autonomous-running database that requires little attention and continually services anywhere from one to thousands of user requests per second.

MySQL 5.1 is particularly appealing to ISV (Independent Software Vendors) and OEM (Original Equipment Manufacturers) solution providers who need to embed a database within the application that they either sell in traditional manner or use in a software-as-a-service fashion. Of course, product managers and other decision makers will be pleased from a business standpoint with the lower total cost of ownership that MySQL supplies, with costs being traditionally only 10-15% of what proprietary database vendors charge.

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 »