In the last episode (Apr 22), Rod Heyd said: > 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.
If you are running just one command, then you are only using one of the 8 FPUs on the T2. Try comparing 8 parallel "select benchmark(100000000, 1.0 + 2.0)" runs at once on each server. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org