Web lists-archives.com

Re: need help from the list admin






Am 01.04.2016 um 21:09 schrieb Lentes, Bernd:
----- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.green@xxxxxxxxxx:
You said, "This is done on the master, written in the log and then
replicated to the slave, "

The INSERT would not appear in the Binary log until after session 1
commits.

So the INSERT take care about the transaction (begin transaction ... COMMIT)
although it's a MyISAM table ?
Because i read MyISAM does not care about it:
http://stackoverflow.com/questions/8036005/myisam-engine-transaction-support

and hence you should not mix innodb and non-transactional tables, a MyISAM table is not and will never be part of a transaction

Attachment: signature.asc
Description: OpenPGP digital signature