Re: best filesystem for mysql

2007-05-02 Thread Jeremy Cole 

Hi Jeff,

There isn't really a clear winner in any case, but the tests done in the 
article linked to are highly suspect.  It would be much more interesting 
to see real tests done with real hardware...


Nonetheless, the usual answer I would have is to lean towards ease of 
administration and good understanding, rather than getting 1% better 
performance.  That usually means ext3.


Regards,

Jeremy

Jeff Pang wrote:

hello list,

I saw this article for the suitable filesystem for mysql.
http://www.bullopensource.org/ext4/sqlbench/


From what I saw,the best filesystem for MyISAM is ext3,the best filesystem for 
InnoDB is Reiserfs.

How about your thought on it?Thanks.

50€ AMAZON-Einkaufsgutschein bei Bestellung von Arcor-DSL:
Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren
ohne Zeit- und Volumenbegrenzung? DAS TOP ANGEBOT JETZT bei Arcor: günstig
und schnell mit DSL - das All-Inclusive-Paket für clevere Doppel-Sparer,
nur  39,85 €  inkl. DSL- und ISDN-Grundgebühr!
http://www.arcor.de/rd/emf-dsl-2



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

best filesystem for mysql

2007-05-01 Thread Jeff Pang 
hello list,

I saw this article for the suitable filesystem for mysql.
http://www.bullopensource.org/ext4/sqlbench/

From what I saw,the best filesystem for MyISAM is ext3,the best filesystem for 
InnoDB is Reiserfs.
How about your thought on it?Thanks.

50€ AMAZON-Einkaufsgutschein bei Bestellung von Arcor-DSL:
Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren
ohne Zeit- und Volumenbegrenzung? DAS TOP ANGEBOT JETZT bei Arcor: günstig
und schnell mit DSL - das All-Inclusive-Paket für clevere Doppel-Sparer,
nur  39,85 €  inkl. DSL- und ISDN-Grundgebühr!
http://www.arcor.de/rd/emf-dsl-2

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

Best filesystem for MySQL ?

2002-06-26 Thread Sébastien DIDIER 

Hi,

I wonder which is the best filesystem to use with MySQL (to increase
performances). And which mounting option should be used ?
According to the documentation, the best system is SuSE Linux 7.1, 2.4
kernel, and ReiserFS. I currently use  ReiserFs with noatime option. But it
seems (according to benchmarks) that this filesystem is slower for big files
and reading opération ?

I believe that MySQL needs fast creating/deleting files operation during
temporary table creation by example but also needs fast reading when
extracting lots of rows from a big table.

What's your opinion ? Is Reiser the best or may it be ext3, xfs or another
FS?

Thanks,

Sébastien
sql, query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php