Re: default resultset concurrency?
Posted by: Mark Matthews
Date: September 05, 2012 07:54AM

Chris,

The concurrency would not affect how Innodb does locking at a row level, only adding "FOR UPDATE" to your SELECT would do that.

You may want to look at http://www.jroller.com/mmatthews/entry/some_transactional_debugging_enhancements_in, which should help point out what is deadlocking and why. It may the execution plan is not using an index that would help reduce the amount of rows locked.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
September 04, 2012 06:12PM
Re: default resultset concurrency?
September 05, 2012 07:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.