There is patch from Google to improve SMP performance , but for some workloads it showed for us reverse scalability.
E.g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442)
|Threads||Standard InnoDB||Google smpfix||Yasufumi rw_lock|
results are in tps, more are better
(result in tps, more is better)
The benchmark was made on 8cores box, and as you see for 4+ threads we have worse results than for 2 threads. That is was main reason why we did not include InnoDB smp fixes in our build yet.
Fortunately we get fixed version of Yasufumu’s rw_locks and you can download them there
The results for the same benchmark:
|Threads||Standard InnoDB||Yasufumi rw_lock ver 2|
And for other workloads new rw_locks show results comparable with Google’s smpfix, so we will include
innodb_rw_lock into our next -percona-highperf release