Hi!
I have recently encountered this text in which the author claims very high MySQL speedups for simple queries
It is not that he speeds up simple queries (you'd notice that maybe if you used infiniband, and even then it wouldn't matter much :) He just avoided hitting some expensive critical sections that make scaling on multicore systems problematic.
It looks interesting. There are some places where mediawiki could take that shortcut if available.
It wouldn't be a shortcut if you had to establish another database connection besides existing one.
I wonder if we have such CPU bottleneck, though.
No, not really. Our average (do note, this isn't median and is affected by heavy queries more) DB response time is 1.3ms (measuring on the client).
Domas