I have a mysql database which is getting a smidge larger than was
originally intended, as a result the file that stores the main database is
getting big.

The way I understand it ext2 files can't be larger than 2gb. Is this right?

I need a file system that can handle files up to 10gb in size. (I am not
going to convert the database into some other form like postgre as we have
lots of stuff using it that we don't want to have to re-write).

So far my options are Reiser.... I am willing to change the kernel to what
ever is best for the file system that gets used.

The system is a i686 and the database is living on an EIDE hd. Can someone
prod me in the right direction.

Cheers,

Mat

It is my understanding that, although ReiserFS has support for files > 2gb,
it has the best performance when using lots and lots of small files. OTOH, I
haven't read any benchmark where they said this or that FS clearly wins hands
down compared to other FS's. So ReiserFS is probably a good choice.

But don't hesitate on checking out, there are lots of benchmarks out there
(sorry, I have no URLs laying around at this moment) where ext2, ext3, JFS,
XFS and ReiserFS are compared to each other.

--
  SwifT
  |- LUG : http://www.lugwv.be
  |- PGP Key-# : 0xCDBA2FDB
  `- "Happy Linux-user :)"

No, in the sense that the problem is not the filesystem flavor.

See
  http://www.suse.de/~aj/linux_lfs.html

--
Paul Kimoto
This message was originally posted on Usenet in plain text.  Any images,
hyperlinks, or the like shown here have been added without my consent,
and may be a violation of international copyright law.