OBJECT_INSTANCE_BEGIN:235208256LOCK_TYPE:SHARED_READLOCK_DURATION:TRANSACTIONLOCK_STATUS:GRANTEDSOURCE:OWNER_THREAD_ID:93OWNER_EVENT_ID:41rowinset(0.00sec) 由此可以看出当sessionA的DML操作尚未提交事务时,会获取MDL共享读锁,该锁是表级别,直接作用在my_test上;当sessionB 执行DDL操作时需要在my_test上获取MD...
| TABLE | db1 | t1 | NULL | 139776154308336 | SHARED_READ | TRANSACTION | GRANTED | sql_parse.cc:6014 | 53 | 22 | | TABLE | performance_schema | metadata_locks | NULL | 139776223308432 | SHARED_READ | TRANSACTION | GRANTED | sql_parse.cc:6014 | 54 | 13 | +---+---+---+-...
1) Granted or pending lock of those type is incompatible withsome other types of locks or with itself. 2) Not common for DML operations These locks have to be always acquired involving manipulations on m_waiting/m_granted bitmaps/lists, i.e. we have to use "slow path" for them. Moreov...
AND a.OBJECT_NAME = b.OBJECT_NAME AND a.lock_status = 'PENDING' AND b.lock_status = 'GRANTED' AND a.OWNER_THREAD_ID <> b.OWNER_THREAD_ID AND a.lock_type = 'EXCLUSIVE' JOIN performance_schema.threads c ON a.OWNER_THREAD_ID = c.THREAD_ID JOIN performance_schema.threads d ON b....
AND a.lock_status = 'PENDING' AND b.lock_status = 'GRANTED' AND a.OWNER_THREAD_ID <> b.OWNER_THREAD_ID AND a.lock_type = 'EXCLUSIVE' JOIN performance_schema.threads c ON a.OWNER_THREAD_ID = c.THREAD_ID JOIN performance_schema.threads d ON b.OWNER_THREAD_ID = d.THREAD_ID \G...
lock_status = 'PENDING' AND b.lock_status = 'GRANTED' AND a.OWNER_THREAD_ID <> b.OWNER_THREAD_ID AND a.lock_type = 'EXCLUSIVE' JOIN performance_schema.threads c ON a.OWNER_THREAD_ID = c.THREAD_ID JOIN performance_schema.threads d ON b.OWNER_THREAD_ID = d.THREAD_ID ) t1, ( ...
140123643652376 ENGINE_TRANSACTION_ID: 8362 THREAD_ID: 397807 EVENT_ID: 42 OBJECT_SCHEMA: zcdb OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: PRIMARY OBJECT_INSTANCE_BEGIN: 140123643652376 LOCK_TYPE: RECORD LOCK_MODE: X,REC_NOT_GAP LOCK_STATUS: GRANTED LOCK_DATA: 2...
AND a.lock_status = 'PENDING' AND b.lock_status = 'GRANTED' AND a.OWNER_THREAD_ID <> b.OWNER_THREAD_ID AND a.lock_type = 'EXCLUSIVE' JOIN performance_schema.threads c ON a.OWNER_THREAD_ID = c.THREAD_ID JOIN performance_schema.threads d ON b.OWNER_THREAD_ID = d.THREAD_ID ...
程序集:Microsoft.SqlServer.SqlEnum(在 Microsoft.SqlServer.SqlEnum.dll 中) 语法 C# publicenumLockRequestStatus 成员 成员名称说明 GrantedThe lock is being granted. ConvertingThe lock is being converted. WaitingThe lock is waiting. 请参阅 参考 Microsoft.SqlServer.Management.Smo 命名空间...
Status 锁状态。 Granted Number 已授权的锁个数。 Current Use Mode 当前使用中的授权模式。 Wait Number 等待授权的锁的个数。 Break Wait Number 等待召回的锁的个数。 翻译 收藏 下载文档 更新时间:2024-06-06 文档编号:EDOC1100139945 浏览量:416994 ...