In the last episode (Mar 24), └»╜┬╚╞ said:
> Hi, I have a newbie question. Is "autocommit == innobase_flush_log_at_trx_commit" ?
No; autocommit is more of a logical SQL operation, where
innobase_flush_log_at_trx_commit causes a physical action. With
autocommit unset, you can send multiple UPDATE commands and roll them
back. innobase_flush_log_at_trx_commit simply determines what happens
when someone does a COMMIT (or if autocommit=on, when any change is
made). If it is unset, the logfile is only flushed when an internal
buffer fills up (not sure how large that buffer is).
--
Dan Nelson
[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
