Question : If I have a stored procedure with set transaction isolation level read uncommitted, will it affect update statements? […]
Tag: locking
What is the fastest way to (session) lock table?
Question : I have some triggers to log changes on a table to Log table. On insert and delete I […]
Generate incrementing IDs without sequences
Question : Suppose there’s a multi-tenant application where users can create some kind of documents with basic structure like CREATE […]
Can we reduce row lock contention on an index
Question : We have few queries which check their status into a table every 5 seconds and update their status.. […]
why innodb generate table-lock when two sql using different index?
Question : I know innodb-engine row lock by add lock to index item. But I don’t understand the following scene. […]
SELECT…FOR UPDATE – Will only an UPDATE release the lock?
Question : I’m using a SELECT …FOR UPDATE in a Java PreparedStatement. I may or may not need to execute […]
dropping SYNONYM is blocking in sql server?
Question : I have synonyms which points to a TestDB1, by the next refresh synonyms point to TestDB2. while re-pointing […]
Can insert on tables with FK impact operations on other tables that have FKs to the same table?
Question : Let’s assume that we have the following tables on an InnoDB database: user (id_user, name) log (id_log, id_user, […]
pessimistic locking and client death
Question : We are considering pessimistic locking for our project (SELECT … FOR UPDATE); as we are used to optimistic […]
Strange deadlock with multi-column index with innodb on MySQL
Question : I’m seeing some odd (to me) behavior in MySQL. Let’s start with the table that I’ll be talking […]