tag:blogger.com,1999:blog-16959946.post2434285055672137838..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: Performance gain of MySQL 5.1 InnoDB pluginGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-16959946.post-86684073691282958682010-06-08T00:09:45.221+02:002010-06-08T00:09:45.221+02:00@Gerry,
Very interesting. As everyone knows, sysbe...@Gerry,<br />Very interesting. As everyone knows, sysbench is a very simple test, and more elaborate usage can achieve substantially bigger gain.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-42846151000820980972010-06-08T00:07:49.985+02:002010-06-08T00:07:49.985+02:00@Ronald,
Thanks. Fixed.@Ronald,<br />Thanks. Fixed.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-17753017547755077382010-06-08T00:05:10.958+02:002010-06-08T00:05:10.958+02:00You have these jumbled.
--mysql-user=$PASSWD ...You have these jumbled.<br /><br /> --mysql-user=$PASSWD \<br /> --mysql-password=$USER \Ronald Bradfordhttp://ronaldbradford.comnoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-63077945990218619892010-06-07T19:10:32.761+02:002010-06-07T19:10:32.761+02:00On 8 core servers w/ 16G memory and InnoDB buffer ...On 8 core servers w/ 16G memory and InnoDB buffer pool set to 80% of available memory, we clocked double the performance with the plugin: http://mmatemate.blogspot.com/2010/05/mysql-5146-with-innodb-plugin-kicks.html. A couple of our development teams tested with their application specific benchmarks and got the similar results.<br /><br />My $.02<br />GGerry Narvajahttps://www.blogger.com/profile/14092453914112673024noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-42940961820811205442010-06-07T14:47:09.378+02:002010-06-07T14:47:09.378+02:00@Mark
It was on Linux.
I did not modify anything i...@Mark<br />It was on Linux.<br />I did not modify anything in the server except the innodb_buffer_pool_size.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-32368059623456540522010-06-07T14:42:22.444+02:002010-06-07T14:42:22.444+02:00Was this on Linux, and did you have native async I...Was this on Linux, and did you have native async IO turned on in the Innodb 1.1 ?Mark Robsonhttps://www.blogger.com/profile/15864507044869250062noreply@blogger.com