从性能上说,不会有任何影响。
http://dev.mysql.com/doc/refman/5.6/en/innodb-consistent-read.html

Consistent read is the default mode in which InnoDB processes SELECT statements in READ COMMITTED and REPEATABLE READ isolation levels. A consistent read does not set any locks on the tables it accesses, and therefore other sessions are free to modify those tables at the same time a consistent read is being performed on the table.

InnoDB的缺省隔离级别是REPEATABLE READ,Consistent non-blocking read是缺省模式。也就是说select不会被update block住。这被称为mvcc。

Arikado answered 12 years ago

Your Answer