Top "Locks" questions

A lock generally refers to something that prevents another process from starting or accessing the same information until the lock is released.

SQL Server database: INSERT query blocked with wait type LCK_M_IX

Our Java application cleans up the data from log table through a cron job. Here is the query which is …

sql-server database database-deadlocks locks
Transactions and Locks

I am currently working with transactions and getting confused. These transaction are created at the data access layer and not …

c# sql-server-2008 transactions locks
Status of mixing multiprocessing and threading in Python

What are best practices or work-arounds for using both multiprocessing and user threads in the same python application in Linux …

python multithreading logging multiprocessing locks
InnoDB SELECT ... FOR UPDATE statement locking all rows in a table

MySQL Server version 5.1.41 with InnoDB plugin enabled. I have the following three tables for invoices: invoices, invoice_components and invoice_…

mysql transactions innodb isolation-level locks
How to lock a row for select in MySQL

A program will SELECT several records from a table and update each row, while it can be executed many times, …

mysql locks
MySQL InnoDB locks on joined rows

Does "SELECT ... FOR UPDATE" lock joined rows in MySQL? If so, is it possible to disable this behaviour? There is …

mysql join transactions innodb locks