The Below setup
Ubuntu 9.10 Server
Dual Intel Xeon 5220 CPU’s
12GB DDR3 ECC REG
320GB HDD SATA
I installed Ubuntu and MySQL from scratch accepting all defaults and the TPC-E TPS result is 4.96 with 100 users.
In deference to previous advice, I am now more informed about taking TPS as a useful metric.
However - I swapped out the 320GB Sata Drive with a HighPoint RAID controller with 8 Intel Extreme Solid State Drive, and the TPS only went up tp 7.2.
Also some collegues have hinted that my TPS for both cases should be significantly larger.
I gotta believe that I am not I/O bound any longer -
Any suggestions or opinions on the results I am getting?