Re: fastest filesystem for MySQL

2004-05-14 Thread Curtis Maurand
Reiser is good for lots of small files. ext3 would is better for large ones. At least that's what I get from the benchmark data that I've seen posted in various places. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Wed, 12 May 2004, Roy Butler wrote: Jacob, I'd go

Re: fastest filesystem for MySQL

2004-05-14 Thread Tim Cutts
On 14 May 2004, at 4:37 am, Roy Butler wrote: 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 lat

Re: fastest filesystem for MySQL

2004-05-13 Thread Roy Butler
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 di

Re: fastest filesystem for MySQL

2004-05-13 Thread Peter J Milanese
Tim Cutts <[EMAIL PROTECTED]>, Jacob Friis Larsen <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: Re: fastest filesystem for MySQL On Thu, May 13, 2004 at 11:16:18AM -0400, Peter J Milanese wrote: > Does the filesystem matter as much as disk throughput? I&#x

Re: fastest filesystem for MySQL

2004-05-13 Thread Jeremy Zawodny
On Thu, May 13, 2004 at 11:16:18AM -0400, Peter J Milanese wrote: > Does the filesystem matter as much as disk throughput? I'd imagine that > is where the bottleneck would be, at least as I've seen... Throughput or seek time? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Y

Re: fastest filesystem for MySQL

2004-05-13 Thread Peter J Milanese
ECTED] Subject:Re: fastest filesystem for MySQL On 13 May 2004, at 4:02 pm, Jacob Friis Larsen wrote: >> I'd go with Reiser on SuSE. > > What about Reiser on Debian? > It shouldn't matter too much. This functionality is in the kernel, so if the ker

Re: fastest filesystem for MySQL

2004-05-13 Thread Tim Cutts
On 13 May 2004, at 4:02 pm, Jacob Friis Larsen wrote: I'd go with Reiser on SuSE. What about Reiser on Debian? It shouldn't matter too much. This functionality is in the kernel, so if the kernel version on SuSE and Debian is the same, the filesystem code will be the same, with the possible cav

Re: fastest filesystem for MySQL

2004-05-13 Thread Jacob Friis Larsen
I'd go with Reiser on SuSE. What about Reiser on Debian? Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fastest filesystem for MySQL

2004-05-13 Thread Jeremy Zawodny
On Thu, May 13, 2004 at 10:21:15AM +0200, JFL wrote: > > The InnoDB storage engine can use raw disks without a filesystem. > > Would that be the fastest possible setup? Probably, yes. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jere

Re: fastest filesystem for MySQL

2004-05-13 Thread JFL
The InnoDB storage engine can use raw disks without a filesystem. Would that be the fastest possible setup? Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fastest filesystem for MySQL

2004-05-12 Thread Roy Butler
Jacob, I'd go with Reiser on SuSE. Like Sasha mentioned though, the filesystem component may have little overall effect, depending on your set-up. I'd stay away from XFS when working with databases, as its performance gains are achieved via extended write delays while the queue sits in main

Re: fastest filesystem for MySQL

2004-05-12 Thread Jeremy Zawodny
On Wed, May 12, 2004 at 12:39:59PM -0500, Chris W wrote: > I thouught I read somewhere a while back that MySQL was working on an > option to create a MySQL partition so as to avoide all OS filesystem > overhead to speed things up and I think to save a small bit of over > head. Is this true? Th

Re: fastest filesystem for MySQL

2004-05-12 Thread Chris W
I thouught I read somewhere a while back that MySQL was working on an option to create a MySQL partition so as to avoide all OS filesystem overhead to speed things up and I think to save a small bit of over head. Is this true? Chris W. -- Bring Back the HP 15C http://hp15c.org:8080 If you don'

Re: fastest filesystem for MySQL

2004-05-12 Thread Daniel Kasak
Sasha Pachev wrote: Based on what I've seen so far, JFS and XFS do not yet have a solid track record of stability with MySQL. This does not mean they could not be good - I just do not trust them yet. I do vaguely remember a support case when a very strange corruption happened on either one of

Re: fastest filesystem for MySQL

2004-05-11 Thread Sasha Pachev
Robert J Taylor wrote: 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 f

Re: fastest filesystem for MySQL

2004-05-11 Thread JFL
>> 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. >> Completely depends on your situation -- big files, small files? Lots of writes or reads or both? Growing tables/f

Re: fastest filesystem for MySQL

2004-05-11 Thread 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