Re: Out of Box Experience for Cheetah.

No disrespect Neil, but using your logic they would have to dump all the docs,
release notes, training manuals, etc.

Some amount of guidance is expected, and there _is_ a software agreement in
effect when you install the software. It's understood that you have to tune
it, and if anything, there are not enough solid guidelines to this day to
elevate tuning above the black art it is today.

-t-

Neil Truby wrote:
Also,knowing the way big bendors think, I wouldn't be surpisedif there would be legal reservations about providing too much bespoke "guidance" in case it all went wrong and they felt that they might be liable in some way.

"Ian Michael Gumby" <im_gumby@xxxxxxxxxxx> wrote in message news:mailman.463.1174576945.10648.informix-list@xxxxxxxxxxx
You could do the following:

1) Query the system to determine the amount of memory and the # of CPUs
2) Ask the user the approximate size of the database (small, medium or large) giving a rough range
of each.
3) Ask the user the number of simultaneous connections one can expect.
4) Ask the user if this is an OLTP, DW or both environment.
5) Aks the user how many CPUs he wants to use. (Assuming multiple core/cpu system.)
[Ignore if only 1 cpu found]
6) How much disk space he wants to allocate to the system.

Create a base config from this input.

While it won't be perfect, it will be enough to get a "better" tuned system out of the box.



From: DL Redden <redden96@xxxxxxxxx>
To: Mark Jamison <majp51@xxxxxxxxx>
CC: Informix List <informix-list@xxxxxxxx>
Subject: Re: Out of Box Experience for Cheetah.
Date: Wed, 21 Mar 2007 18:23:28 -0700 (PDT)
MIME-Version: 1.0
Received: from perform.iiug.org ([216.177.38.211]) by bay0-mc9-f4.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 21 Mar 2007 18:23:51 -0700
Received: from localhost (localhost [127.0.0.1])by perform.iiug.org (Postfix) with ESMTP id 0D258A01B;Wed, 21 Mar 2007 20:23:45 -0500 (EST)
Received: from perform.iiug.org ([127.0.0.1])by localhost (perform.iiug.org [127.0.0.1]) (amavisd-new, port 10024)with ESMTP id L2xUsKHZVlRN; Wed, 21 Mar 2007 20:23:38 -0500 (EST)
Received: by perform.iiug.org (Postfix, from userid 60001)id 1A322A010; Wed, 21 Mar 2007 20:23:38 -0500 (EST)
Received: from perform.iiug.org (localhost [127.0.0.1])by perform.iiug.org (Postfix) with ESMTP id 97E22A001;Wed, 21 Mar 2007 20:23:34 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])by perform.iiug.org (Postfix) with ESMTP id 9DB0C9FFBfor <informix-list@xxxxxxxx>; Wed, 21 Mar 2007 20:23:33 -0500 (EST)
Received: from perform.iiug.org ([127.0.0.1])by localhost (perform.iiug.org [127.0.0.1]) (amavisd-new, port 10024)with ESMTP id ofOP-K7vqNiu for <informix-list@xxxxxxxx>;Wed, 21 Mar 2007 20:23:30 -0500 (EST)
Received: by perform.iiug.org (Postfix, from userid 60001)id 7937CA001; Wed, 21 Mar 2007 20:23:30 -0500 (EST)
Received: from web30808.mail.mud.yahoo.com (web30808.mail.mud.yahoo.com[68.142.200.151])by perform.iiug.org (Postfix) with SMTP id 130969FFBfor <informix-list@xxxxxxxx>; Wed, 21 Mar 2007 20:23:27 -0500 (EST)
Received: (qmail 59296 invoked by uid 60001); 22 Mar 2007 01:23:28 -0000
Received: from [68.188.39.38] by web30808.mail.mud.yahoo.com via HTTP;Wed, 21 Mar 2007 18:23:28 PDT
X-Message-Info: LsUYwwHHNt2lNPQ4KS2MdiJtTdgArKnBucXFA/safx8gyWDN4JZZbNRv3bYlRl+L
X-Virus-Scanned: amavisd-new at iiug.org
X-Original-To: informix-list@xxxxxxxx
Delivered-To: informix-list@xxxxxxxx
X-Virus-Scanned: amavisd-new at iiug.org
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID;b=2QHGWSRP1m/oMS+nLir7D/qLCfQGH+dRTTSofx5Bcjjwjrtm3mrQzyxpJVmP+YdMXBV35jLRv/k1WligaF8bhu9QVWN6SJK0ZbV0hqYCbZWGRdnVkNIk97Gro2HaldjNKdy5kiRjMtXyOvc+R/2u8KCym8jWYyA6GAfsV3Xzr5E=;
X-YMail-OSG: ARkRbPYVM1m.VA4a7ABmVO5D5XvnJmUAX.6i_ByQ.BUiVJu0mbyN.fQg0JsNV0crtr_IC4vQdTq7n3XPQrDf2gHDF6.b2co2L9HTH14n8LlVfKs7om9O6TwjQ1dYUAzC
X-Mailer: YahooMailRC/476 YahooMailWebService/0.7.41.8
X-BeenThere: informix-list@xxxxxxxx
X-Mailman-Version: 2.1.6
Precedence: list
List-Id: "comp.databases.informix" <informix-list.iiug.org>
List-Unsubscribe: <http://www.iiug.org/mailman/listinfo/informix-list>,<mailto:informix-list-request@xxxxxxxx?subject=unsubscribe>
List-Archive: <http://www.iiug.org/pipermail/informix-list>
List-Post: <mailto:informix-list@xxxxxxxx>
List-Help: <mailto:informix-list-request@xxxxxxxx?subject=help>
List-Subscribe: <http://www.iiug.org/mailman/listinfo/informix-list>,<mailto:informix-list-request@xxxxxxxx?subject=subscribe>
Errors-To: informix-list-bounces@xxxxxxxx
Return-Path: informix-list-bounces@xxxxxxxx
X-OriginalArrivalTime: 22 Mar 2007 01:23:53.0764 (UTC) FILETIME=[C1176E40:01C76C20]

My thought was to offer a quick list of suggestions that were customized to the box being installed on instead of having a predefined list of configurations that may not even be practical for the machine being installed on. I was not suggesting an optimizer but a quick way to get up an running with an engine that would make use of the machine it was installed on.

Lisha Lynn Mineral Cosmetics

----- Original Message ----
From: Mark Jamison <majp51@xxxxxxxxx>
To: DL Redden <redden96@xxxxxxxxx>
Sent: Monday, March 19, 2007 6:18:29 PM
Subject: Re: Out of Box Experience for Cheetah.



Perhaps, but wouldn't that open a Pandora's box? I mean what constitutes "reasonable" ?




----- Original Message ----
From: DL Redden <redden96@xxxxxxxxx>
To: informix-list@xxxxxxxx
Sent: Friday, March 16, 2007 7:29:20 PM
Subject: Re: Out of Box Experience for Cheetah.



Wouldn't it be nice if the installer was smart enough to sniff out the machine info and suggest a reasonable list of configurations to choose
>from based on the machine size. That would be most useful for getting
started right out of the box.


----- Original Message ----
From: Tool <tool@xxxxxxxxxxx>
To: informix-list@xxxxxxxx
Sent: Friday, March 16, 2007 1:59:08 PM
Subject: Re: Out of Box Experience for Cheetah.




Obnoxio The Clown wrote:
I'd go a step (or two) further:

onconfig.sandbox - 1CPU, 512MB RAM, 5GB, 1 tempdbspace of 1GB
onconfig.small - 2 CPU, 2GB RAM, 20GB, 2 temp spaces of 2.5GB
onconfig.medium - 4 CPU, 4GB RAM, 100GB, 3 temp spaces of 5GB
onconfig.large - 8 CPU, 8GB RAM, 250GB, 6 temp spaces of 10GB

All should have a minimal BLOB / SmartBLOB space, say 1 GB each.

(These are all discussion points, but I think their should be a number
of
semi-tuned options. ;o)

I'd have agree with OTC on these. I've got a beater Pentium III right now
using 1CPU, 512MB RAM, 100GB of IDE drive space available, easy to chop up. His
designation of sandbox would equal what I would call "tiny" compared to
current stuff on the market. I've also got x86_64 AMD boxes too, running
Linux and SATA drives.

The other thing that starts to get
rather sticky is, what are
you refering to as a CPU when you start talking about DualCore
and hyperthreading, both give the appearance of being 2 CPUs
per physical CPU. Guess this is a little out of scope but
interesting to consider for processor affinity, etc.

_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list






_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list








_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Interest Rates near 39yr lows! $430,000 Mortgage for $1,399/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-18466&moid=7581




--
*
* http://www.youtube.com/watch?v=rVS3kdXycrM&mode=related&search=
*

.

Relevant Pages

  • Re: CPU info
    ... >> a marketing strategy to separate the new generation of AMD's CPUs from ... >> Intel CPUs are traditionally more expensive than AMD's, ... I'll probably either keep the old guy around and install Elive ... install of 7.0 and KDE on a 166MHz Pentium system with 64 MB of RAM into ...
    (comp.os.linux.hardware)
  • Trouble with new poweredge 2950
    ... Is that because BSD is ignoring the HT CPUs, ... CD ROM detection message. ... I believe that the SAS controller is supposed ... tried to install, I used 6.1, and it completely didn't recognize my SAS ...
    (freebsd-questions)
  • Re: XP Activation
    ... The phrase "1-2 CPUs" refers to one computer that has ... your may install the same license on two ... You'll need to go out and purchase a new copy of Windows ... Now I want to reinstall xp on the laptop but I was told that I can not do ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Out of Box Experience for Cheetah.
    ... Aks the user how many CPUs he wants to use. ... Out of Box Experience for Cheetah. ... Wouldn't it be nice if the installer was smart enough to sniff out the ... machine info and suggest a reasonable list of configurations to choose ...
    (comp.databases.informix)
  • PIIIDR3 freezes with two CPUs
    ... From what I can tell, the CPUs are matched, as only the long serial ... I install XP from the CD, ... machine locks (freezes). ... The only way to recover is by doing a hardware reset. ...
    (microsoft.public.windowsxp.hardware)