Re: performance question

From: Hans-Dieter Kutz (hdkutz@HDKUTZ.DE)
Date: Thu May 29 2003 - 14:27:05 EDT


Hello List,
found a setting for AIO in Redbook:
Database Perfomance Tuning on AIX

Cheers,
ku
On Wed, May 28, 2003 at 10:54:23AM -0500, Bob.Kelley@BRINKSINC.COM wrote:
> Just to add to Simon's comment, if you do enable AIO on your system, I
> would recommend setting max=500 and min=whatever. There is no performance
> tax for this setting, and this will allow you to guage how many of these
> servers are used with your app. Afterwhich, you can set max=whatever active
> only after next reboot. This way, you tune this setting specifically for
> your apps needs.
>
> FYI "pstat -a|grep aio|wc -l" will tell you how many async servers have
> been started at any given time.
>
> I was an "IBMr" in another life time and recommended to my customers that
> a setting of 10 times the number of physical drives on the system was a
> good rule of thumb, but have steered away from that since......Let me know
> if I can help you further on this aio stuff.
>
> Bobby Kelley
> Sr. AIX/UNIX Administrator
> BRINKS
> 972-877-5341
>
>
>
> |---------+---------------------------->
> | | "Green, Simon" |
> | | <Simon.Green@EU.A|
> | | LTRIA.COM> |
> | | Sent by: IBM AIX |
> | | Discussion List |
> | | <aix-l@Princeton.|
> | | EDU> |
> | | |
> | | |
> | | 05/23/2003 11:49 |
> | | AM |
> | | Please respond to|
> | | IBM AIX |
> | | Discussion List |
> | | |
> |---------+---------------------------->
> >------------------------------------------------------------------------------------------------------------------------------|
> | |
> | To: aix-l@Princeton.EDU |
> | cc: |
> | Subject: Re: performance question |
> >------------------------------------------------------------------------------------------------------------------------------|
>
>
>
>
> AIO's good, but only if the application is configured to use it. Simply
> enabling it and adding servers won't do anything.
>
> Simon Green
> Altria ITSC Europe s.a.r.l.
>
> AIX-L Archive at http://marc.theaimsgroup.com/?l=aix-l&r=1&w=2
> AIX FAQ at http://www.faqs.org/faqs/aix-faq/
>
> N.B. Unsolicited email from vendors will not be appreciated.
>
> > -----Original Message-----
> > From: abdellah.djebli@SICKKIDS.CA [mailto:abdellah.djebli@SICKKIDS.CA]
> > Sent: 23 May 2003 16:46
> > To: aix-l@Princeton.EDU
> > Subject: Re: performance question
> >
> >
> > After setting the vmtune to (-p10 -P30)the paging is gone and
> > the system is
> > doing a lot better.
> > The IO like you said, could be network related, which I hgave to
> > investigate,
> > because the system has two NICs (10/100), each on a different network.
> > I have also noticed that aio on the sytem is not used. It is
> > in a define
> > state
> > only. Would it help to set it up with 10min/20max aioservers.
>
> NOTICE TO BRINK'S EMPLOYEES:
> All electronic mail communications composed, sent, received or stored on or
> through Brink's equipment are subject to the Brink's Electronic
> Communications Policy. Employees should have no expectation of privacy in
> their use of the Company's electronic mail system.
>



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:52 EDT