All,
>>> It seems that the famous MySQL scalability issues on SMP is due to a
>>> glibc deficiency:
>>>
>>> http://jeffr-tech.livejournal.com/6268.html#cutid1
>>> http://ozlabs.org/~anton/linux/sysbench/
Note that sysbench is specifically a no-db-lock-contention benchmark.
MySQL+InnoDB does still have a lock contention scalability issue (as do
we, at a higher # of processors).
--Josh