Home > database >  Mysql lock problem
Mysql lock problem

Time:10-06

In a transaction, if you use the select.. Lock in share mode of a row and s lock, because the transaction is not over yet, so the s lock does not release, then perform the write operation in this line of business, it s will be upgraded to x lock lock? Or not has been applied less than x lock? (because the s lock has not been released), I do not know whether understand correctly?

CodePudding user response:

Please inform,,,,,,,,

CodePudding user response:

Can you directly debugging debugging success is OK,,,
  • Related