Re: innodb filesystem on software raid

2004-07-10 Thread Justin Swanhart
I highly recommend simply using ext3 for your Linux setup. The 1 or 2 percent performance benefit that you may get from raw partitions is way outweighed by complexness of backups of the raw data. either way: First I would suggest you read the Linux RAID howto: http://www.tldp.org/HOWTO/Software-

Re: InnoDB filesystem

2004-05-14 Thread Tim Cutts
On 14 May 2004, at 1:14 am, Dathan Vance Pattishall wrote: -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 4:03 PM To: Dathan Vance Pattishall Cc: 'Tim Cutts'; 'MySQL List' Subject: Re: InnoDB filesystem On Thu, May 13

Re: InnoDB filesystem

2004-05-13 Thread Jeremy Zawodny
On Fri, May 14, 2004 at 01:40:37PM +1000, Chris Nolan wrote: > Jeremy Zawodny wrote: > > > > >I think that the problem is that it's *not* a 64 bit OS. It's just an > >Intel 32bit box with > 4GB of memory. And sine MySQL doesn't do PAE, > >it'll never see that extra memory. > > > > Didn't InnoD

Re: InnoDB filesystem

2004-05-13 Thread Chris Nolan
Jeremy Zawodny wrote: On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote: -Original Message- From: Tim Cutts [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 7:11 AM To: MySQL List Subject: Re: InnoDB filesystem On 13 May 2004, at 3:34 pm, Dan Nelson wrote

RE: InnoDB filesystem

2004-05-13 Thread Dathan Vance Pattishall
> -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 13, 2004 4:03 PM > To: Dathan Vance Pattishall > Cc: 'Tim Cutts'; 'MySQL List' > Subject: Re: InnoDB filesystem > > On Thu, May 13, 2004 at 04:

Re: InnoDB filesystem

2004-05-13 Thread Jeremy Zawodny
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote: > > > -Original Message- > > From: Tim Cutts [mailto:[EMAIL PROTECTED] > > Sent: Thursday, May 13, 2004 7:11 AM > > To: MySQL List > > Subject: Re: InnoDB filesystem > > &

RE: InnoDB filesystem

2004-05-13 Thread Dathan Vance Pattishall
> -Original Message- > From: Tim Cutts [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 13, 2004 7:11 AM > To: MySQL List > Subject: Re: InnoDB filesystem > > > On 13 May 2004, at 3:34 pm, Dan Nelson wrote: > > >>> Pros: performance and bypassing

Re: InnoDB filesystem

2004-05-13 Thread Tim Cutts
On 13 May 2004, at 3:34 pm, Dan Nelson wrote: Pros: performance and bypassing the filesystem cache. I believe most OSes support direct file access which either bypasses or minimizes cache effects, and InnoDB will enable it if possible. Solaris direct file I/O performance on UFS is within a couple

Re: InnoDB filesystem

2004-05-13 Thread Dan Nelson
In the last episode (May 13), JFL said: > >>I've been told that InnoDB on a raw partition is the fastest setup. > > > >Actually, you've been told that it's probably the fastest. > > Correct. Sorry :) > > >Check the InnoDB docs. They explain how to setup raw disk > >partitions. You'll be using d

Re: InnoDB filesystem

2004-05-13 Thread JFL
I've been told that InnoDB on a raw partition is the fastest setup. Actually, you've been told that it's probably the fastest. Correct. Sorry :) Check the InnoDB docs. They explain how to setup raw disk partitions. You'll be using device names, not mount points. Thanks. I forgot to check the man

Re: InnoDB filesystem

2004-05-13 Thread Jeremy Zawodny
On Thu, May 13, 2004 at 11:00:17AM +0200, JFL wrote: > I've been told that InnoDB on a raw partition is the fastest setup. Actually, you've been told that it's probably the fastest. > To setup my system for this, could I create a partition called /innodb > and adjust the my.cnf like this? > > i