Web lists-archives.com

Re: need help from the list admin

Am 30.03.2016 um 18:56 schrieb Lentes, Bernd:
----- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.green@xxxxxxxxxx wrote:
I read that the converting is not difficult. But has the code of our webapp to
be changed ? It's written in php and perl.
What i understand is that inserts/updates/deletions in InnoDB tables have to be
commited. Yes ?

No. The server's default is to have --autocommit=1, which means that
there is an implicit commit at the end of every command. You do not need
to state explicitly "COMMIT" every time you want this to happen.

In fact, disabling autocommit has gotten many new users into trouble
because they did not understand the behavior they changed.

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

if you care that all or nothing is written use transactions
if you care that way don't mix non-transactional tables with innodb

Attachment: signature.asc
Description: OpenPGP digital signature