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 s

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

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 ( with

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