Re: need help from the list admin
Reindl Harald <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Organization | the lounge interactive design |
| Message-ID | <[email protected]> |
Am 30.03.2016 um 19:26 schrieb Lentes, Bernd: > ----- On Mar 30, 2016, at 7:04 PM, Reindl Harald [email protected] 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
signature.asc
(application/pgp-signature, 181 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlb8DxYACgkQhmBjz394AnnK2gCfey3O6eZ8UUnNWBjcGeA2j4oK EscAn0XQYFaBYgKd5swMJUpWpfit2M39 =JHv6 -----END PGP SIGNATURE-----