Re:5 subtle ways you’re using MySQL as a queue, and why it’l...
by mbirk on Saturday September 17, 2011 @01:47AM
(#3007357)
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-mo...
[ Parent
| on HN ]
Re:5 subtle ways you’re using MySQL as a queue, and why it’l...
by pkteison on Saturday September 17, 2011 @12:02PM
(#3008322)
Wow, 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-rea...