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

Tag: locking

The total number of locks exceeds the lock table size, even after increasing buffer pool size

By adminPosted on February 8, 2023

Question : I am trying to partition a table with 200 million records in it. This table already exists: CREATE […]

When changing the size of a nvarchar column, do I need to drop the unique index? And will the table get locked when recreating the index?

By adminPosted on February 7, 2023

Question : In our database a big table exists that more or less looks like this: CREATE TABLE dbo.production_data ( […]

What is the performance cost of enabling “log_lock_waits” on Postgres?

By adminPosted on February 4, 2023

Question : I am trying to understand what is the performance cost of enabling log_lock_waits on Postgres. As per this […]

How mysql (innodb) handles auto increment column

By adminPosted on February 3, 2023

Question : I am working on a OLTP environment with multiple parallel write operation. I found this in documentation about […]

LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?

By adminPosted on January 31, 2023

Question : MySQL version: 5.5.13 The query that I’m using: SET AUTOCOMMIT=0; LOAD DATA INFILE ‘/data10/select_into.outfile/v3_zone_date.out’ INTO TABLE v3_zone_date FIELDS […]

Can I set the maximum locking level that a transaction can acquire?

By adminPosted on January 30, 2023

Question : What I want to achieve is something like this: SET LOCAL max_locking_level=”ACCESS SHARE”; ALTER TABLE foo ALTER COLUMN […]

Locking issue with concurrent DELETE / INSERT in PostgreSQL

By adminPosted on January 28, 2023

Question : This is pretty simple, but I’m baffled by what PG does (v9.0). We start with a simple table: […]

What does innodb_table_locks setting do exactly?

By adminPosted on January 27, 2023

Question : Can someone please explain how this setting affects the locking behaviour in innodb (with an example). I ran […]

How do I place an UpdateLock on a row with an index

By adminPosted on January 23, 2023

Question : Let’s assume I have a table like this on a SQL Server 2014: CREATE TABLE Accounts ( Id […]

Is this update, select combination query thread safe?

By adminPosted on January 22, 2023

Question : I have a table called seats, which has a schema like this id,taken For each user, I take […]

  • 1
  • 2
  • 3
  • …
  • 48

Recent Posts

  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?
  • How to make a FULLTEXT search with ORDER BY fast?
  • De-duplicate rows in place vs de-duplicate on transfer

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