Re: Out of Box Experience for Cheetah.
A feature-wish discussion rather than a problem report: contributors argue that Informix ships with a bare default ONCONFIG and should offer a better out-of-the-box setup. Suggestions include sample onconfig templates (sandbox/small/medium/large with set CPU, memory, dbspace and temp-space sizes) and an install wizard that detects RAM and CPU count and asks about database size, connections, OLTP vs DW, and disk to generate a baseline config. Counterpoints: what counts as 'reasonable', how to count dual-core/hyperthreaded CPUs, and possible vendor liability for tuning advice. No vendor change or fix is recorded; the thread ends with the idea of a community-built tool, with Obnoxio agreeing to lead it.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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@yahoo.com> >To: Mark Jamison <majp51@yahoo.com> >CC: Informix List <informix-list@iiug.org> >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@iiug.org>; 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@iiug.org>;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@iiug.org>; 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@iiug.org >Delivered-To: informix-list@iiug.org >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@iiug.org >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@iiug.org?subject=unsubscribe>; >List-Archive: <http://www.iiug.org/pipermail/informix-list>; >List-Post: <mailto:informix-list@iiug.org> >List-Help: <mailto:informix-list-request@iiug.org?subject=help> >List-Subscribe: ><http://www.iiug.org/mailman/listinfo/informix-list>,<mailto:informix-list-request@iiug.org?subject=subscribe>; >Errors-To: informix-list-bounces@iiug.org >Return-Path: informix-list-bounces@iiug.org >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@yahoo.com> >To: DL Redden <redden96@yahoo.com> >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@yahoo.com> >To: informix-list@iiug.org >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@thetool.com> >To: informix-list@iiug.org >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@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list > > > > > > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list > > > > > > > >_______________________________________________ >Informix-list m
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@hotmail.com> wrote in message news:mailman.463.1174576945.10648.informix-list@iiug.org... > 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@yahoo.com> >>To: Mark Jamison <majp51@yahoo.com> >>CC: Informix List <informix-list@iiug.org> >>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@iiug.org>; 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@iiug.org>;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@iiug.org>; 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@iiug.org >>Delivered-To: informix-list@iiug.org >>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@iiug.org >>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@iiug.org?subject=unsubscribe>; >>List-Archive: <http://www.iiug.org/pipermail/informix-list>; >>List-Post: <mailto:informix-list@iiug.org> >>List-Help: <mailto:informix-list-request@iiug.org?subject=help> >>List-Subscribe: >><http://www.iiug.org/mailman/listinfo/informix-list>,<mailto:informix-list-request@iiug.org?subject=subscribe>; >>Errors-To: informix-list-bounces@iiug.org >>Return-Path: informix-list-bounces@iiug.org >>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@yahoo.com> >>To: DL Redden <redden96@yahoo.com> >>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@yahoo.com> >>To: informix-list@iiug.org >>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@thetool.com> >>To: informix-list@iiug.org >>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@@NL@
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@hotmail.com> wrote in message > news:mailman.463.1174576945.10648.informix-list@iiug.org... >> 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@yahoo.com> >>> To: Mark Jamison <majp51@yahoo.com> >>> CC: Informix List <informix-list@iiug.org> >>> 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@iiug.org>; 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@iiug.org>;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@iiug.org>; 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@iiug.org >>> Delivered-To: informix-list@iiug.org >>> 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@iiug.org >>> 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@iiug.org?subject=unsubscribe>; >>> List-Archive: <http://www.iiug.org/pipermail/informix-list>; >>> List-Post: <mailto:informix-list@iiug.org> >>> List-Help: <mailto:informix-list-request@iiug.org?subject=help> >>> List-Subscribe: >>> <http://www.iiug.org/mailman/listinfo/informix-list>,<mailto:informix-list-request@iiug.org?subject=subscribe>; >>> Errors-To: informix-list-bounces@iiug.org >>> Return-Path: informix-list-bounces@iiug.org >>> 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@yahoo.com> >>> To: DL Redden <redden96@yahoo.com> >>> 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@yahoo.com> >>> To: informix-list@iiug.org >>> 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@thetool.com> >>> To: informix-list@iiug.org >>> 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 >>>>
Neil Truby said: > Also,knowing the way big bendors think So, which big benders have you been hanging out with? :o) -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Wow. I would have countered with the well worn practice of install wizards used by a lot of companies. > >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@hotmail.com> wrote in message > > news:mailman.463.1174576945.10648.informix-list@iiug.org... > >> 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@yahoo.com> > >>> To: Mark Jamison <majp51@yahoo.com> > >>> CC: Informix List <informix-list@iiug.org> > >>> 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@iiug.org>; 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@iiug.org>;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@iiug.org>; 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@iiug.org > >>> Delivered-To: informix-list@iiug.org > >>> 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@iiug.org > >>> 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@iiug.org?subject=unsubscribe>; > >>> List-Archive: <http://www.iiug.org/pipermail/informix-list>; > >>> List-Post: <mailto:informix-list@iiug.org> > >>> List-Help: <mailto:informix-list-request@iiug.org?subject=help> > >>> List-Subscribe: > >>> ><http://www.iiug.org/mailman/listinfo/informix-list>,<mailto:informix-list-request@iiug.org?subject=subscribe>; > >>> Errors-To: informix-list-bounces@iiug.org > >>> Return-Path: informix-list-bounces@iiug.org > >>> 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@yahoo.com> > >>> To: DL Redden <redden96@yahoo.com> > >>> 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@yahoo.com> > >>> To: informix-list@iiug.org > >>> 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@thetool.com> > >>> To: informix-list@iiug.org > >>> Sent: Friday, March 16, 2007 1:59:08 PM > >>> Subject: Re: Out of Box Experience for Cheetah. > >>> > >>> > >>> > >>> > >>> Obnoxio
Why can't all these things that people are suggesting be done outside IBM? It seems to me that if you really want some of these things that there is a great opportunity for everyone's ideas to be something you contribute to the community as a team. Whether it's an interactive tool or template onconfigs, can't this be something a bunch of people work on together? Ian Michael Gumby wrote: > > Wow. > > I would have countered with the well worn practice of install wizards > used by a lot of companies. > >> >> 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. >> > >
Tool said: > > Why can't all these things that people are suggesting be done outside IBM? > > It seems to me that if you really want some of these things that there is > a great opportunity for everyone's ideas to be something you contribute to > the > community as a team. > > Whether it's an interactive tool or template onconfigs, can't this be > something a bunch of people work on together? Well, I did suggest that ages ago, but no-one paid me any attention. Including you, it seems. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Obnoxio The Clown wrote: > Tool said: >> Why can't all these things that people are suggesting be done outside IBM? >> >> It seems to me that if you really want some of these things that there is >> a great opportunity for everyone's ideas to be something you contribute to >> the >> community as a team. >> >> Whether it's an interactive tool or template onconfigs, can't this be >> something a bunch of people work on together? > > Well, I did suggest that ages ago, but no-one paid me any attention. > > Including you, it seems. > :-) Sorry! So would you like to get things rolling and be the project manager? -t-
Tool said: > Sorry! > > So would you like to get things rolling and be the project manager? Yeah, OK then. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.