Top "Locking" questions

The best way to use a DB table as a job queue (a.k.a batch queue or message queue)

I have a databases table with ~50K rows in it, each row represents a job that need to be done. …

sql database concurrency locking job-queue

Why the Global Interpreter Lock?

What is exactly the function of Python's Global Interpreter Lock? Do other languages that are compiled to bytecode employ a …

python multithreading scripting locking bytecode

when/what locks are hold/released in READ COMMITTED isolation level

I am trying to understand isolation/locks in SQL Server. I have following scenario in READ COMMITTED isolation level(Default) …

sql-server tsql locking isolation-level

Avoiding concurrency problems with MAX+1 integer in SQL Server 2008... making own IDENTITY value

I need to increment an integer in a SQL Server 2008 column. Sounds like I should use an IDENTITY column, but …

sql locking identity max increment

MySQL MyISAM table locking

Does a MySQL MyISAM table gets locked when records are deleted from it?

sql mysql locking myisam

mutex.lock vs unique_lock

When should I prefer the first piece of code to the second, and do they have fundamental differences std::mutex …

c++ concurrency locking mutex

Throw a NullReferenceException while calling the set_item method of a Dictionary object in a multi-threading scenario

Our website has a configuration page such as "config.aspx", when the page initializing will load some information from a …

c# multithreading dictionary locking

Is a read lock on a ReentrantReadWriteLock sufficient for concurrent reading of a RandomAccessFile

I'm writing something to handle concurrent read/write requests to a database file. ReentrantReadWriteLock looks like a good match. If …

java file-io locking readwritelock reentrantreadwritelock

Preventing a class from direct instantiation in Python

I have a super class with a method that calls other methods that are only defined in its sub classes. …

python class oop locking superclass

In Java what is the performance of AtomicInteger compareAndSet() versus synchronized keyword?

I was implementing a FIFO queue of requests instances (preallocated request objects for speed) and started with using the "synchronized" …

java locking compare-and-swap