Web lists-archives.com

Re: need help from the list admin

Am 30.03.2016 um 19:26 schrieb Lentes, Bernd:
----- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.reindl@xxxxxxxxxxxxx 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 autocommit

Autocommit 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

Attachment: signature.asc
Description: OpenPGP digital signature