title: Autocommit example in MySQL
body: <p>I try to follow an example as below, but I get a different result, being that the second select in session A returns the new row inserted by Session B. </p>
  
  <p>The example is from <a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-consistent-read.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.6/en/innodb-consistent-read.html</a>. I am using 5.5. </p>
  
  <pre><code>           Session A              Session B
  
             SET autocommit=0;      SET autocommit=0;
  time
  |          SELECT * FROM t;
  |          empty set
  |                                 INSERT INTO t VALUES (1, 2);
  |
  v          SELECT * FROM t;
             empty set
                                    COMMIT;
  
             SELECT * FROM t;
             empty set
  
             COMMIT;
  
             SELECT * FROM t;
             ---------------------
             |    1    |    2    |
             ---------------------
             1 row in set
  </code></pre>
  
  <p><strong>Update</strong>
  I changed in both session A and B for transaction as below, but the problem still exists.</p>
  
  <pre><code>SET autocommit=0;   -- I think this line is redundant given the line below 
  set transaction isolation level read committed;
  start transaction; 
  </code></pre>
  
  <p>Any idea?</p>