New answers tagged

0

http://dev.mysql.com/doc/refman/5.6/en/innodb-autocommit-commit-rollback.html If a session that has autocommit disabled ends without explicitly committing the final transaction, MySQL rolls back that transaction. There is a process that monitors active sessions. If any are found to have disconnected, the sessions are cleaned up. This includes rollback ...


1

I did a small simulation of that situation, in a simple bash script that does that: ➜ rsandbox_5_6_30 cat test.sh ./m -e "START TRANSACTION; INSERT INTO test1 VALUES(6); select sleep(3); rollback;" test 2> tx1 & ./m -e "START TRANSACTION; INSERT INTO test1 VALUES(6); select sleep(5); commit;" test 2> tx2 & ./m -e "START TRANSACTION; INSERT ...



Top 50 recent answers are included