Am 30.03.2016 um 19:26 schrieb Lentes, Bernd:
----- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:So i should use the default (autocommit=1)?no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a webrequest are half written due a crash or restart use autocommitAutocommit means that every statement is committed implicitly. Right ? Commit works only in conjunction with InnoDB tables and transaction. That's what i understand. I thought when i make e.g. an insert into a InnoDB table, and that insert is not done completely (due to a crash, restart, what ever) it is rolled back automatically after the restart. Is that wrong ?
transactions are not about single queries, transactions are all about multiple queries when you want them all or nothing written
please do some homework and read https://en.wikipedia.org/wiki/ACID which is basic knowledge about databases
the crash safety of innodb has nothing to do with commits
signature.asc
Description: OpenPGP digital signature