Am 01.04.2016 um 21:09 schrieb Lentes, Bernd:
----- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: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
signature.asc
Description: OpenPGP digital signature