Hello folks, Could somebody please tell me what the effectual difference is between AUTOCOMMIT and FLUSH? The manual says, "By default, MySQL runs in autocommit mode. This means that as soon as you execute an update, MySQL will store the update on disk." Good. But what is left to flush then? INSERT DELAYED queries and the like? Or any other outstanding queries for that matter?
In concreto, if my news server to be (will use MySQL) is running idle, and for some bizarre reason mysqld should die, is there always data lost then? I mean, what would FLUSH do that the autocommit had not taken care of already? I am sorry to be such a pain. But I really like to have a fairly decent idea, upfront, about the risks I would run with corrupting the news spool, before I make the switch. - Mark --------------------------------------------------------------------- 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
