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: <mysql@lists.mysql.com>; <[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]
