Re: Database Block Size

On Tue, 17 Oct 2000 15:49:35 +0200, "Frank" <frankbo_at_interaccess.nl> wrote:

>Will go for 8k on Unix as from now on. Cooked, that is.

Take it easy when using EMC boxes and/or Veritas. That may change the ground rules. You may have to do some digging in the doco to find out the real block size for cooked.

>BTW, I come across many (well...) sysops that are _very_ reluctant to
>start off with raw fs. Cannot convince them always.

Most of the "old salts" remember the pain it was to administer raw partitions in UNIX. Mostly not true anymore, due to the good crop of LVM's in the last few years. But once burned, twice shy. Very few new sysops even know what raw means. They just blame the EMC boxes. Most unfortunate...

>Any war stories on terrible performing dbms's on cooked fs, that flash on
>raw?
>--

Yes. But it was in AIX and about 5 years ago, so I dunno how relevant that would be today. I can't see why, the basic principle of bypassing the cooked after-processing is still there. But I reserve my opinion on this until I get a chance of trying it again by myself.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Oct 18 2000 - 04:50:40 CDT