Hi, 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? -Rod
