[EMAIL PROTECTED] schrieb:
Hi all,
Does anybody use Oracle on ZFS in production (but not as a
background/testing database but as a front line) ?
I haven't used in production yet - but I'm planning by the end of the year. I
did some performance stress tests on ZFS vs. UFS+SVM. For testing I used the
TPC-H benchmark as base and tested on SAN (Symmetrix DMX1000 storage).
The test consists of four parts:
1. creation of database (CREATE DATABASE ...; @catalog.sql; @catproc.sql)
2. Importing Test data with sqlldr (TPC-H target size of 2 GB)
3. Run a single instance of the TPC-H benchmark
4. Run 4 (2 * NCPU) instances of the TPC-H benchmark
Test 1: UFS performed slightly better
Test 2: performance of UFS vs. ZFS was similar
Test 3: ZFS was somewhat faster (<10%)
Test 4: ZFS was much faster (>20%)
Summing up the runtime of all 4 tests ZFS was ~12% faster (248 mins to 280
mins).
I am interesting especially in:
- how does it behave after a long time of using it. Becasue COW nature
of ZFS I don't know how it influences performance of queries.
I filled up the pool with random data so that the pool reached 100% usage
during the benchmark (The benchmark needs a huge TEMP tablespace (with above
2GB data TEMP grew up to 20GB), so you can expect a lot of write I/O) The
total performance dropped just by 1-2%
- general opinion of such pair (ZFS + Oracle)
Use compression and save a lot of space. Expect a space reduction of >50% by
using compression even with filled up tablespaces. Oracle just worked on ZFS,
no "strange" results.
I had one panic, but this was related to the Emulex FC device driver, not to
ZFS (in the meantime a Emulex patch has been released (120222/120223), don't
know if it fixes this panic)
The total runtime didn't change during my tests (<1%) if compression was
turned on compared to compression off. The CPU usage increased by ~15%. So if
you have fast CPUs give the CPUs something to do instead of just fooling around.
- which version of Oracle
This was Oracle 10g R2 on a FSC PrimePower (2 x 1350 MHz, 4 GB RAM) with
Solaris 10 06/06.
Currently I have only an older Xeon box with SAN connectivity for Solaris/x86
but Oracle 10gR2 still isn't released on 32bit x86 platforms[1]. 10gR1 needed
much more space in the TEMP tablespace so I couldn't complete the tests.
[1]
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
Daniel
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
