Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

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/