what is the major secure mode to use innodb ? ( min time to write data
in disk )
innodb_flush_log_at_trx_commit=0 ?
or
innodb_flush_log_at_trx_commit=1 ?
or
innodb_flush_log_at_trx_commit=2 ?
My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and
linux 2.4 ( with ReiserFS ) :D
Hello Heikki !
what is the best secure mode to use innodb ? ( min time to write data
in disk )
innodb_flush_log_at_trx_commit=0 ?
or
innodb_flush_log_at_trx_commit=1 ?
or
innodb_flush_log_at_trx_commit=2 ?
My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and
linux 2.4
On Mon, Oct 07, 2002 at 01:53:25PM -0300, Dyego Souza do Carmo wrote:
Hello Heikki !
what is the best secure mode to use innodb ? ( min time to write data
in disk )
You're confusing two ideas. The most secure (reliable) is 1. The
fastest is 0. You can't have both.
Jeremy
--
Jeremy D
Hi!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Dyego Souza do Carmo [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 10:10 PM
Subject: Re: The secure mode in InnoDB
On Mon, Oct 07, 2002 at 01:53:25PM -0300