Re: what journal options should I use on linux?

Enabling journaling isn't going to halve your performance. Remember, a journal is a record of what happened. It is only added to, 
not updated, so while there is overhead, performance is fairly good. ext3 also has a few different journaling optins.

Journaling is mainly for quick recovery and corruption prevention in case of a crash. This is something you would want your OS 
running on. If you can live with your database getting corrupted and can live with the time it would take to restore a backup, then 
you can forgoe journaling.
I would create a partition for you OS and then a partition for your data. One can be journalled, the other not. You can even 
optimize the block size on the partition for your data, or use a different file system for your data partition altogether.

Here is an interesting article to read on ext3 journaling overhead.
http://www-128.ibm.com/developerworks/library/l-fs8.html

----- Original Message ----- 
From: "Christopher A. Kantarjiev" <[email protected]>
To: <[email protected]>; <[email protected]>
Sent: Thursday, March 08, 2007 10:49 PM
Subject: what journal options should I use on linux?


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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[email protected]