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--