Toad World® Forums

TPC-E TPS


#1

Below is my setup

Ubuntu 9.10 Server
MySQL 5.1 Dual Intel Xeon 5220 CPU’s12GB DDR3 ECC REGDVDRW SATA

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.

The seems very low to me -

Any Suggestions?


#2

You are IO bound - SATA (even with NCQ) is much slower than SAS drives (not to mention 15K versus 7200 RPM). You simply need more and better/faster disks - and maybe a RAID controller with RAM cache.


#3

I added a 64G 3Gb/s SSD as the data drive yet there was no increase in TPS when running TPC-E. Is my system still I/O bound with respect to the speed of the drive, or does it seem like I might have a bottleneck elsewhere.

Thanks


#4

Please read this blog - and the many others on BMF - because I think they may help:

http://www.toadworld.com/BLOGS/tabid/67/EntryID/370/Default.aspx