[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: autocommit == innobase_flush_log_at_trx_commit" ?
Hi!
No, autocommit means that the system automatically issues a commit
after each SQL statement. You do not have to explicitly write
'COMMIT' in your application.
If you set innobase_flush_log_at_trx_commit=0,
then Innobase will not flush the log to disk immediately at a
commit, and you may lose your latest transactions in a crash.
The 0 option is only for some special applications that cannot
afford the 10 millisecond write to disk.
Normally, you should always set innobase_flush_log_at_trx_commit=1.
Best regards,
Heikki
At 03:01 PM 3/24/01 +0900, you wrote:
>Hi, I have a newbie question. Is "autocommit ==
innobase_flush_log_at_trx_commit" ?
>
>Thanks.
>
>Ryu<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META http-equiv=Content-Type content="text/html; charset=ks_c_5601-1987">
><META content="MSHTML 5.50.4522.1800" name=GENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=#ffffff>
><DIV><FONT size=2>
><DIV><FONT size=2>
><DIV><FONT size=2>Hi, I have a newbie question. Is "autocommit ==
>innobase_flush_log_at_trx_commit" ?</FONT></DIV>
><DIV><FONT size=2></FONT> </DIV>
><DIV><FONT size=2>Thanks.</FONT></DIV>
><DIV><FONT size=2></FONT> </DIV>
><DIV><FONT size=2>Ryu</FONT></DIV></FONT></DIV></FONT></DIV></BODY></HTML>
---------------------------------------------------------------------
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 <mysql-thread69404@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
This mailing list archive is a service of Copilot Consulting.