Re: fastest filesystem for MySQL

[Robert J Taylor]

Completely depends on your situation -- big files, small files? Lots of 
writes or reads or both? Growing tables/files or lots of large dropped 
tables?

If you're into small files, go Reiser. Big data, JFS or XFS.  

EXT3 is slow, but, IIRC, it also is a true data journaling filesystem 
while some of the others aren't (and that's as deep as I go without a 
life-vest, if you know what I mean!).

Just saw this on LWN.net:

Benchmarks of EXT2, EXT3, JFS, XFS in various unreal stressful 
scenarios. Interesting, anyway:

http://209.81.41.149/~jpiszcz/index.html

Robert J Taylor
[EMAIL PROTECTED]
JFL wrote:

I've heard and read that the Reiser filesystem should be better for 
MySQL than Ext3. Is this still true?

We will be running MySQL on either Red Hat ES 3, Suse or Debian.

Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]