MySQL: What happen when an executing sql's client is terminated?
I believe that killing the client won't be noticed by the server until the server sends data to the client.  That is, the server will finish the query.

COMMIT happens in different ways.


BEGIN; UPDATE...; &lt;client dies&gt; -- has not gotten to COMMIT, so no commit.
autocommit=OFF ... UPDATE ... -- same as above
autocommit=ON ... UPDATE...; &lt;updated finished, so committed&gt; (I think)