4 ms·
Unbounded spinning is absolutely disastrous when cores are oversubscribed. If their spin locks are really unbounded, this does not belong in production.
by senderista 4y ago
Unbounded spinning is absolutely disastrous when cores are oversubscribed. If their spin locks are really unbounded, this does not belong in production.
- MobiusHorizons 4y agoAt the bottom of the linked article: > In all cases above, "spin-lock" actually means invoke the SQLite xBusy callback if one is registered, or to literally spin-lock otherwise. Seems the wait behavior is user configurable.
- eyegor 4y agoThat seems to only be true for the BEGIN EXCLUSIVE statement, which sounds like it's the entire point. Sqlite is generally a bit more bring your own batteries by design, so if you care you would add timeouts at the writer. Unless I'm missing something.