Table structure
CREATE TABLE `table1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT "id",
`account_name` varchar(65) NOT NULL COMMENT ,
PRIMARY KEY (`id`),
KEY `idx_an` (`account_name`,`already_login`),
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;select * from table1 where name="1" for update;how is it locked when there is no such data in the table?
Spring boot uses jpa to operate MySQL InnoDB; for example: products; id; quantity; ; id=3211: I see the sql statement on the Internet is: SET AUTOCOMMIT=0; BEGIN WORK; SELECT quantity FROM products WHERE id=3 FOR UPDATE; UPDATE products SET quan...
in order to prevent deadlocks, I locked my program sequentially. Such as the order of oa--as-aa. But since I found that the data did not exist when I got the OA, I first new, and then lock it. The result is the new oa- lock, the oa-new as- lock, the as-...
start transaction; select * from test where id = 8 for share; update test set name = grayvtouch where id = 8; select * from test where id = 8 for share; at first I thought it was a shared lock , but as a result, I did get stuck by executing the fol...
I read some articles saying that it is necessary to set a reasonable deadlock timeout for deadlock problems. However, some say that InnoDB will automatically detect transaction deadlocks and roll back immediately with an error. I tried it and found th...