擅长:python、mysql、java
<p>我猜你在用InnoDB。这是InnoDB事务的默认值。在</p>
<blockquote>
<p>REPEATABLE READ</p>
<p>This is the default isolation level for InnoDB. For consistent reads,
there is an important difference from the READ COMMITTED isolation
level: All consistent reads within the same transaction read the
snapshot established by the first read. This convention means that if
you issue several plain (nonlocking) SELECT statements within the same
transaction, these SELECT statements are consistent also with respect
to each other. See Section 13.2.8.2, “Consistent Nonlocking Reads”.</p>
</blockquote>
<p>我还没有测试过,但是通过在当前连接上发出<code>commit()</code>来强制MySQLdb启动一个新事务,或者创建一个新的连接,可能会解决这个问题。在</p>