All Questions
Tagged with concurrency mysql
444
questions
1
vote
0
answers
78
views
Handle concurrent request in Ruby on Rails application for sensitive code
I have an api that creates wallet transactions, this API is built in rails and we expect that the transaction_id/reference_no will be unique for each transaction per bank since we have many banks and ...
0
votes
0
answers
32
views
DB Concurrency Rate Limiting
I am working on a java based multi-tenant architecture. So multiple customer data will be stored in a single MySql DB. Now in DB level (InnoDB), we have set innodb_thread_concurrency value as 20. ...
- 1
0
votes
0
answers
17
views
MySql.EntityFrameworkCore No DbUpdateConcurrencyException thrown when concurrency conflictis expected
using MySql When the EntityFrameworkCore connects to MySQL, it does not throw the DbUpdateConcurrencyException exception when there is concurrency in updating data
Here is a snippet of my code:
` ...
0
votes
0
answers
19
views
Two Update statements on a row are running simultaneously with no locking in MYSQL
I relied on row locking in mysql to prevent simultaneous running of one php script when working on one userid.
I used following
UPDATE users SET rowlock = 1 WHERE id = ? AND rowlock = 0
and then in ...
0
votes
0
answers
44
views
python use sqlalchemy async api, session run in RC isolation, Concurrent threads not seeing updated database values with FOR UPDATE locks in Python
I have a Python method that executes concurrently. I use database FOR UPDATE locks to control the concurrency. The expected behavior is that when one thread reads the data and locks the record to ...
- 1
0
votes
0
answers
59
views
Can MySQL update concurrent a table with different rows
I have a table (users) with 20M records.
I need to update column user_image (this is indexed colum) to a new value.
Now, I am using PHP + amphp/amp (https://github.com/amphp/amp) to run multiple ...
- 51
0
votes
1
answer
29
views
Update a record or insert if it doesn't exists, with locking
I would like to update a record if exists. Thats the easiest part, but that record may not exist, so let's create it first. Pseudocode:
UPDATE x SET y=1 WHERE id=5
if the result of it is 0, then...
a,...
- 6,097
-1
votes
1
answer
178
views
What is the best practice for reservation flow in hotel reservation system to handle concurrency for multiple reservation? [duplicate]
For my college project, I'm developing a hotel reservation application using Java along with the Spring framework and MySQL database.
Database details:
I have an entity type that stores reservations ...
- 1
1
vote
1
answer
258
views
how to KNOW if a transaction holds exclusive lock in a row?
I am learning transactions, locks, etc and I want to know how to know if a transaction holds exclusive lock in a row
I tried to simulate it using the MySQL command line, but I'm not sure if it's a ...
0
votes
0
answers
83
views
Strange deadlock using SqlAlchemy + MySql
I use SqlAlchemy + MySql and stuck on a deadlock that I can't understand.
There are a few replicas of app using the same MySql database.
The query to database inserts new row to one table and updates ...
- 85
0
votes
1
answer
21
views
Do insertions inside transactions prevent other threads from inserting with the same PK during operation? [duplicate]
Say I have a function in this pattern:
public void exampleFunc(int key) {
db_connection.start_transaction();
db_connection.execute("INSERT INTO table (pk, content) VALUES ({key}, '...
- 71
1
vote
1
answer
389
views
Laravel: How to handle multiple concurrent function calls on same data by multiple users? [duplicate]
We are building a medium scale fintech product on Laravel where users will be able to load money into their wallet, transfer money to any other wallet or settle funds to any bank account using payout ...
- 13
1
vote
1
answer
200
views
Write concurrency to mysql DB in golang
I'm working with a background job but i haven't more experience.
I have a aws sqs(message queue) service receive message from another service. Each 3 minutes, we will receive about 300 messages from ...
- 11
-2
votes
1
answer
135
views
MySQL concurrent update on a very large table
I have a MySQL table with about 8 gazillion rows. I want to run an update query for each row, updating one column. I'm finding that running a basic UPDATE query causes, "ERROR 1205 (HY000): Lock ...
- 390
0
votes
0
answers
57
views
ConcurrentHasnMap has duplicate key when size are big
I have 975,641 rows of pure string data as rowkeys for HBase, where the lengths of the strings vary. After using distinct in MySQL to remove duplicates, there are 884,508 unique data entries.
When I ...
- 313