Messages in this thread | | | Date | Sat, 10 Nov 2001 17:56:53 +0000 | From | Arjan van de Ven <> | Subject | Re: Numbers: ext2/ext3/reiser Performance (ext3 is slow) |
| |
On Sat, Nov 10, 2001 at 06:41:15PM +0100, Oktay Akbal wrote:
> The question is, when to use what mode. I would use data=journal on my > CVS-Archive, and maybe writeback on a news-server.
sounds right; add to this that sync NFS mounts also are far better of with data=journal.
> But what to use for an database like mysql ?
Well you used reiserfs before. data=writeback is equivalent to the protection reiserfs offers. Big databases such as Oracle do their own journalling and will make sure transactions are actually on disk before they finalize the transaction to the requestor. mysql... I'm not sure about, and it also depends on if it's a mostly-read-only database, a mostly-write database or a "mixed" one. In the first cases, mounting "sync" with full journalling will ensure full datasafety; the second case might just be faster with full journalling (full journalling has IO clustering benefits for lots of small, random, writes) but for the mixed case it's a matter of reliablity versus performance.....
Greetings, Arjan van de Ven - To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/
| |