Setting this option is a trade-off between your durability requirement
and performance requirement.
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
0 gives best performance (write + flush once every second). 1 gives best
durability (write + f
Jeremy,
do we have the control as to WHEN to update the actual
tables???
Thanx..
Ritu Singla
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >
On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu
> singla wrote:
> > Hello,
> >
> > in InnoDB tables in MySQL, if
> > innodb_flush_log_at_trx_commit is set
On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote:
> Hello,
>
> in InnoDB tables in MySQL, if
> innodb_flush_log_at_trx_commit is set to 1, then on
> COMMIT, the buffer log is flushed to disk log...
Right.
> or the changes are reflected in the disk copy of the database??? i
> mean wh
