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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
