Search manual: InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point of time, and no changes made by later or uncommitted transactions. The exception to this rule is that the query sees the changes made by earlier statements within the same transaction. This exception causes the following anomaly: If you update some rows in a table,
Read full article from MySQL :: MySQL 5.7 Reference Manual :: 14.2.4 Consistent Nonlocking Reads
No comments:
Post a Comment