Re: Mysql and filesystems question

2007-10-29 Thread David Campbell
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

Re: Mysql and filesystems question

2007-10-29 Thread Ali Nebi
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. -- MySQL General Mailing List F

Re: Mysql and filesystems question

2007-10-28 Thread Craig Huffstetler
You seemed to have answered your own question. What did you mean to ask? On 10/28/07, B. Keith Murphy <[EMAIL PROTECTED]> 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

Re: Mysql and filesystems question

2007-10-28 Thread B. Keith Murphy
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 system

Re: Mysql and filesystems question

2007-10-28 Thread B. Keith Murphy
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 wan

Mysql and filesystems question

2007-10-28 Thread Ali Nebi
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 advance

Re: MySQL and Filesystems

2002-07-29 Thread Jeremy Zawodny
On Thu, Jul 25, 2002 at 12:07:48PM -0300, João Paulo Vasconcellos wrote: > Hello everybody, > > someone can tell me the best FS to run MyISAM along with InnoDB tables ? I don't know that there is a "best" one, but I use ReiserFS and it works quite well. I'd stay away from a non-journaling fil

MySQL and Filesystems

2002-07-25 Thread João Paulo Vasconcellos
Hello everybody, someone can tell me the best FS to run MyISAM along with InnoDB tables ? SQL - For you-know-who -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Be