Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 14434 invoked from network); 14 Oct 2008 06:52:07 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 14 Oct 2008 06:52:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4543FA7ADB2; Tue, 14 Oct 2008 07:52:04 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20525-04; Tue, 14 Oct 2008 07:52:04 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAB91A7ADAD; Tue, 14 Oct 2008 07:52:03 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 14 Oct 2008 07:50:00 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7BBC2A7AD85 for ; Tue, 14 Oct 2008 07:50:00 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19922-09 for ; Tue, 14 Oct 2008 07:50:00 -0400 (EDT) Received: from kecgate02.infosys.com (kecgate02.progeon.com [61.95.162.76]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4C208A7AD77 for ; Tue, 14 Oct 2008 07:49:57 -0400 (EDT) X-TM-IMSS-Message-ID:<49e44d4d000a0721@infosys.com> Received: from blrkechub03.ad.infosys.com ([10.66.236.43]) by infosys.com ([61.95.162.76]) with ESMTP (TREND IMSS SMTP Service 7.0; TLS: TLSv1/SSLv3,128bits,RC4-MD5) id 49e44d4d000a0721 ; Tue, 14 Oct 2008 17:17:19 +0530 Received: from BLRKECMBX02.ad.infosys.com ([10.66.236.22]) by blrkechub03.ad.infosys.com ([10.66.236.43]) with mapi; Tue, 14 Oct 2008 17:19:55 +0530 From: VIVEK_SHARMA To: "zhuchao@gmail.com" CC: ORACLE-L Date: Tue, 14 Oct 2008 17:19:54 +0530 Subject: RE: Filesystem Block Size ? 1K or 4K or 8K ? Thread-Topic: Filesystem Block Size ? 1K or 4K or 8K ? Message-ID: <69E1360E54B50C4A828A136C158E47420532463B14@BLRKECMBX02.ad.infosys.com> References: <69E1360E54B50C4A828A136C158E47420532463A7C@BLRKECMBX02.ad.infosys.com><1429898935-1223980509-cardhu_decombobulator_blackberry.rim.net-1872300114-@bxe297.bisx.prod.on.blackberry><69E1360E54B50C4A828A136C158E47420532463AC1@BLRKECMBX02.ad.infosys.com> <1522893788-1223984314-cardhu_decombobulator_blackberry.rim.net-1357042091-@bxe297.bisx.prod.on.blackberry> In-Reply-To: <1522893788-1223984314-cardhu_decombobulator_blackberry.rim.net-1357042091-@bxe297.bisx.prod.on.blackberry> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_69E1360E54B50C4A828A136C158E47420532463B14BLRKECMBX02ad_" MIME-Version: 1.0 X-archive-position: 11628 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: VIVEK_SHARMA@infosys.com Precedence: normal Reply-to: VIVEK_SHARMA@infosys.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --_000_69E1360E54B50C4A828A136C158E47420532463B14BLRKECMBX02ad_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thanks V much Zhu My Questions in-laid below preceded by Qs -> Cheers ________________________________ From: zhuchao@gmail.com [mailto:zhuchao@gmail.com] If direct io is being used, the difference maybe less. Qs 1 -> What do you mean by "the difference maybe less."? Anyway I don't see any benefit using 1k/4k blocksize. If you want best throughput, go with raw volumes. Have done all tuning on hp kaio setup to maximize os capability? Qs 2 -> Could you share some "tuning on hp kaio setup" please? ________________________________ HP who is partnering the Benchmark states - since Filesystems are being Mou= nted with Direct I/O therefore 1K F.S. block size is preferred to 8K. ________________________________ From: zhuchao@gmail.com [mailto:zhuchao@gmail.com] Of course set to 8k ________________________________ We are in the process of Setting up DB Server for an OLTP Banking Applicati= on Benchchmark. HP-UX B.11.31 system device block size(think this is the O.S. block size) =3D 1K Base page size =3D 4K. DB_block_size =3D 8K Should the Filesystem (VXFS) Block Size be set to 1K, 4K or 8K? ... Persona= lly I think it should be 4 K (i.e. Equal to the Page-size) **************** CAUTION - Disclaimer ***************** This e-mail contain= s PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of t= he addressee(s). If you are not the intended recipient, please notify the = sender by e-mail and delete the original message. Further, you are not to = copy, disclose, or distribute this e-mail or its contents to any other pers= on and any such actions are unlawful. This e-mail may contain viruses. Inf= osys has taken every reasonable precaution to minimize this risk, but is n= ot liable for any damage you may sustain as a result of any virus in this = e-mail. You should carry out your own virus checks before opening the e-ma= il or attachment. Infosys reserves the right to monitor and review the con= tent of all messages sent to or from this e-mail address. Messages sent to= or from this e-mail address may be stored on the Infosys e-mail system. *= **INFOSYS******** End of Disclaimer ********INFOSYS*** --_000_69E1360E54B50C4A828A136C158E47420532463B14BLRKECMBX02ad_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Thanks V much Zh= u

 

My Questions in-= laid below preceded by Qs ->

 

Cheers

 

From: zhuchao@gmail.com [mailto:zhuchao@gmail.com]

If direct io is being used, the difference maybe less.

Qs 1 -> What do you mean by “the difference maybe less.”?


Anyway I don't see any benefit using 1k/4k blocksize.
If you want best throughput, go with raw volumes.


Have done all tuning on hp kaio setup to maximize os capability?=

Qs 2 -> Could you share some “tuning on hp kaio setup” please?

<= span style=3D'font-size:12.0pt;color:navy'> 

 

HP who is partne= ring the Benchmark states - since Filesystems are being Mounted with Direct I/O therefore 1K F.S. block si= ze is preferred to 8K.

 

From:= zhuchao@gmail.com [mailto:zhuchao@gmail.com]

Of course set to 8k

We are in the pr= ocess of Setting up DB Server for an OLTP Banking Application Benchchmark.

 

HP-UX B.11.31

system device bl= ock size(think this is the O.S. block size) =3D 1K

Base page size = =3D 4K.

DB_block_size = =3D 8K

 

Should the Files= ystem (VXFS) Block Size be set to 1K, 4K or 8= K? … Personally I think it should be 4 K (i.e. Equal to the Page-size)

 

***************=
* CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AN=
D CONFIDENTIAL INFORMATION intended solely  for the use of the addressee(s)=
. If you are not the intended recipient, please  notify the sender by e-mai=
l and delete the original message. Further, you are not  to copy, disclose,=
 or distribute this e-mail or its contents to any other person and  any suc=
h actions are unlawful. This e-mail may contain viruses. Infosys has taken =
 every reasonable precaution to minimize this risk, but is not liable for a=
ny damage  you may sustain as a result of any virus in this e-mail. You sho=
uld carry out your  own virus checks before opening the e-mail or attachmen=
t. Infosys reserves the  right to monitor and review the content of all mes=
sages sent to or from this e-mail  address. Messages sent to or from this e=
-mail address may be stored on the  Infosys e-mail system. ***INFOSYS******=
** End of Disclaimer ********INFOSYS***
= --_000_69E1360E54B50C4A828A136C158E47420532463B14BLRKECMBX02ad_-- -- http://www.freelists.org/webpage/oracle-l