Computer jacket is mysql integration environment, the InnoDB engine. I'm in a conversation window to add a data table write locks, occasionally will appear in another session window can also select on the table for operation condition (downs), what reason is this? And if it is to add the read lock won't appear this kind of problem,

CodePudding user response:

By default, the reading is allowed (read is a snapshot, will not be locked)

CodePudding user response:

Check the transaction isolation level,

CodePudding user response:

reference 1st floor ZJCXC response:

by default, the reading is allowed (read is a snapshot, not locked)

add exclusive locks, there is no permission to read other session

CodePudding user response:

refer to the second floor ACMAIN_CHM response:

check transaction isolation level,

I think it should not be the problem of transaction level, because it downs,