Question

SQL Table use as a queue does not work correctly

score 36 · Answer 1 · 2024-03-08T21:28:44.387000

36

Views

SQL Table use as a queue does not work correctly

Published on 08 March 2024 at 21:28

score 36 · Answer 2 · 2024-02-21T14:27:35.777000

36

Views

How can I exclude reading rows that were selected in the first transaction when executing the second transaction in PostgreSQL?

Published on 21 February 2024 at 14:27

score 45 · Answer 3 · 2023-06-08T12:26:51.093000

45

Views

Which of the several sessions waiting to acquire an exclusive row lock will be notified first upon release in Oracle RDBMS?

Published on 08 June 2023 at 12:26

score 124 · Answer 4 · 2023-05-09T18:06:58.103000

124

Views

How to change the value of innodb_lock_wait_timeout from hibernate

Published on 09 May 2023 at 18:06

score 63 · Answer 5 · 2023-01-09T23:23:18.953000

63

Views

Are there PRECISE RULES to know when MySQL will apply gap blocking?

Published on 09 January 2023 at 23:23

score 109 · Answer 6 · 2023-01-06T01:56:53.253000

109

Views

BETWEEN SQL - why is there a gap lock?

Published on 06 January 2023 at 01:56

score 433 · Answer 7 · 2023-01-05T00:52:04.360000

433

Views

when exactly does a lock pseudo-record supremum occur?

Published on 05 January 2023 at 00:52

score 45 · Answer 8 · 2023-01-03T10:24:21.510000

45

Views

How to enforce 1-[max n] relationship concurrency-safely? Semaphore table?

Published on 03 January 2023 at 10:24

score 363 · Answer 9 · 2022-12-31T01:23:05.787000

363

Views

row-level locks vs index record locks

Published on 31 December 2022 at 01:23

score 585 · Answer 10 · 2022-12-30T20:47:30.317000

585

Views

Next-key lock explication - Primary key for range

Published on 30 December 2022 at 20:47

score 840 · Answer 11 · 2022-12-29T19:05:26.050000

840

Views

InnoDB Locking - Does record lock use indexes?

Published on 29 December 2022 at 19:05

score 399 · Answer 12 · 2022-11-03T20:49:22.660000

399

Views

MySQL 8.0 (InnoDB) update statement locking more rows than expected, causing deadlocks when called from Tomcat JDBC connection pool

Published on 03 November 2022 at 20:49

score 453 · Answer 13 · 2022-10-05T21:51:59.050000

453

Views

SELECT FOR UPDATE subquery not respecting LIMIT clause under load

Published on 05 October 2022 at 21:51

score 733 · Answer 14 · 2022-03-17T19:18:29.010000

733

Views

Select query hangs when a large number of rows have an update lock

Published on 17 March 2022 at 19:18

score 3k · Answer 15 · 2022-02-02T19:18:08.687000

3k

Views

Postgres row locking

Published on 02 February 2022 at 19:18

score 548 · Answer 16 · 2022-01-15T23:16:13.907000

548

Views

Serializable and Row-based locking in MySQL

Published on 15 January 2022 at 23:16

score 799 · Answer 17 · 2021-08-05T07:52:06.393000

799

Views

Difference between a row lock and a table lock in Oracle database

Published on 05 August 2021 at 07:52

score 50 · Answer 18 · 2021-04-07T20:06:03.927000

50

Views

MySQL update taking more time with concurrent user hit

Published on 07 April 2021 at 20:06

score 48 · Answer 19 · 2021-03-24T04:44:58.053000

48

Views

why for SQLCOM_UPDATE_MULTI, it lock other table with lock_s (INNODB )

Published on 24 March 2021 at 04:44

score 1.7k · Answer 20 · 2020-09-21T14:12:43.840000

1.7k

Views

To use postgresql "SELECT FOR UPDATE" in EF Core with linq - FromSqlRaw

Published on 21 September 2020 at 14:12

List Question

SQL Table use as a queue does not work correctly

How can I exclude reading rows that were selected in the first transaction when executing the second transaction in PostgreSQL?

Which of the several sessions waiting to acquire an exclusive row lock will be notified first upon release in Oracle RDBMS?

How to change the value of innodb_lock_wait_timeout from hibernate

Are there PRECISE RULES to know when MySQL will apply gap blocking?

BETWEEN SQL - why is there a gap lock?

when exactly does a lock pseudo-record supremum occur?

How to enforce 1-[max n] relationship concurrency-safely? Semaphore table?

row-level locks vs index record locks

Next-key lock explication - Primary key for range

InnoDB Locking - Does record lock use indexes?

MySQL 8.0 (InnoDB) update statement locking more rows than expected, causing deadlocks when called from Tomcat JDBC connection pool

SELECT FOR UPDATE subquery not respecting LIMIT clause under load

Select query hangs when a large number of rows have an update lock

Postgres row locking

Serializable and Row-based locking in MySQL

Difference between a row lock and a table lock in Oracle database

MySQL update taking more time with concurrent user hit

why for SQLCOM_UPDATE_MULTI, it lock other table with lock_s (INNODB )

To use postgresql "SELECT FOR UPDATE" in EF Core with linq - FromSqlRaw

Trending Questions

Popular # Hahtags

Popular Questions