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, 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 is right. 1 is the only option which calls fsync after each log write
at trx commit. An fsync flushes the log to disk, at least in theory.

For most users who need high speed, 2 is the best option starting from
3.23.52. It writes the log buffer to the log file at each commit. You will
not lose committed transactions in a pure mysqld process crash as long as
your OS does not crash, or there is no power outage. That is because the OS
file cache is not lost in a pure mysqld crash.

> Jeremy

Regards,

Heikki

sql query


> --
> Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
>
> MySQL 3.23.51: up 62 days, processed 1,331,355,814 queries (246/sec. avg)



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




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. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 62 days, processed 1,331,355,814 queries (246/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




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 ReiserFS ) :D


sql,query,mysql !


-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- 
$ look into "my eyes"
look: cannot open my eyes
-
   Reply: [EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




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





-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- 
$ look into "my eyes"
look: cannot open my eyes
-
   Reply: [EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php