Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: locking

Update statements with set transaction isolation level read uncommitted

By adminPosted on September 19, 2023

Question : If I have a stored procedure with set transaction isolation level read uncommitted, will it affect update statements? […]

What is the fastest way to (session) lock table?

By adminPosted on September 19, 2023

Question : I have some triggers to log changes on a table to Log table. On insert and delete I […]

Generate incrementing IDs without sequences

By adminPosted on September 15, 2023

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

By adminPosted on September 13, 2023

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?

By adminPosted on September 10, 2023

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?

By adminPosted on September 5, 2023

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?

By adminPosted on September 3, 2023

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?

By adminPosted on September 2, 2023

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

By adminPosted on August 31, 2023

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

By adminPosted on August 27, 2023

Question : I’m seeing some odd (to me) behavior in MySQL. Let’s start with the table that I’ll be talking […]

  • 1
  • 2
  • 3
  • …
  • 58

Recent Posts

  • ObjID in Page Header
  • Applying data changes from one database to another
  • postgresql won’t install dependencies
  • T-SQL query to show table definition of sys.time_zone_info
  • What is using all my space?
  • Large ibdata file in MySQL
  • What exactly are secondary members acknowledging in replicasets with MongoDB?
  • How to access user information via sys.fn_dump_dblog
  • Instance Startup Modes & Shutdown Modes
  • INT(5) vs SMALLINT(5): numbers in parenthesis after the numeric type
  • Restarting primary SQL Server instance with log shipping
  • Fastest way to change a 600GB table indexed key datatype from INT to BIGINT
  • ) c
  • SQL Job runs without it schedule and renaming or deleting it causes other jobs fail
  • mysql emits BINLOG rows even though binlog_­format=­STATEMENT
  • Which mechanism is best for previous data archived in oracle?
  • How large will a MySQL database be relative to the dump file?
  • DBClientCursor::init call() failed
  • Very slow query on table with Blob column [closed]
  • Batch query a lot of MySQLdump files

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding