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 [email protected] 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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlb8ByYACgkQhmBjz394Anm0NQCfdrRLX4LI6FTR5ahdxCF7Uo+C
QscAn0NnQidrWNKig4J9U7f6xd0Q+3hF
=wEC7
-----END PGP SIGNATURE-----