Posts tagged “database”
3 posts Subscribe by RSS
3 posts
SQLite BEGIN DEFERRED, IMMEDIATE, and EXCLUSIVE: Handling SQLITE_BUSY Mid-Transaction
Why a mid-transaction write in SQLite can fail with SQLITE_BUSY despite busy_timeout, how BEGIN IMMEDIATE moves contention to the start, and what to retry at each failure point.
MySQL InnoDB Gap Locks: What Gets Locked When the Row Doesn't Exist
Why InnoDB locks gaps between index records under REPEATABLE READ, why check-then-insert with FOR SHARE can deadlock, and what READ COMMITTED gives up. Based on the MySQL 8.4 manual.
PostgreSQL CREATE INDEX CONCURRENTLY: what you pay for not blocking writes
CREATE INDEX CONCURRENTLY's lock, two scans and transaction waits, INVALID index cleanup after failure, and transaction-block and partition limits, per PostgreSQL 18 docs.
No posts match. Try another word.