Web lists-archives.com

Re: need help from the list admin






Am 28.03.2016 um 21:36 schrieb Lentes, Bernd:
----- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.reindl@xxxxxxxxxxxxx wrote:

Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (transactional and
non-transactional) within the scope of a single transaction. But if you
cannot convert them, using MIXED will be a good compromise.

Is this a big problem ? Something to take care of ? Currently we have a mix.
I will ask the girl who developed it why we have both kinds. I hope i can
convert

surely - when you have non-transactional tables involved in
updates/inserts you can go and forget using transactions at all since
interruption or rollback would not rollback already written changes in
MyISAM tables

transactions are all about consistency - impossible with a mix of InnoDB
and MyISAM tables

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 ?

first please stop place a space before "?" - it hurts :-)

NO - it only has to be commited if you START A TRANSACTION at the begin

This has to be done in the code ? Or can we use the system variable autocommit ?

if you are using automcommit you lose any purpose of having transactions

That means that everything is commited immediately ? Is this a good solution ?

if you don't care about consistency yes

What means "By default, client connections begin with autocommit set to 1" in the doc ?

that nobody is starting a transaction automatically because nobody can tell when it is finished automatically end hence you need to tell it the db server

That every client connection established via perl/php is started with autocommit=1 ?

surely

And when does the commit happen ? When the connection is closed ? Is that helpful ?

depends - maybe you should start to read what transactions in the database world are because than you can answer all of your questions above at your own

Attachment: signature.asc
Description: OpenPGP digital signature