RE: Redefining an entire setup
Murray/All
In the last 87 days since I started recording all sorts of sysmaster info...
there have been 0 disksorts, apart from one day, where there were 9.
totalsorts on average is (visual "grep totalsorts" check only (for the
moment)), around 40-50,000 to a max of just under 100K. So I guess yeah the
sorts must all be real small tables. I'm basically just chucking the temp
tables on to cater for any future sorting reqs.
Hmm to raw or not to raw... it's tempting because I know that the
performance gain would be a given, ie, there's no ifs or buts - it would *be
quicker*, but I'm not convinced of the manageability aspect, plus, when you
consider that in Solaris 2.6 you can just (re)mount a filesystem with the
"forcedirectio" mount option, you basically get most of the benefits of a
raw device, on a cooked f/s.
Re -ss: good suggestion I shall indeed use it.
Thanks very much for your input.
This newsgroup rocks. So much info.
Andrew Reardon
UNIX/Informix Administrator
Aircraft Systems, Boeing Aust. Ltd.
Ph: +61 7 3306 3346 Mob: +61 0419 745 831
> ----------
> From: Murray Wood[SMTP:murray@quanta.co.nz]
> Reply To: murray@quanta.co.nz
> Sent: Friday, July 30, 1999 2:32 PM
> To: 'Reardon, Andrew J'; 'informix-list@iiug.org'
> Subject: RE: Redefining an entire setup (long)
>
> Andrew
>
> For the dbexport, use the -ss option to conserve any specific table
> settings.
>
> With 2 disks the best you can do is mirror.
>
> I would (always on Solaris) create Raw chunks for the database. (Faster IO
> and keeps them away from playing children).
>
> 3 lots of 10Mb for temp spaces look small to me. (Maybe my prejudices
> coming out here). Does your application never sort large tables?
>
> Murray Wood
>
>
>
> -----Original Message-----
> From: Reardon, Andrew J [SMTP:Andrew.Reardon@australia.boeing.com]
> Sent: Thursday, July 29, 1999 7:41 PM
> To: 'informix-list@iiug.org'
> Subject: Redefining an entire setup (long)
>
[snippage]