When a table holds an IX lock, the lock owner and concurrent applications can read and update data in that table.
当表持有IX锁时,锁拥有者和并发应用程序可以读和更新该表中的数据。
Application 2 can establish an IX lock on the table and an X row lock, because the table lock IX is compatible to the IN table lock from A1.
应用程序2可以在表上建立一个IX锁定和一个x行锁定,因为表锁定ix兼容a1的in表锁定。
Because the acquired lock does not persist across transaction boundaries, the import utility loses its IX table lock and must request another lock after each commit.
因为获得的锁不会跨事务边界存在,所以import工具将失去它的IX表锁,并且必须在每次提交之后请求另一个锁。
Because the acquired lock does not persist across transaction boundaries, the import utility loses its IX table lock and must request another lock after each commit.
因为获得的锁不会跨事务边界存在,所以import工具将失去它的IX表锁,并且必须在每次提交之后请求另一个锁。
应用推荐