I'm curious why you decided to keep r12_oApps, r12_oWork, and
r12_product in a separate pool. I'm not a database configuration
expert, but it seems sensible to keep your database logging in a
separate pool. I assume that's what r12_logz is? There are some more
details about this in a blog entry Neel wrote:
http://blogs.sun.com/realneel/entry/zfs_and_databases
This config seems pretty reasonable, but I'd double-check with the
experts on zfs-discuss.
-j
On Wed, Jun 11, 2008 at 09:22:35AM -0700, Grant Lowe wrote:
> Hi Johansen,
>
> As you requested, here's the output of zpool status:
>
> # sudo zpool status
> pool: r12_data
> state: ONLINE
> scrub: none requested
> config:
>
> NAME STATE READ WRITE CKSUM
> r12_data ONLINE 0 0 0
> c9t5006016B306005AAd4 ONLINE 0 0 0
> c9t5006016B306005AAd5 ONLINE 0 0 0
> c9t5006016B306005AAd6 ONLINE 0 0 0
> c9t5006016B306005AAd7 ONLINE 0 0 0
> c9t5006016B306005AAd8 ONLINE 0 0 0
> c9t5006016B306005AAd9 ONLINE 0 0 0
> c9t5006016B306005AAd10 ONLINE 0 0 0
> c9t5006016B306005AAd11 ONLINE 0 0 0
> c9t5006016B306005AAd12 ONLINE 0 0 0
> c9t5006016B306005AAd13 ONLINE 0 0 0
> c9t5006016B306005AAd14 ONLINE 0 0 0
> c9t5006016B306005AAd15 ONLINE 0 0 0
> c9t5006016B306005AAd16 ONLINE 0 0 0
> c9t5006016B306005AAd17 ONLINE 0 0 0
> c9t5006016B306005AAd18 ONLINE 0 0 0
> c9t5006016B306005AAd19 ONLINE 0 0 0
> c0t5d0 ONLINE 0 0 0
> c2t13d0 ONLINE 0 0 0
>
> errors: No known data errors
>
> pool: r12_logz
> state: ONLINE
> scrub: none requested
> config:
>
> NAME STATE READ WRITE CKSUM
> r12_logz ONLINE 0 0 0
> c9t5006016B306005AAd1 ONLINE 0 0 0
>
> errors: No known data errors
>
> pool: r12_oApps
> state: ONLINE
> scrub: none requested
> config:
>
> NAME STATE READ WRITE CKSUM
> r12_oApps ONLINE 0 0 0
> c9t5006016B306005AAd2 ONLINE 0 0 0
>
> errors: No known data errors
>
> pool: r12_oWork
> state: ONLINE
> scrub: none requested
> config:
>
> NAME STATE READ WRITE CKSUM
> r12_oWork ONLINE 0 0 0
> c9t5006016B306005AAd3 ONLINE 0 0 0
>
> errors: No known data errors
>
> pool: r12_product
> state: ONLINE
> scrub: none requested
> config:
>
> NAME STATE READ WRITE CKSUM
> r12_product ONLINE 0 0 0
> c9t5006016B306005AAd0 ONLINE 0 0 0
>
> errors: No known data errors
> #
>
> I'll do also a posting on the zfs-discuss mailing list as you suggested.
>
> I'm not sure if I have picked the correct pool configuration. Please
> advise, based on the zpool status if you could, please. You also
> mentioned a utility called filebench. Is it included in the 08/07
> release, or the latest Solaris release?
>
> Thanks for the help!
>
> As far as the recordsize, I've changed it to 8k as that is what the DBA says
> he's using for Oracle.
_______________________________________________
perf-discuss mailing list
perf-discuss@opensolaris.org
