Re: what journal options should I use on linux?

"Kevin Burton" <[email protected]> Thu, 8 Mar 2007 23:35:56 -0800
Newsgroups gmane.comp.db.mysql.general,gmane.comp.db.mysql.benchmarks
Message-ID <[email protected]>
------=_Part_134968_21935385.1173425756096
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Just use XFS......... it's a solve problem......

Kevin

On 3/8/07, Christopher A. Kantarjiev <[email protected]> wrote:
>
> I'm setting up mysql on linux for the first time (have been using OpenBSD
> and
> NetBSD with UFS until now). The default file system is ext3fs, and I don't
> mind
> that, but it seems really silly to use a journaled file system for the
> database
> data - doubling my writes.
>
> In particular, I have a couple of use cases where I spend a week or so
> creating
> a 17GB data (table) file and its 15GB index file, and then do sparse
> queries out
> of it. I need as much write speed as I can get. I certainly don't want to
> have
> every data block written twice, once to the journal and once to the file,
> along
> with the extra seeks.
>
> What do people with this sort of large problem use on Linux?
>
> Thanks,
> chris
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[email protected]
>
>


-- 
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078

------=_Part_134968_21935385.1173425756096--