Re: [zfs-discuss] Re: ZFS memory and swap usage

2007-03-21 Thread Al Hopper
On Wed, 21 Mar 2007, Rainer Heilke wrote:

[... reformatted ]

 We're running Update 3. Note that the DB _does_ come up, just not in the
 two minutes they were expecting. If they wait a few moments after their
 two-minute start-up attempt, it comes up just fine.

So why don't you state the actual time it takes to come up?
What is magic about 2 minutes?

 I was looking at vmstat, and it seems to tell me what I need. It's just
 that I need to present the data as simplistically as possible for the
 DBA's.

 Rainer

Regards,

Al Hopper  Logical Approach Inc, Plano, TX.  [EMAIL PROTECTED]
   Voice: 972.379.2133 Fax: 972.379.2134  Timezone: US CDT
OpenSolaris.Org Community Advisory Board (CAB) Member - Apr 2005
 OpenSolaris Governing Board (OGB) Member - Feb 2006
___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss


Re: [zfs-discuss] Re: ZFS memory and swap usage

2007-03-17 Thread Robert Milkowski
Hello Rainer,

Friday, March 16, 2007, 11:11:16 PM, you wrote:

RH Thanks for the links, but this is not really the kind of data I'm
RH looking for. These focus more on I/O. I need information on the
RH memory cahing, and so on. Specifically, I need data that shows how
RH starting up a 10GB SGA database on a 16GB machine will not be able
RH to flush the ZFS cache as quickly as the DBA's are assuming, and
RH how to point them to more realistic tests/metrics, and get them
RH away from top's simplistic viewpoint of memory under S10.

ZFS should give back memory used for cache to system if applications
are demanding it. Right it should but sometimes it won't.

However with databases there's simple workaround - as you know how
much ram all databases will consume at least you can limit ZFS's arc
cache to remaining free memory (and possibly reduce it even more byt
2-3x factor). For details on how to do it see 'C'mon ARC, stay small...'
thread here.

So if you have 16GB RAM in a system and want 10GB for SGA + another
2GB for Oracle + 1GB for other kernel resources you are with 3GB left.

So I would limit arc c_max to 3GB or even to 1GB.


-- 
Best regards,
 Robertmailto:[EMAIL PROTECTED]
   http://milek.blogspot.com

___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss