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