The InnoDB Team just released the InnoDB Plugin version 1.0.3. From their announcement here are the main points of this release:

• Enhanced scalability: the Google SMP enhancement for synchronization
• More efficient memory allocation: ability to use platform allocator tuned for multi-core systems
• Improved out-of-the-box scalability: unlimited concurrent thread execution by default
• Dynamic tuning: at run-time, enable or disable insert buffering and adaptive hash indexing

wow… now this is indeed some great news for innodb users… I am writting this, and still I can’t believe that they’ve included the Google SMP patch in their official release. I can only assume that alternative projects as XtraDB, Drizzle, Percona patches, Google patches, etc. made Oracle to look back and try to do something with innodb besides the regular bug fixes. Even if we already use several of the great ‘unofficial alternatives’ this is good news for everyone.
Way to go Oracle! and looking forward for future performance improvements in the official innodb plugin; including existing patches that are out there already for sometime is a good start, but internal improvements from the innodb team would be also great .

Here are some performance results based on their own tests:
http://www.innodb.com/innodb_plugin/plugin-performance/

After a long time (with the first RC-5.1.22 released more than a year ago, and the first public version back in 2005), mysql version 5.1 was finally declared ready for production use, and 5.1.30-GA is available for download.

MySQL 5.1 provides a number of new enhancements including:

• Better performance with partitioning
• Easy manageability with the event scheduler
• Improved Plugin interface
• Logs on demand
• More reliability with row-based replication.
• The embedded server, which was not maintained during MySQL 5.0, is back in service!

Read the rest of this entry »

MySQL announced that they plan to release by the end of the month a ‘release candidate’ of MySQL 5.1 a major new upgrade of the world’s most popular open source database server.

During the announcement that was made at the inaugural ‘Japanese MySQL Users Conference’ earlier last week, MySQL mentioned that several GPL-licensed products are scheduled to be available for download by the end of September: Read the rest of this entry »