Cooked vs Raw in 11.5 on Linux
A DBA moving to IDS 11.5 on SLES 11 x64 asked whether cooked (filesystem) chunks now perform about as well as raw devices on Linux, and how to create dbspaces on cooked files. Replies were opinions rather than a definitive answer: one poster still prefers raw, and if using cooked prefers SAN over local disk; the practical how-to given was to touch an empty file in the data directory and point onspaces at it, which creates the chunk at the specified size. Another poster favoured raw devices because root users can accidentally delete filesystem files. No benchmark data or firm conclusion on performance was recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
SLES 11x64, IDS 11.5 x64 (unknown sub number since I don't have the disc in my hands yet). We will be going to IDS 11.5 soon and it has been recommended that on our Linux platform we use cooked files instead of raw ones. 2 questions: is the performance roughly equivalent now? I've read posts from 3-4 years ago that said raw will always be better but I wasn't sure. Also how does one go about setting the dbspaces up using cooked files? I've had experience setting up raw files for the chunks but if cooked is the way to go then I'm gonna need a pointer in the right direction. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 10x32 SP2 & IDS 10.00.UC9 "Mostly, when you see programmers, they aren't doing anything. One of the attractive things about programmers is that you cannot tell whether or not they are working simply by looking at them. Very often they're sitting there seemingly drinking coffee and gossiping, or just staring into space. What the programmer is trying to do is get a handle on all the individual and unrelated ideas that are scampering around in his head." - Charles M. Strauss
I like raw better than cooked, but if I use cooked, I like it better on SAN disk than local disk. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wyza, Jonathon Sent: Friday, May 14, 2010 1:24 PM To: ids@iiug.org Subject: Cooked vs Raw in 11.5 on Linux [20165] SLES 11x64, IDS 11.5 x64 (unknown sub number since I don't have the disc in my hands yet). We will be going to IDS 11.5 soon and it has been recommended that on our Linux platform we use cooked files instead of raw ones. 2 questions: is the performance roughly equivalent now? I've read posts from 3-4 years ago that said raw will always be better but I wasn't sure. Also how does one go about setting the dbspaces up using cooked files? I've had experience setting up raw files for the chunks but if cooked is the way to go then I'm gonna need a pointer in the right direction. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 10x32 SP2 & IDS 10.00.UC9 "Mostly, when you see programmers, they aren't doing anything. One of the attractive things about programmers is that you cannot tell whether or not they are working simply by looking at them. Very often they're sitting there seemingly drinking coffee and gossiping, or just staring into space. What the programmer is trying to do is get a handle on all the individual and unrelated ideas that are scampering around in his head." - Charles M. Strauss ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
I basically touch a file in the directory used for the data and then use
onspaces to that file like a link to raw. That will create the space
size of the file.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Knox, Ernest
Sent: Friday, May 14, 2010 1:31 PM
To: ids@iiug.org
Subject: RE: Cooked vs Raw in 11.5 on Linux [20166]
I like raw better than cooked, but if I use cooked, I like it better on
SAN disk than local disk.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Wyza, Jonathon
Sent: Friday, May 14, 2010 1:24 PM
To: ids@iiug.org
Subject: Cooked vs Raw in 11.5 on Linux [20165]
SLES 11x64, IDS 11.5 x64 (unknown sub number since I don't have the disc
in my
hands yet).
We will be going to IDS 11.5 soon and it has been recommended that on
our
Linux platform we use cooked files instead of raw ones.
2 questions: is the performance roughly equivalent now? I've read posts
from
3-4 years ago that said raw will always be better but I wasn't sure.
Also how does one go about setting the dbspaces up using cooked files?
I've
had experience setting up raw files for the chunks but if cooked is the
way to
go then I'm gonna need a pointer in the right direction.
Jonathon Wyza
CX & CBORD System Administrator
CX Programmer/Analyst
Administrative Computing
Bethel College
(574)-257-3381
AIM: Iamwyza
jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu>
==============================
SLES 10x32 SP2 & IDS 10.00.UC9
"Mostly, when you see programmers, they aren't doing anything. One of
the
attractive things about programmers is that you cannot tell whether or
not
they are working simply by looking at them. Very often they're sitting
there
seemingly drinking coffee and gossiping, or just staring into space.
What the
programmer is trying to do is get a handle on all the individual and
unrelated
ideas that are scampering around in his head."
- Charles M. Strauss
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
I still like to set up the raw disks, otherwise your root access people have
permission to delete your file system when you least expect it. There was a
conference presentation about setting that up.
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Mitch Ratliffe
---------- Original Message -----------
From: "Knox, Ernest" <Ernest.Knox@searshc.com>
To: ids@iiug.org
Sent: Fri, 14 May 2010 14:34:42 -0400 (EDT)
Subject: RE: Cooked vs Raw in 11.5 on Linux [20167]
> I basically touch a file in the directory used for the data and then
> use onspaces to that file like a link to raw. That will create the
> space size of the file.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database Administrator Specialist
> Sears Holdings - BU: I & T Group
> 3333 Beverly Rd., B4-266A
> Hoffman Estates, IL. 60179
> Office: (847) 286-5735
> Email: Ernest.Knox@searshc.com
> Blackberry: 2244650553@messaging.sprintpcs.com
> Page via Skytel: 2244650553@sprint.skytel.com
> Informix or MySQL Primary: 9110210@skytel.com
> Informix or MySQL Secondary: 7276872@skytel.com
>
> " Yes we can make a Change! "
> " It's always a great day to watch Sports - GO LIONS, TIGERS, and
> BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU
> *******************************************************************
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of Knox, Ernest Sent: Friday, May 14, 2010 1:31 PM To: ids@iiug.org
> Subject: RE: Cooked vs Raw in 11.5 on Linux [20166]
>
> I like raw better than cooked, but if I use cooked, I like it better
> on SAN disk than local disk.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database Administrator Specialist
> Sears Holdings - BU: I & T Group
> 3333 Beverly Rd., B4-266A
> Hoffman Estates, IL. 60179
> Office: (847) 286-5735
> Email: Ernest.Knox@searshc.com
> Blackberry: 2244650553@messaging.sprintpcs.com
> Page via Skytel: 2244650553@sprint.skytel.com
> Informix or MySQL Primary: 9110210@skytel.com
> Informix or MySQL Secondary: 7276872@skytel.com
>
> " Yes we can make a Change! "
> " It's always a great day to watch Sports - GO LIONS, TIGERS, and
> BEARS!
>
> "
> " Lets not forget - GO Pistons and Red Wings! "
> GSU
> *******************************************************************
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of Wyza, Jonathon Sent: Friday, May 14, 2010 1:24 PM To:
> ids@iiug.org Subject: Cooked vs Raw in 11.5 on Linux [20165]
>
> SLES 11x64, IDS 11.5 x64 (unknown sub number since I don't have the
> disc
>
> in my
> hands yet).
>
> We will be going to IDS 11.5 soon and it has been recommended that
> on our Linux platform we use cooked files instead of raw ones.
>
> 2 questions: is the performance roughly equivalent now? I've read
> posts from 3-4 years ago that said raw will always be better but I
> wasn't sure.
>
> Also how does one go about setting the dbspaces up using cooked
> files? I've had experience setting up raw files for the chunks but
> if cooked is the way to go then I'm gonna need a pointer in the
> right direction.
>
> Jonathon Wyza
> CX & CBORD System Administrator
> CX Programmer/Analyst
> Administrative Computing
> Bethel College
> (574)-257-3381
> AIM: Iamwyza
> jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu>
> ==============================
> SLES 10x32 SP2 & IDS 10.00.UC9
>
> "Mostly, when you see programmers, they aren't doing anything. One
> of the attractive things about programmers is that you cannot tell
> whether or not they are working simply by looking at them. Very
> often they're sitting there seemingly drinking coffee and gossiping,
> or just staring into space. What the programmer is trying to do is
> get a handle on all the individual and unrelated ideas that are
> scampering around in his head." - Charles M. Strauss
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
******* Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
------- End of Original Message -------