I've been running mysql on a T1000 (Ultrasparc T1) system for several years
now, and while I've been happy with the performance overall, the poor
floating point capability on these systems has been a disappointment.
Recently, I got my hands on a Sunfire T5420 system and I've been comparing
the floating point performance on this system with the T1000, and was
expecting to see a significant improvement in floating point by virtue of
the fact that the Ultrasparc T2 processor has 1 FPU per core as opposed to 1
FPU per CPU. However, I'm only seeing a marginal improvement for floating
point calculations, for example, a "select benchmark(100000000, 1.0 + 2.0)"
takes roughly 50 seconds to run on both of these systems, however I was
expecting a lot better performance from the T2 processor.
I've already explored the coolstack mysql builds from Sun, and they don't
seem to have any additional optimizations that I'm not already using for my
tests. So I'm a bit taken aback by this. I was considering going with the
T2 processor as an upgrade to my current servers, but if the floating point
is still this poor, I'm strongly considering going back to some
multiprocessor/multicore X86 box.
Has anyone had any similar experiences with this hardware?