From mboxrd@z Thu Jan 1 00:00:00 1970 Message-ID: <006201bf0bb7$6eae4a60$030116ac@fd1> From: "Fernando Dammous" Subject: [linux-lvm] LVM, raw-io, devfs Date: Thu, 30 Sep 1999 23:48:23 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005F_01BF0B9E.48761620" Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: To: Linux LVM msede This is a multi-part message in MIME format. ------=_NextPart_000_005F_01BF0B9E.48761620 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I would like help from the more experts in this matter, because I fear = that I can in some way to lose or to corrupt my FS under LVM. =20 =20 LVM 0.7 is installed (built into the kernel, which is still in the = version 2.0.36) and working perfectly, with the root filesystem and swap = in a LV (boot with initrd). =20 =20 Now, I would like to install the devfs and mainly the raw-io. =20 =20 Can I install them in a kernel 2.0.36, which is already patched with = LVM? =20 =20 Should I apply the patches in which order (first devfs, later the = raw-io, or vice versa)? =20 =20 I intend to install Oracle8 using raw-io. =20 The devfs isn't so important for me (should it be ?). =20 If anyone knows about restrictions or some clues I would thank a lot. =20 Thanks in advance Fernando ------=_NextPart_000_005F_01BF0B9E.48761620 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi all,

 I would like help from the more = experts in this=20 matter, because I fear that I can in some way to lose or to corrupt my = FS under=20 LVM. 
 
LVM 0.7 is installed (built into the kernel, = which is=20 still in the version 2.0.36) and working perfectly, with the root = filesystem and=20 swap in a LV (boot with initrd). 
 
Now, I would like = to=20 install the devfs and mainly the raw-io.  
 
Can = I=20 install them in a kernel 2.0.36, which is already patched with = LVM? =20
 
Should I apply the patches in which order (first devfs, = later the=20 raw-io, or vice versa)? 
 
I intend to install Oracle8 = using=20 raw-io.  
The devfs isn't so important for me (should it = be=20 ?). 
 
If anyone knows about restrictions or some clues I = would thank=20 a lot. 
 
Thanks in advance
 
Fernando
 
------=_NextPart_000_005F_01BF0B9E.48761620-- From mboxrd@z Thu Jan 1 00:00:00 1970 Date: Fri, 1 Oct 1999 14:40:03 +0200 From: Adrien Farkas Subject: Re: [linux-lvm] LVM, raw-io, devfs Message-ID: <19991001144003.B29576@redneck.sk.oracle.com> Reply-To: freddy@sk.oracle.com References: <006201bf0bb7$6eae4a60$030116ac@fd1> Mime-Version: 1.0 In-Reply-To: <006201bf0bb7$6eae4a60$030116ac@fd1> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: Fernando Dammous Cc: linux-lvm@msede.com Fernando Dammous (ferdam@internetcom.com.br) wrote : > LVM 0.7 is installed (built into the kernel, which is still in the version 2.0.36) and working perfectly, with the root filesystem and swap in a LV (boot with initrd). > > Now, I would like to install the devfs and mainly the raw-io. > > Can I install them in a kernel 2.0.36, which is already patched with LVM? > > Should I apply the patches in which order (first devfs, later the raw-io, or vice versa)? > > I intend to install Oracle8 using raw-io. well, I'm still not sure whether Oracle software is compatible with raw-io patch in linux kernel, please let me know how are you doing with that. > The devfs isn't so important for me (should it be ?). devfs is a very usable patch compatible with most of devices (including LVM) and software (I can only think of vmware that doesn't run with vmware). it saves a lot of inodes in /dev and contains only devices really present in the system and uses intelligent backward-compatible naming scheme (so you can still use inodes like /dev/sda etc) present in many modern UN*X flavors (like Solaris, e.g.). You should give it at lease a chance before saying you use it only because of raw-devices ;) > If anyone knows about restrictions or some clues I would thank a lot. Regards, -- freddy ----==-- _ Adrien "freddy" Farkas ---==---(_)__ __ ____ __ freddy@sk.oracle.com --==---/ / _ \/ // /\ \/ / We all know Linux is great... It -=====/_/_//_/\___/ /_/\_\ does infinite loops in 5 seconds From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Stephen C. Tweedie" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Message-ID: <14324.58266.920834.895229@dukat.scot.redhat.com> Date: Fri, 1 Oct 1999 17:38:50 +0100 (BST) Subject: Re: [linux-lvm] LVM, raw-io, devfs In-Reply-To: <006201bf0bb7$6eae4a60$030116ac@fd1> References: <006201bf0bb7$6eae4a60$030116ac@fd1> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: Fernando Dammous Cc: Linux LVM msede , Stephen Tweedie Hi, On Thu, 30 Sep 1999 23:48:23 -0300, "Fernando Dammous" said: > Now, I would like to install the devfs and mainly the raw-io. > Can I install them in a kernel 2.0.36, which is already patched with > LVM? I've never tried the raw IO code on 2.0: let me know how it goes! In principle, there is no reason why raw IO on LVM should not work. --Stephen From mboxrd@z Thu Jan 1 00:00:00 1970 Message-Id: <37F4FFCD.6AE2EC3E@mainland.ab.ca> Date: Fri, 01 Oct 1999 12:39:09 -0600 From: Drew Smith Mime-Version: 1.0 Subject: Re: [linux-lvm] LVM, raw-io, devfs References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> Content-Transfer-Encoding: 7bit Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: "Stephen C. Tweedie" , linux-lvm@msede.com Hi, just checking a fact. :) IBM's ADSM(*) (well, TSM now, thanks to Tivoli) uses raw logical volumes on a fairly native level as storage pools, etc. I'm curious, having never looked into raw IO under Linux, whether it's the same principles - and, that said, whether or not IBM will be porting the TSM server to Linux? Regardless, LVM is a huge jump in the right direction if we want IBM to release more schtuff for Linux. Now, I've just got to find a Linux-HSM(**) project to control my optical jukebox. :) Any ideas whether this exists? (apologies for the footnotes, they're there for the benefit of people on the list who don't know these acronyms) *: ADSM: ADSTAR Distributed Storage Management. A highly-cool enterprise backup system, scheduling, etc - IBM's version of Veritas. **: HSM: Heirarchial Storage Management. Basically, take a tape library or jukebox, make a database of everything on every cartridge, and mount that database as a filesystem. Copy something out of it, the library goes and gets the appropriate media and feeds it to the drive. With a 20-cart optical jukebox, this is basically a 20*1.3G filesystem (albiet a fairly slow one, but with a script to copy the file into a temp space, perfect as a low-use fileserver. ADSM does this, but the cost is hefty, to say the least.) Cheers, - Drew. :wq "Stephen C. Tweedie" wrote: > > Hi, > > On Thu, 30 Sep 1999 23:48:23 -0300, "Fernando Dammous" > said: > > > Now, I would like to install the devfs and mainly the raw-io. > > > Can I install them in a kernel 2.0.36, which is already patched with > > LVM? > > I've never tried the raw IO code on 2.0: let me know how it goes! In > principle, there is no reason why raw IO on LVM should not work. > > --Stephen From mboxrd@z Thu Jan 1 00:00:00 1970 Date: Fri, 1 Oct 1999 21:15:13 +0200 From: Luca Berra Subject: Re: [linux-lvm] LVM, raw-io, devfs Message-ID: <19991001211513.D28457@colombina.comedia.it> Reply-To: bluca@comedia.it References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <37F4FFCD.6AE2EC3E@mainland.ab.ca> Mime-Version: 1.0 In-Reply-To: <37F4FFCD.6AE2EC3E@mainland.ab.ca> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: linux-lvm@msede.com On Fri, Oct 01, 1999 at 12:39:09PM -0600, Drew Smith wrote: > Now, I've just got to find a Linux-HSM(**) project to control my > optical jukebox. :) Any ideas whether this exists? Ingo Molnar is doing HSM as part of linux-raid, not working yet afaik L. -- Luca Berra -- bluca@comedia.it Communications Media & Services S.r.l. From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Stephen C. Tweedie" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Message-ID: <14326.7775.34828.234038@dukat.scot.redhat.com> Date: Sat, 2 Oct 1999 16:01:51 +0100 (BST) Subject: Re: [linux-lvm] LVM, raw-io, devfs In-Reply-To: <37F4FFCD.6AE2EC3E@mainland.ab.ca> References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <37F4FFCD.6AE2EC3E@mainland.ab.ca> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: Drew Smith Cc: "Stephen C. Tweedie" , linux-lvm@msede.com Hi, On Fri, 01 Oct 1999 12:39:09 -0600, Drew Smith said: > Now, I've just got to find a Linux-HSM(**) project to control my > optical jukebox. :) Any ideas whether this exists? Not yet, but XFS has all of the support necessary for us to do a kernel DMAPI implementation, which would open up all sorts of HSM possibilities. --Stephen From mboxrd@z Thu Jan 1 00:00:00 1970 Message-ID: <37F62A78.1143C490@geotec.net> Date: Sat, 02 Oct 1999 10:53:28 -0500 From: Eric Smith MIME-Version: 1.0 Subject: Re: [linux-lvm] LVM, raw-io, devfs References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <37F4FFCD.6AE2EC3E@mainland.ab.ca> <14326.7775.34828.234038@dukat.scot.redhat.com> Content-Transfer-Encoding: base64 Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: "Stephen C. Tweedie" Cc: Drew Smith , linux-lvm@msede.com SSd2ZSBiZWVuIHVzaW5nIHRoZSBMaW51eCBBRFNNIHYzIF9jbGllbnRfIGZvciBzb21lIHRp bWUgYnV0IEkndmUgbmV2ZXINCnNlZW4gYSBzZXJ2ZXIgcHJvamVjdC4gIEV2ZW4gdGhlIGNs aWVudCBpcyBzdGlsbCBsaXN0ZWQgYXMgdW5zdXBwb3J0ZWQgZnJvbQ0KSUJNIGFsdGhvdWdo IHlvdSBjYW4gZ2V0IGl0IGZyb20gdGhlbS4gIEl0J3MgYXdlc29tZS4uLndoZXJlJ3MgdGhl DQpzZXJ2ZXI/IT8NCg0KLS1FcmljDQoNCg0KDQoNCg0KDQoNCg0KDQoiU3RlcGhlbiBDLiBU d2VlZGllIiB3cm90ZToNCg0KPiBIaSwNCj4NCj4gT24gRnJpLCAwMSBPY3QgMTk5OSAxMjoz OTowOSAtMDYwMCwgRHJldyBTbWl0aA0KPiA8ZHJld0B3aW50ZXJsYW5kLm1haW5sYW5kLmFi LmNhPiBzYWlkOg0KPg0KPiA+ICAgICAgIE5vdywgSSd2ZSBqdXN0IGdvdCB0byBmaW5kIGEg TGludXgtSFNNKCoqKSBwcm9qZWN0IHRvIGNvbnRyb2wgbXkNCj4gPiBvcHRpY2FsIGp1a2Vi b3guIDopICBBbnkgaWRlYXMgd2hldGhlciB0aGlzIGV4aXN0cz8NCj4NCj4gTm90IHlldCwg YnV0IFhGUyBoYXMgYWxsIG9mIHRoZSBzdXBwb3J0IG5lY2Vzc2FyeSBmb3IgdXMgdG8gZG8g YQ0KPiBrZXJuZWwgRE1BUEkgaW1wbGVtZW50YXRpb24sIHdoaWNoIHdvdWxkIG9wZW4gdXAg YWxsIHNvcnRzIG9mIEhTTQ0KPiBwb3NzaWJpbGl0aWVzLg0KPg0KPiAtLVN0ZXBoZW4NCg== From mboxrd@z Thu Jan 1 00:00:00 1970 Message-ID: <002e01bf0cf8$b4667720$030116ac@fd1> From: "Fernando Dammous" References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> Subject: Re: [linux-lvm] LVM, raw-io, devfs Date: Sat, 2 Oct 1999 14:08:09 -0300 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: "Stephen C. Tweedie" Cc: Linux LVM msede HI Stephen and everybody, > I've never tried the raw IO code on 2.0: let me know how it goes! In > principle, there is no reason why raw IO on LVM should not work. > > --Stephen > I prefer to update my kernel (to 2.3.18 or even to wait for the 2.4), before and then to use RAW-IO. I just hope I can simply alter Oracle to use RAW-IO instead of having reinstall it. Using Oracle with LVM is already very good, with RAW-IO it will be better (I believe). In any way, I thank in advance for your interest (and of all people of here) in helping me in this case. Thank you very much Fernando From mboxrd@z Thu Jan 1 00:00:00 1970 From: pamvdam@ramoth.xs4all.nl Date: Sun, 3 Oct 1999 07:56:44 +0200 Subject: Re: [linux-lvm] LVM, raw-io, devfs Message-ID: <19991003075644.A5224@ladystrange.bluehorizon.nl> References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> Mime-Version: 1.0 In-Reply-To: <002e01bf0cf8$b4667720$030116ac@fd1>; from Fernando Dammous on Sat, Oct 02, 1999 at 02:08:09PM -0300 Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: Fernando Dammous Cc: "Stephen C. Tweedie" , Linux LVM msede On Sat, Oct 02, 1999 at 02:08:09PM -0300, Fernando Dammous wrote: > I prefer to update my kernel (to 2.3.18 or even to wait for the 2.4), before > and then to use RAW-IO. > I just hope I can simply alter Oracle to use RAW-IO instead of having > reinstall it. > Using Oracle with LVM is already very good, with RAW-IO it will be better (I > believe). I do question that. Sybase somehow needs (or better prefers) RAW-IO to ensure it's structural integrity. If the buffer cache is between the data transfer of the LOG and the physical device it is possible that not all of the log that should be written out is written out, however Sybase thinks it has been written to disk. RAW-IO/direct IO ensures that the LOG that has been ordered to be written on disk will be written to disk. I would like to emphasize that not using RAW-IO will not impose corrupting your database. It imposes that there's a risk of loosing your data in case of a failure. Oracle has always been using filesystems for it's datastorage. Only for the parrallel server configuration they demand RAW IO. Like Sybase 11.9.x under Linux it probably uses some O_SYNC flag to write to log, so the write call only returns when the data has been really written to the physical device. I don't think you'll see a performance enhancement when using Oracle and RAW/IO. There's even a chance, due to the fact you mis the buffer cache optimisations, that you'll see a performance degradation. This is a common misunderstanding. Best regards, Pascal van Dam > In any way, I thank in advance for your interest (and of all people of here) > in helping me in this case. > > Thank you very much > > Fernando > > From mboxrd@z Thu Jan 1 00:00:00 1970 Date: Sun, 3 Oct 1999 12:14:15 +0200 From: Adrien Farkas Subject: Re: [linux-lvm] LVM, raw-io, devfs Message-ID: <19991003121415.A30243@redneck.sk.oracle.com> Reply-To: freddy@sk.oracle.com References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> Mime-Version: 1.0 In-Reply-To: <002e01bf0cf8$b4667720$030116ac@fd1> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: Fernando Dammous Cc: "Stephen C. Tweedie" , Linux LVM msede Fernando Dammous (ferdam@internetcom.com.br) wrote : > HI Stephen and everybody, > > > I've never tried the raw IO code on 2.0: let me know how it goes! In > > principle, there is no reason why raw IO on LVM should not work. > > > > --Stephen > > > > I prefer to update my kernel (to 2.3.18 or even to wait for the 2.4), before > and then to use RAW-IO. > I just hope I can simply alter Oracle to use RAW-IO instead of having > reinstall it. Forget it, Linux port of Oracle DB doesn't support raw-io. > Using Oracle with LVM is already very good, with RAW-IO it will be better (I > believe). -- freddy ----==-- _ Adrien "freddy" Farkas ---==---(_)__ __ ____ __ freddy@sk.oracle.com --==---/ / _ \/ // /\ \/ / We all know Linux is great... It -=====/_/_//_/\___/ /_/\_\ does infinite loops in 5 seconds From mboxrd@z Thu Jan 1 00:00:00 1970 From: Harald Milz Subject: Re: [linux-lvm] LVM, raw-io, devfs Date: 3 Oct 1999 07:43:01 GMT Message-ID: <7t71e5$fmv$1@seneca.muc.de> References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <37F4FFCD.6AE2EC3E@mainland.ab.ca> Reply-To: h.milz@seneca.muc.de Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: linux-lvm@msede.com Drew Smith wrote: > IBM's ADSM(*) (well, TSM now, thanks to Tivoli) uses raw logical > volumes on a fairly native level as storage pools, etc. I'm curious, > having never looked into raw IO under Linux, whether it's the same > principles - and, that said, whether or not IBM will be porting the TSM > server to Linux? I'm working on that one. Ummm... should we launch a petition? I'd be willing to host a web page. -- Don't you feel more like you do now than you did when you came in? From mboxrd@z Thu Jan 1 00:00:00 1970 Message-Id: <4.2.1.9.19991003080618.00a7b500@mail.msy.bellsouth.net> Date: Sun, 03 Oct 1999 08:06:22 -0500 From: Daniel Whicker Subject: Re: [linux-lvm] LVM, raw-io, devfs Mime-Version: 1.0 Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii"; format="flowed" Content-Transfer-Encoding: 7bit To: linux-lvm@msede.com At 02:43 AM 10/3/99 , Harald Milz wrote: >Drew Smith wrote: > > > IBM's ADSM(*) (well, TSM now, thanks to Tivoli) uses raw logical > > volumes on a fairly native level as storage pools, etc. I'm curious, > > having never looked into raw IO under Linux, whether it's the same > > principles - and, that said, whether or not IBM will be porting the TSM > > server to Linux? This is a bit off topic, buy hey. ADSM (TSM) actually gives you the option of using either files or raw i/o. I don't see that there would be any problems with a Linux port of the server. They could simply disable the ability to use raw i/o for your disk storage pools, log volumes, and db volumes. What may pose a problem is the amount of disk space required for a significant ADSM server. If you're looking at a half terabyte or more of disks, you may run into the limit of Linux major/minor numbers for SCSI disks. (Btw: I'm unclear on whether the devfs patch resolves this?) -Daniel ------------------------------------------ Daniel Whicker (heimdall@mail.org) From mboxrd@z Thu Jan 1 00:00:00 1970 Message-ID: <002301bf0dc4$094485e0$030116ac@fd1> From: "Fernando Dammous" References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> <19991003121415.A30243@redneck.sk.oracle.com> Subject: Re: [linux-lvm] LVM, raw-io, devfs Date: Sun, 3 Oct 1999 14:23:38 -0300 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: freddy@sk.oracle.com Cc: "Stephen C. Tweedie" , Linux LVM msede Hi (again!), From: Adrien Farkas > Forget it, Linux port of Oracle DB doesn't support raw-io. I admit that I'm not a deep expert of Oracle, mainly regarding interaction with the I/O devices and with the operating system. However, I have been finding in the documentation of Oracle for Linux, several references of utilization of RAW-DEVICES (among others). I'm not, here, wanting to create controversy, because it is dealt with a matter extra-LVM and being you a member of Oracle (I saw for your e-mail address freddy@sk.oracle.com), you must have knowledge of this subject. Then I ask: What does mean the references about RAW-DEVICES in documentation? To illustrate, I separated some from : Oracle8 Administrator's Reference for LINUX Release 8.0.5 A66585-01 - Tuning of I/O Loads across all Drives I/O loads are tuned across all drives, including drives storing Oracle data in raw devices - Raw Device Sizes Choose a small set of standard sizes for all raw devices that may be used to store Oracle database files. In general, standardizing on a single size is recommended. If a single size is used, raw files can be moved from one partition to another safely. The size should be small enough so that a fairly large number can be created, but large enough to be convenient. For example, a 2 GB drive could be divided into 10 partitions of 200 MB each-a good balance between size and number. Any tablespace using raw devices should stripe them across several drives. If possible, the striping should be done with a Logical Volume Manager." - Tuning the LINUX Buffer Cache Size To take full advantage of raw devices, adjust the size of the Oracle8 buffer cache and, if memory is limited, the LINUX buffer cache. The LINUX buffer cache is provided by the operating system. It holds blocks of data in memory while they are being transferred from memory to disk, or vice versa. The Oracle8 buffer cache is the area in memory that stores the Oracle database buffers. Since Oracle8 can use raw devices, it does not need to use the LINUX buffer cache. When moving to raw devices, increase the size of the Oracle8 buffer cache. If the amount of memory on the system is limited, make a corresponding decrease in the LINUX buffer cache size. The LINUX command vmstat may help you determine which buffer caches should be increased or decreased. ------------------------ Cheers and sorry for the long mail! Fernando From mboxrd@z Thu Jan 1 00:00:00 1970 Date: Mon, 4 Oct 1999 11:28:10 +0200 From: Adrien Farkas Subject: Re: [linux-lvm] LVM, raw-io, devfs Message-ID: <19991004112810.A12899@redneck.sk.oracle.com> Reply-To: freddy@sk.oracle.com References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> <19991003121415.A30243@redneck.sk.oracle.com> <002301bf0dc4$094485e0$030116ac@fd1> Mime-Version: 1.0 In-Reply-To: <002301bf0dc4$094485e0$030116ac@fd1> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: Fernando Dammous Cc: linux-lvm@msede.com Fernando Dammous (ferdam@internetcom.com.br) wrote : > Hi (again!), > > From: Adrien Farkas > > Forget it, Linux port of Oracle DB doesn't support raw-io. > > I admit that I'm not a deep expert of Oracle, mainly regarding interaction > with the I/O devices and with the operating system. > > However, I have been finding in the documentation of Oracle for Linux, > several references of utilization of RAW-DEVICES (among others). > I'm not, here, wanting to create controversy, because it is dealt with a > matter extra-LVM and being you a member of Oracle (I saw for your e-mail > address freddy@sk.oracle.com), you must have knowledge of this subject. Then > I ask: > What does mean the references about RAW-DEVICES in documentation? > To illustrate, I separated some from : > > Oracle8 Administrator's Reference for LINUX > Release 8.0.5 > A66585-01 Oh, I'm sorry, Linux port of Oracle _does_ support raw io, but it depends on Oracle8 release, 8.0.5 does not, 8.0.5.1 (not released for public for free, afaik) and 8i (aka 8.1.5) both do. But definitely, I've never tried it. The last time I was interested in using raw partitions was in the time of 8.0.5, so prehaps that's why I still thought Oracle doesn't support them. > > - Tuning of I/O Loads across all Drives > I/O loads are tuned across all drives, including drives storing Oracle data > in raw devices > > - Raw Device Sizes > Choose a small set of standard sizes for all raw devices that may be used to > store Oracle database files. > > In general, standardizing on a single size is recommended. If a single size > is used, raw files can be moved from one partition to another safely. The > size should be small enough so that a fairly large number can be created, > but large enough to be convenient. > > For example, a 2 GB drive could be divided into 10 partitions of 200 MB > each-a good balance between size and number. Any tablespace using raw > devices should stripe them across several drives. If possible, the striping > should be done with a Logical Volume Manager." > > - Tuning the LINUX Buffer Cache Size > To take full advantage of raw devices, adjust the size of the Oracle8 buffer > cache and, if memory is limited, the LINUX buffer cache. > > The LINUX buffer cache is provided by the operating system. It holds blocks > of data in memory while they are being transferred from memory to disk, or > vice versa. > > The Oracle8 buffer cache is the area in memory that stores the Oracle > database buffers. Since Oracle8 can use raw devices, it does not need to use > the LINUX buffer cache. > > When moving to raw devices, increase the size of the Oracle8 buffer cache. > If the amount of memory on the system is limited, make a corresponding > decrease in the LINUX buffer cache size. > > The LINUX command vmstat may help you determine which buffer caches should > be increased or decreased. > > ------------------------ > > Cheers and sorry for the long mail! > Fernando > -- freddy ----==-- _ Adrien "freddy" Farkas ---==---(_)__ __ ____ __ freddy@sk.oracle.com --==---/ / _ \/ // /\ \/ / We all know Linux is great... It -=====/_/_//_/\___/ /_/\_\ does infinite loops in 5 seconds From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Stephen C. Tweedie" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Message-ID: <14328.33999.21844.718869@dukat.scot.redhat.com> Date: Mon, 4 Oct 1999 11:43:27 +0100 (BST) Subject: Re: [linux-lvm] LVM, raw-io, devfs In-Reply-To: <19991003075644.A5224@ladystrange.bluehorizon.nl> References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> <19991003075644.A5224@ladystrange.bluehorizon.nl> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: pamvdam@ramoth.xs4all.nl Cc: Fernando Dammous , "Stephen C. Tweedie" , Linux LVM msede Hi, On Sun, 3 Oct 1999 07:56:44 +0200, pamvdam@ramoth.xs4all.nl said: > Oracle has always been using filesystems for it's datastorage. Only for > the parrallel server configuration they demand RAW IO. Like Sybase 11.9.x > under Linux it probably uses some O_SYNC flag to write to log, so the > write call only returns when the data has been really written to the > physical device. I don't think you'll see a performance enhancement when > using Oracle and RAW/IO. There's even a chance, due to the fact you mis > the buffer cache optimisations, that you'll see a performance > degradation. It depends. Raw IO uses less CPU --- much less in some cases. It also avoids polluting memory with extra copies of data in the buffer cache. As a result, just measuring the pure disk bandwidth of raw IO versus buffered IO does not tell you the whole story about performance: you really need to measure the application's performance itself, including the effect of CPU and memory pressure. --Stephen From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Stephen C. Tweedie" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Message-ID: <14328.34042.98060.32085@dukat.scot.redhat.com> Date: Mon, 4 Oct 1999 11:44:10 +0100 (BST) Subject: Re: [linux-lvm] LVM, raw-io, devfs In-Reply-To: <19991003121415.A30243@redneck.sk.oracle.com> References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> <19991003121415.A30243@redneck.sk.oracle.com> Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" To: freddy@sk.oracle.com Cc: Fernando Dammous , "Stephen C. Tweedie" , Linux LVM msede Hi, On Sun, 3 Oct 1999 12:14:15 +0200, Adrien Farkas said: > Forget it, Linux port of Oracle DB doesn't support raw-io. I believe that the current Oracle-8i release supports Linux raw IO out of the box. --Stephen From mboxrd@z Thu Jan 1 00:00:00 1970 From: pamvdam@ramoth.xs4all.nl Date: Mon, 4 Oct 1999 13:03:12 +0200 Subject: Re: [linux-lvm] LVM, raw-io, devfs Message-ID: <19991004130312.A19918@ladystrange.bluehorizon.nl> References: <006201bf0bb7$6eae4a60$030116ac@fd1> <14324.58266.920834.895229@dukat.scot.redhat.com> <002e01bf0cf8$b4667720$030116ac@fd1> <19991003075644.A5224@ladystrange.bluehorizon.nl> <14328.33999.21844.718869@dukat.scot.redhat.com> Mime-Version: 1.0 In-Reply-To: <14328.33999.21844.718869@dukat.scot.redhat.com>; from Stephen C. Tweedie on Mon, Oct 04, 1999 at 11:43:27AM +0100 Sender: owner-linux-lvm Errors-To: owner-linux-lvm List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: "Stephen C. Tweedie" Cc: pamvdam@ramoth.xs4all.nl, Fernando Dammous , Linux LVM msede On Mon, Oct 04, 1999 at 11:43:27AM +0100, Stephen C. Tweedie wrote: > Hi, > > On Sun, 3 Oct 1999 07:56:44 +0200, pamvdam@ramoth.xs4all.nl said: > > > Oracle has always been using filesystems for it's datastorage. Only for > > the parrallel server configuration they demand RAW IO. Like Sybase 11.9.x > > under Linux it probably uses some O_SYNC flag to write to log, so the > > write call only returns when the data has been really written to the > > physical device. I don't think you'll see a performance enhancement when > > using Oracle and RAW/IO. There's even a chance, due to the fact you mis > > the buffer cache optimisations, that you'll see a performance > > degradation. > > It depends. Raw IO uses less CPU --- much less in some cases. It also > avoids polluting memory with extra copies of data in the buffer cache. > As a result, just measuring the pure disk bandwidth of raw IO versus > buffered IO does not tell you the whole story about performance: you > really need to measure the application's performance itself, including > the effect of CPU and memory pressure. You're right. I did oversee the buffercache pollution issue. Thanks for pointing it out. Best regards, Pascal > > --Stephen