Friday, March 13, 2009

Innodb improvements with the latest google patch

Mysql is becoming stronger with the help of google (and oracle off course) :

http://www.innodb.com/innodb_plugin/plugin-performance/
http://www.innodb.com/innodb_plugin/plugin-performance/innodb-plugin-103-modified-sysbench-test/
http://www.innodb.com/innodb_plugin/plugin-performance/innodb-plugin-103-modified-sysbench-test-with-tcmalloc/
http://www.innodb.com/wp/2009/03/11/innodb-plugin-version-103-for-mysql-5130-32-33-released/


And the google mysql improvements page :http://code.google.com/p/google-mysql-tools/wiki/Mysql5Patches
http://code.google.com/p/google-mysql-tools/wiki/SmpPerformance

Another good resource is:
http://www.ducea.com/2009/03/13/innodb-plugin-version-103-released-enhances-concurrency-and-scalability-on-multi-core-systems/

New in this version of innodb

* 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

And all this in a STABLE INNODB Storage for Mysql.

And I almost forgot ... You can download the sources from here http://www.innodb.com/wp/2009/03/11/innodb-plugin-version-103-for-mysql-5130-32-33-released/innodb_plugin/download/v103/


0 comments: