Re: Filesystem choice

2012-02-07 Thread Michael Dykman
Thank you for that Claudio. To be fair, we studied them a few years ago for a high-traffic website we were migrating from 4.0 to 5.0. The proof-of-concept was sound and tested well but concerns from the sysadmin team kept that model from going to production. Again, I did not mean that to appear

Re: Filesystem choice

2012-02-07 Thread Claudio Nanni
Micheal, I have the feeling that no one on this planet uses raw devices with mysql, I might be wrong but I think InnoDB is kind of 'optimized' to leverage the filesystem facilities, but I would really like an InnoDB expert opinion here. Claudio 2012/2/7 Michael Dykman > In the case of using ra

Re: Filesystem choice

2012-02-07 Thread Michael Dykman
In the case of using raw devices (which I'm not really sold on in general, but there are cases when performance is all), we ran our backups from a slave replica. On Tue, Feb 7, 2012 at 1:42 PM, Sameh Attia wrote: > Hi, >   Check these: > > http://www.enterprisestorageforum.com/storage-hardware/te

Re: Filesystem choice

2012-02-07 Thread Singer X.J. Wang
I highly recommend against Raw Devices.. You're extremely limiting your backup options in this case.. S On Tue, Feb 7, 2012 at 13:39, Michael Dykman wrote: > If what you are looking for is performance optimization, you might > want to consider: > > http://dev.mysql.com/doc/refman/5.5/en/innodb

Re: Filesystem choice

2012-02-07 Thread Sameh Attia
Hi, Check these: http://www.enterprisestorageforum.com/storage-hardware/test-plan-for-linux-file-system-fsck-testing.html http://www.enterprisestorageforum.com/sans/features/article.php/3749926 http://www.enterprisestorageforum.com/storage-hardware/the-state-of-file-systems-technology-problem-s

Re: Filesystem choice

2012-02-07 Thread Michael Dykman
If what you are looking for is performance optimization, you might want to consider: http://dev.mysql.com/doc/refman/5.5/en/innodb-raw-devices.html - michael dykman On Tue, Feb 7, 2012 at 1:31 PM, List Man wrote: > Ext4 is faster to me. > > > LS > > > > - Original Message - > From: "ri

Re: Filesystem choice

2012-02-07 Thread List Man
Ext4 is faster to me. LS - Original Message - From: "rickytato rickytato" To: mysql@lists.mysql.com Sent: Tuesday, February 7, 2012 1:19:32 PM Subject: Filesystem choice Hi, I'm my new server I've to decided what filesystem to used. The server are dual amd six core 2.4GHz, 32GB ram,