Am 30.03.2016 um 18:56 schrieb Lentes, Bernd:
----- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com 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 applicationif 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
signature.asc
Description: OpenPGP digital signature