Announcing InnoDB Plugin 1.0.4 for MySQL 5.1.37

August 11th, 2009

The InnoDB team is pleased to announce the availability of InnoDB Plugin release 1.0.4, which brings additional performance gains of 20% or more! This latest early adopter version of the InnoDB Plugin includes bug fixes and additional new features, further enhancing InnoDB performance, scalability, reliability, and ease of use. We are especially pleased that this release includes several significant community contributions.

We are grateful to Sun Microsystems, Google and Percona Inc., for their contributions, which are described in the InnoDB Plugin documentation and in the source code files. This page provides an overview of some of the new features and how the InnoDB team incorporated or modified the contributions, or introduced changes of our own.

Some of the new features in this release can significantly performance and scalability, depending on workload and tuning considerations. Some highlights:

  • I/O-bound DBT2 throughput is more than 8% better than the built-in InnoDB distributed with MySQL
  • CPU-bound DBT2 throughput is nearly 20% better than the built-in InnoDB
  • Group commit now allows InnoDB to scale better from 16 to 64 users, with as much as 60% more throughput at 64 users!
  • “Adaptive flushing” dramatically eliminates throughput dips during checkpoints

More details on some of the performance tests we conducted and the results achieved are presented here.

Reliability is enhanced in this release, because queries are protected from using indexes created while they were executing, eliminating the possibility of wrong results. Out of the box performance and usability are enhanced through improvements in default configuration parameters. This release also improves usability with more concise output for the command SHOW ENGINE INNODB MUTEX, which is especially helpful when using a large buffer pool.

Because of changes made in MySQL V5.1 to fix MySQL Bug #42610, installing this release as a binary plugin to MySQL 5.1.37 requires some small changes in my.cnf (or my.ini) configuration files, as described in the documentation.

Source code and binaries for the InnoDB Plugin 1.0.4 are now available for download. This new release will work with MySQL releases 5.1.24 through 5.1.37 when built from source. Binaries have been compiled against MySQL 5.1.37 and can be plugged in dynamically only to that version.

Several bugs were fixed in this release, including those reported in the MySQL bug database, as well as those internally detected. This release also reflects all other changes made in MySQL through version 5.1.37. A full list of changes in InnoDB Plugin release 1.0.4 is available in the documentation and in the online ChangeLog.

Please report your comments and any problems or issues with the InnoDB Plugin in the InnoDB Plugin Forum or in the MySQL bug database.

We hope you are pleased with this release of the InnoDB Plugin!