32 lines
777 B
Plaintext
32 lines
777 B
Plaintext
DROP TABLE IF EXISTS t1;
|
|
DROP TABLE IF EXISTS t2;
|
|
create table t1 (a int, primary key(a) comment 'lock_into_cf1') engine=xengine;
|
|
insert into t1 values (1);
|
|
insert into t1 values (2);
|
|
create table t2 (a int, primary key(a) comment 'lock_info_cf2') engine=xengine;
|
|
insert into t2 values (1);
|
|
insert into t2 values (2);
|
|
set autocommit=0;
|
|
select * from t1 for update;
|
|
a
|
|
1
|
|
2
|
|
select * from t2 for update;
|
|
a
|
|
1
|
|
2
|
|
use information_schema;
|
|
select xengine_ddl.subtable_id, xengine_locks.transaction_id, xengine_locks.key
|
|
from xengine_locks
|
|
left join xengine_ddl
|
|
on xengine_locks.subtable_id=xengine_ddl.subtable_id
|
|
order by xengine_ddl.subtable_id;
|
|
subtable_id transaction_id key
|
|
# _txn_id_ _key_
|
|
# _txn_id_ _key_
|
|
# _txn_id_ _key_
|
|
# _txn_id_ _key_
|
|
use test;
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|