mysq悲观锁
BEGIN;
SELECT * FROM base_acc_btc WHERE cid = 100470210 FOR UPDATE;
UPDATE base_acc_btc SET freemargin = freemargin + 2 WHERE cid = 100470210;
commit;
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
show global variables like "%timeout%";
set global innodb_lock_wait_timeout = 10;
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
Last Updated: 2023/02/16, 14:02:00