Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
jtc331
on Dec 20, 2023
|
parent
|
context
|
favorite
| on:
Jepsen: MySQL 8.0.34
SELECT FOR UPDATE means two queries can’t _read_ the same row at the same time, right?
hipadev23
on Dec 20, 2023
[–]
To my understanding, yes. If you have broad select queries across all the rows, that would slow things down quite a bit.
dilyevsky
on Dec 20, 2023
|
parent
[–]
You can use SKIP LOCKED normally. That’s how popular queue implementations usually work. I believe pg even calls this out in their docs
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
