My Really High DBT2 Scores

Pre-UC I put out a teaser on some dbt2 scores in the 50K range.   I mentioned and showed the graphs during my SSD session, but I thought I would show them here for those who skipped the UC or did not attend my session.  Basically what most people consider to be a classic “CPU Bound” workload where all of your data easily fits into memory can also see benefits from moving to SSD’s. Remember just because everything fits into memory doesn’t mean your not going to be doing some operations to disk ( logging, flushes, etc ). Take a look:

DBT2 Scores

Test TPM % Improvement
Regular Disk BBU (5.1.33) 46106.44 NA
SSD WO/Drive Cache (5.1.33) 50606.82 9.76%
SSD W/Drive Cache (5.1.33) 55793.47 21.01%
SSD WO/Drive Cache (5.4) 66286.95 43.77%
SSD W/Drive Cache (5.4) 70264.66 52.40%

The other thing to note here is is the speed up in 5.4, that’s a pretty big performance improvement. Now of course with the drive cache enabled on the ssd’s you get a 10%+ boost in performance, but keep in mind its not 100% safe for your data unless you use some other mechanism to mitigate data loss on a power outage ( i.e. ups shuts down server ).

Because someone will ask:
Tests where done on a Sun 4450, 4 disks Intel Enterprise SSD, Raid 10, 16 core 2.93 GHZ cpu’s, adaptec controller with 256MB W BBU, 10K SAS drives. Optimal configuration for the SSD’s software raid, 64K Stripe size, Software raid, Disabled controller read & write cache.

This entry was posted in benchmark, hardware, Matt, mysql. Bookmark the permalink.

4 Responses to My Really High DBT2 Scores

  1. neel says:

    The boost with 5.4 is great! Did the regular disks have their cache enabled? What was the CPU utilization (and number of users) for disk vs ssd case?

  2. matt says:

    Yes, regular disk had all the cache enabled.

  3. matt says:

    20W , 16 con, 15 th

  4. Pingback: Benchmarking with DBT2 « Todor Ivanov’s Weblog