Stack Overflow
Stack Overflow

Questions tagged [table-locking]

104 questions
0
votes
2 answers

Does a general InnoDB UPDATE lock the entire table and block incoming specific UPDATEs?

Suppose I ran this statement: UPDATE Employees set country='AU' On an InnoDB table, Employees, with about 10 million rows. This table is also actively being updated by other users through SQL queries like the one below: E.g. a User, ID = 20,…
lbj99
  • 3
  • 1
  • 2
0
votes
1 answer

Oracle how child table behave when data from parent table is modified?

Scenario: We have table A (Parent Table) referring to table B (Child Table) and also we have Foreign Key Index for every Foreign Key. Operation: Now when any user is deleting a row from table A then table B is getting locked even if there are no…
Sujit Kumar Swain
  • 21
  • 4
0
votes
2 answers

innodb full table lock during simple insert

Our code does insert into user (email, name) values ((),()) // 1000 rows at a time, without specifying primary key value Such inserts run in parallel on multiple server and with high concurrency (sometimes even at 2 parallel) many of them fails due…
Rahul
  • 824
  • 1
  • 12
  • 27
0
votes
1 answer

mySql innoDB write queries locked for long time by read queries

I have a mySql innoDB database with a table (with auto increment primary key). I have many processes performing a read operation on the table. I have other (few) processes that need to write in the same table within a time interval (less than 30…
AleCat83
  • 1,443
  • 3
  • 22
  • 41
0
votes
2 answers

MYSQL 5.6.10 ANALYZE TABLE lock issue

I ran the analyze table command on production mysql db without knowing it would prevent me from selecting the contents of the table. This caused production site to go down :( How long can it take for the lock to release? Also, would recreating the…
Mo Huss
  • 11
  • 6
0
votes
1 answer

mysqldump with --single-transaction and avoid DDL statements without table locking

I am looking for a solution to take logical backup of MySQL database with mysqldump with single-transaction option and also avoiding any DDL statements during backup without locking any table. Currently mysqldump is getting failed if any alter table…
salman
  • 11
  • 1
0
votes
0 answers

Routine to lock an SQL Server Table Asynchronously

I want to write a routine which should be able to lock a table for a specified amount of time and return asynchronously before any waiting. I have written the following code public static void LockTable(string TableName, string connection ) …
Madhur Maurya
  • 1,016
  • 4
  • 19
  • 42
0
votes
0 answers

Pattern for simple table lock in SQL Server

I've been reading the MSDN about transaction isolation levels and table hints in an effort to find out what I need to do to exclusively lock a table while I perform a 2 step insert in SQL Server. I've come up with 2 ways to do it and would like to…
Ian
  • 4,169
  • 3
  • 37
  • 62
0
votes
2 answers

Application becomes unresponsive because of oracle lock

The app is connected to an oracle 11G database using the JDBC driver provided from the official website. When many users (Around 50) from different instances connected to the same schema start using the application, i experience some freezes all…
AyoubK
  • 11
  • 1
  • 3
0
votes
0 answers

Can a Table Lock eliminate a deadlock or make it worse Oracle

We have a situation in which an Oracle Database is having deadlocks issues. I said that perhaps we should lock into some table locks, and a guys response to me was "Unless I am misunderstanding what you mean by a table lock, I don’t think a table…
user5154099
0
votes
0 answers

PDO table locking on a table not specified?

Words are hard today, and I'm trying to write this up clearly so that I can help you help me. Some overkill exists below, ymmv. I'm migrating about 48m records out of table1 into table2, both InnoDB. I'm able to identify the records to be culled…
MikeD187
  • 1
  • 1
0
votes
1 answer

Explicit table locking to disable DELETES?

Using Oracle 11gR2: We already have a process that cleans up particular tables by deleting records from them that are past a specified retention date (based on the comparison between the timestamp from when the record finished processing and the…
Himecchi
  • 1
  • 2
0
votes
0 answers

MS SQL Server monitoring table locks

I would like to ask whether there's some kind of a mechanism that would allow me to monitor, capture and write (e.g. to a table) information about table locks that occured. What I found so far are few stored procedures that can be executed manually…
pzaj
  • 1,062
  • 1
  • 17
  • 37
0
votes
0 answers

Do MySQL LOCK and UNLOCK commands get replicated?

I have a database that is replicated to a slave. I have a process that updates a MyISAM table in the master database every minute. It does so by LOCKing the table, DELETEing the relevant entries, INSERTing the updated entries and then UNLOCKing the…
Ben Holness
  • 2,457
  • 3
  • 28
  • 49
0
votes
1 answer

Two way communication in JIRA Mobile Connect for ios crashes the app due to sqlite locking

I am using the latest tag named "tip" and I am using JIRA on demand. I just incorporated JIRA mobile connect into my ios app and it is behaving a bit oddly i.e. it is going into an infinite loop and hangs my app. After turning the debug mode on and…
Jagmag
  • 10,283
  • 1
  • 34
  • 58
1 2 3 4 5
6
7