[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: fastest filesystem for MySQL
From:       Roy Butler <roy.butler () jpl ! nasa ! gov>
Date:       2004-05-14 3:37:56
Message-ID: 40A43F14.9040902 () jpl ! nasa ! gov
[Download RAW message or body]

Jacob,

 >> I'd go with Reiser on SuSE.
 >
 > What about Reiser on Debian?

I'd choose SuSE since Reiser is their default filesystem and they have 
been an early implementor of Reiser-related patches.  If you use Linux 
kernel 2.4.24 (or later) and the latest 3.6 series of ReiserFS+tools, 
the Linux distribution you choose shouldn't technically matter.  I'm 
under the impression that Debian isn't bleeding-edge in many respects, 
perhaps due to its support of so many architectures, so you might have 
to build all of this yourself (or find someone who has) if you go that 
route.

In regard to using raw disks under the InnoDB storage engine, if it's 
I/O code is of the same quality as the filesystems we're discussing, 
it'll almost necessarily be faster.  Again, you'll probably be your own 
best judge and panel.  If you do perform benchmarks, you'll probably 
want to perform reboots (at a minimum) between tests to bypass caching 
effects - unless that's what you're trying to test. :)  I'd be 
interested in hearing what you discover.


Roy


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]