Hi all, I've been looking at the performance of mysql using innodb tables and I've noticed that I can get a huge benifit by setting innodb_flush_log_at_trx_commit = 0. The documentation warns me that I can loose a couple of seconds of transactions in system crash if I do this.
It seems like a great tradeoff but the question is, is there any way that this delayed flushing can cause multi-query transactions to be only half-flushed. Loosing some transactions is ok but loosing half of one would be unnacceptable. Does anyone have any experience here? --------------------------------------------------------------------- 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
