3 ms·
By default, InnoDB doesn't acquire read locks when doing queries. It "runs queries as nonlocking consistent reads by default, in the style of Oracle." See htt
by mbirk 15y ago
By default, InnoDB doesn't acquire read locks when doing queries. It "runs queries as nonlocking consistent reads by default, in the style of Oracle." See http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-mo...
- pkteison 15y agoWow, looks like I got that completely wrong w.r.t. innodb specifically. Wish I could still edit my first post. :( Thank you. http://dev.mysql.com/doc/refman/5.0/en/innodb-consistent-read.html http://dev.mysql.com/doc/refman/5.0/en/innodb-consistent-rea...