The secure mode in InnoDB

2002-10-07 Thread Dyego Souza do Carmo
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

The secure mode in InnoDB

2002-10-07 Thread Dyego Souza do Carmo
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

Re: The secure mode in InnoDB

2002-10-07 Thread Jeremy Zawodny
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

Re: The secure mode in InnoDB

2002-10-07 Thread Heikki Tuuri
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