RE: onstat(1) options, which one?
IMHO buffers, locks and transactions are initial guess, short term tuning,
then forgotten until an issue arises.
Locks: Configure sufficient for your application - know the data and
application.
Buffers: Tune with read cache, buffer waits, cleaning, read aheads together
with the memory available in the computer.
Transactions: Number of users, plus know the application.
Murray Wood
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of Medi Montaseri
Sent: Wednesday, January 19, 2000 8:07 AM
To: informix-list@iiug.org
Subject: Re: onstat(1) options, which one?
This is a multi-part message in MIME format.
--------------F416EDA4C2766828B0775C4A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Thanks....you understood my question well...how about Buffers, locks, and
transactions?
Murray Wood wrote:
> Medi
>
> THe answer is "It all depends upon what is important for your application"
>
> Over tha last couple of years for some of our clients I have regularly
> developed useful information for DBA purposes. One of the things *I* dont
> want is too much information to look through, as well as useful
information.
> I have a database to record this information and a job that runs weekly to
> gather it from the SMI interface. I look at the output of onstat -d and
> onstat -t (eliminating small tables). I also email the last 500 or 1000> lines of the messages log.
>
> Murray Wood
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Medi Montaseri
> Sent: Tuesday, January 18, 2000 1:00 PM
> To: informix-list@iiug.org
> Subject: onstat(1) options, which one?
>
> This is a multi-part message in MIME format.
> --------------E8410433CDF1B48F8B6485FB
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> I want to provide some general status information about an Informix
engine.
> The result would be presented via HTML
> What options of onstat(1) should I use to give me the 80% coverage of all
> parameters.
>
> I also wanted to capture some of this data for trend analysis. Which
> parameters
> are more meaningful for trend analysis.
>
> Thanks
>
> --
> ---------------------------------------------------------
> Medi Montaseri, Course Developer, 408-756-3154
> ---------------------------------------------------------
>
> --------------E8410433CDF1B48F8B6485FB
> Content-Type: text/x-vcard; charset=us-ascii;
> name="medi.montaseri.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Medi Montaseri
> Content-Disposition: attachment;
> filename="medi.montaseri.vcf"
>
> begin:vcard
> n:Montaseri;Medi
> x-mozilla-html:FALSE
> adr:;;;;;;
> version:2.1
> email;internet:medi.montaseri@lmco.com
> title:Course Developer
> x-mozilla-cpt:;0
> fn:Medi Montaseri
> end:vcard
>
> --------------E8410433CDF1B48F8B6485FB--
--
---------------------------------------------------------
Medi Montaseri, Course Developer, 408-756-3154
---------------------------------------------------------
--------------F416EDA4C2766828B0775C4A
Content-Type: text/x-vcard; charset=us-ascii;
name="medi.montaseri.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Medi Montaseri
Content-Disposition: attachment;
filename="medi.montaseri.vcf"
begin:vcard
n:Montaseri;Medi
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:medi.montaseri@lmco.com
title:Course Developer
x-mozilla-cpt:;0
fn:Medi Montaseri
end:vcard
--------------F416EDA4C2766828B0775C4A--