Embedded InnoDB 1.0.6.6750 released

February 25th, 2010

The InnoDB Team is pleased to announce the availability of a new release of Embedded InnoDB – 1.0.6.6750. This new early adopter release contains many functional and performance improvements vs. the previous 1.0.3.5325 release, as well as many bug fixes. It is based on InnoDB Plugin 1.0.6.

This release contains numerous bug fixes and performance enhancements. Some of the most significant changes are:

  • Enforced NOT NULL column constraint during insert and update.
  • Introduced the settable global variables lru_old_blocks_pct and lru_block_access_recency for controlling the buffer pool eviction policy.
  • The VARBINARY column type was enabled.
  • Support inlining of functions and prefetch with Sun Studio. These changes are based on contribution from Sun Microsystems Inc. under a BSD license.
  • Implemented IO capacity tuning.
  • Added new API functions for checking whether a transaction currently holds a shared lock on the InnoDB data dictionary and to list all configuration variables.
  • Added IB_DECIMAL column type.
  • Speed up search by not fetching the next N records when doing an unique search.
  • Introduce a new boolean configuration parameter “adaptive_flushing” which can be set to OFF to disable the adaptive flushing.

See the ChangeLog or the online documentation for a complete listing of the changes since release 1.0.3.5325.

You can download source code and binaries for the Embedded InnoDB from the download page.

Please report your comments and any problems or issues with the Embedded InnoDB in the InnoDB Forums.

Thank you, and enjoy!