Created: 2007-01-25
Last modified: 2007-05-30

Database Performance and Scalability with db_STRESS Benchmark @T2000 +ZFS

by Dimitri


Ces informations sont données à titre indicatif et n'engagent pas Sun Microsystems.

Table of contents

Started as a simple database engines comparison, this benchmark quickly out-passed initial test perimeter and was transformed into more general database scalability study. This is the second part covering ZFS performance issues within the same test conditions.

Following benchmark results covering mixed subjects, combining:
     - MySQL MyISAM and InnoDB
     - PostgreSQL
     - Oracle 10g
     - ZFS (Sol10 11/06)
     - UFS buffered/forcedirectio
     - T2000
     - etc

This study was full of re-bound event and crazy surprises. I'm presenting all events here as they happened in chronological order, finding by finding, with all fixed and potential problems. Final results are very positive, but I always was most interested to know *how* people reaching the best possible performance level (being on the same initial conditions as others) - rather just a final numbers... Hope information presented in this document will be also useful for others and, if it'll wake up any new ideas - I'll be even more happy! :)

Have a fun reading! Any feedback - welcome!


Note: due Oracle license restrictions - all Oracle result numbers are removed...

2. Benchmark Platform
The same platform is used here as in the first part of tests (, except only T2000 host is used as database server.

3. Benchmark Overview

4. ZFS Benchmark
ZFS is a very new filesystem and doing only its first steps in database world. However, ZFS features are so exiting - more and more customers trying to adapt it in production systems, integrate in new projects, etc. But constructive performance feedback is still missing to build strong guidelines to avoid at least most common errors by following simple best practice. This chapter is just one step more in this direction...

Even ZFS is still young and not yet widely popular - its features and performance improved with each new Solaris release. Seeing it's able already to preform at least like big brother UFS - it's quite attractive to move to ZFS and have all benefits of the most innovated file system solution!

And of course, more we test it - better it'll be! :))