List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:February 7 2012 8:19pm
Subject:Re: Filesystem choice
View as plain text  
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 <mdykman@stripped>

> 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 <sattia@stripped> wrote:
> > 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-statement.html
> >
>
> http://www.enterprisestorageforum.com/storage-technology/the-future-of-storage-devices-and-tiering-software.html
> >
>
> http://www.enterprisestorageforum.com/storage-hardware/linux-file-system-fsck-testing----the-results-are-in.html
> >
> > Regards
> > Sameh Attia
> > --
> > - Failure is not an option; it is a built-in feature in Windows.
> > - The two basic principles of system administration:
> >
> >  * For minor problems, reboot
> >  * For major problems, reinstall
> >
> > dc -e
> >
> '603178305900664311156641389051003470569569613466992253686426210705237258P'
> >
> >
> > On Tue, Feb 7, 2012 at 8:31 PM, List Man <list.man@stripped>
> wrote:
> >
> >> Ext4 is faster to me.
> >>
> >>
> >> LS
> >>
> >>
> >>
> >> ----- Original Message -----
> >> From: "rickytato rickytato" <rickytato@stripped>
> >> To: mysql@stripped
> >> 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, and 4x 300GB SAS
> 15krpm
> >> raid10 with perc700 512MB raid controller.
> >>
> >> I've to chosse between xfs and ext4; ext4 with
> >>
> >>
> noatime,nodiratime,data=writeback,barrier=0,nobh,commit=100,errors=remount-ro
> >>
> >> and formatted with
> >> -b 4096 -E stride=16,stripe-width=32
> >>
> >> is right choice or nobarrier is too unsafe? Only for mysql partition,
> non
> >> for the root.
> >>
> >>
> >> rr
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:    http://lists.mysql.com/mysql
> >>
> >>
>
>
>
> --
>  - michael dykman
>  - mdykman@stripped
>
>  May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Claudio

Thread
Filesystem choicerickytato rickytato7 Feb
  • Re: Filesystem choiceList Man7 Feb
    • Re: Filesystem choiceMichael Dykman7 Feb
      • Re: Filesystem choiceSinger X.J. Wang7 Feb
    • Re: Filesystem choiceSameh Attia7 Feb
      • Re: Filesystem choiceMichael Dykman7 Feb
        • Re: Filesystem choiceClaudio Nanni7 Feb
          • Re: Filesystem choiceMichael Dykman7 Feb