Hi,

i want to ask for your opinions about the best combination for mysql
with filesystem (like ext2, ext3... and so on).

We have problems with mysql under fedora 6 with ext3 and i want to
know under wich filesystem mysql works best.

I will be glad to read your opinions.

Thanks in advanced.
Regards, Ali Nebi!

In production we use both reiserfs and xfs. I am migrating our data
partitions for mysql because it has faster write rates than reiserfs.
You need to stop using fedora and at least use CentOS. Fedora is not
stable for production work.

Just my two cents

Keith

Ali Nebi wrote:
> Hi,
>
> i want to ask for your opinions about the best combination for mysql
> with filesystem (like ext2, ext3... and so on).
>
> We have problems with mysql under fedora 6 with ext3 and i want to
> know under wich filesystem mysql works best.
>
> I will be glad to read your opinions.
>
> Thanks in advanced.
> Regards, Ali Nebi!
>

I dashed off this email too fast. What I meant to say was "I am
migrating our data partitions for MySQL from reiserfs to xfs because xfs
has faster write rates than reiserfs.


Craig Huffstetler wrote:
> I agree, Fedora is not very good at production work. Reiserfs is one
> of the best file systems I have come across for MySQL Production.
>
> On 10/28/07, *B. Keith Murphy * <bmurphy@paragon-cs.com
> <mailto:bmurphy@paragon-cs.com>> wrote:
>
> In production we use both reiserfs and xfs. I am migrating our data
> partitions for mysql because it has faster write rates than reiserfs.
> You need to stop using fedora and at least use CentOS. Fedora is not
> stable for production work.
>
> Just my two cents
>
> Keith
>
> Ali Nebi wrote:
> > Hi,
> >
> > i want to ask for your opinions about the best combination for mysql
> > with filesystem (like ext2, ext3... and so on).
> >
> > We have problems with mysql under fedora 6 with ext3 and i want to
> > know under wich filesystem mysql works best.
> >
> > I will be glad to read your opinions.
> >
> > Thanks in advanced.
> > Regards, Ali Nebi!
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=c...tler@gmail.com
>
>

You seemed to have answered your own question. What did you mean to ask?

On 10/28/07, B. Keith Murphy <bmurphy@paragon-cs.com> wrote:
>
> I dashed off this email too fast. What I meant to say was "I am
> migrating our data partitions for MySQL from reiserfs to xfs because xfs
> has faster write rates than reiserfs.
>
>
> Craig Huffstetler wrote:
> > I agree, Fedora is not very good at production work. Reiserfs is one
> > of the best file systems I have come across for MySQL Production.
> >
> > On 10/28/07, *B. Keith Murphy * <bmurphy@paragon-cs.com
> > <mailto:bmurphy@paragon-cs.com>> wrote:
> >
> > In production we use both reiserfs and xfs. I am migrating our data
> > partitions for mysql because it has faster write rates than
> reiserfs.
> > You need to stop using fedora and at least use CentOS. Fedora is
> not
> > stable for production work.
> >
> > Just my two cents
> >
> > Keith
> >
> > Ali Nebi wrote:
> > > Hi,
> > >
> > > i want to ask for your opinions about the best combination for
> mysql
> > > with filesystem (like ext2, ext3... and so on).
> > >
> > > We have problems with mysql under fedora 6 with ext3 and i want to
> > > know under wich filesystem mysql works best.
> > >
> > > I will be glad to read your opinions.
> > >
> > > Thanks in advanced.
> > > Regards, Ali Nebi!
> > >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=c...tler@gmail.com
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=c...tler@gmail.com
>
>

Thanks for the answer

Yes, you are right about fedora. I forgot to tell that we are moving the
servers to CentOS 5 now i think also that other important thing that
i forgot to tell is that our databases use INNODB engine.

i'm waiting for other opinions.

B. Keith Murphy wrote:
> I dashed off this email too fast. What I meant to say was "I am
> migrating our data partitions for MySQL from reiserfs to xfs because xfs
> has faster write rates than reiserfs.

Those fast writes come at a price.

There is no way I'd have any important data on XFS.

Dave