Mysql 5.4 performance at 64 threads
Todoy Sun announced a new version of Mysql. The version 5.4 was targeted to improve performance an scalability of mysql. For example the scalability on UltraSPARC T2 was improved. As i tend do say: The T2 is a 64-way SMP system on a chip and wants to be handled this way. So the performance on this system left a little bit to be desired, but 5.4 answers at least to large part to this desires. Allan Packer writes in “MySQL 5.4 Scalability on 64-way CMT Servers”:
The throughput increases 71% from 32 to 64 vCPUs. It's encouraging to see a significant increase in throughput beyond 32 vCPUs.
The scaleup from 1 to 64 vCPUs is almost 30x. As I noted earlier, the UltraSPARC T2 chip does not have 64 cores - it only has 8 cores and 16 integer pipelines, so this is a good outcome.
Obviously there is still work to do, but this looks really promising. And with the advent of Nehalem with Hyperthreading even a 2-socket system is already a 16 thread system. So the improvements of scalability at 64 threads are definitely not hurting the scalability at actual and upcoming x86 systems, quite contrary ;)