How to Stop Long Transactions From Blocking Everything

Open transactions hold locks and stall writes.

#mysql #locks #transactions #howto #performance #production

https://www.youtube.com/watch?v=yYl1WY7szkY

The lock gates at Portishead stand open under a hard grey sky, with dark water held still between stone walls. Where time waits for the next tide.

#photography #photo #Portishead #Marina #Locks #Winter #Water #Stillness #bristolChannel

Connecting Canals

Before the rise of railroads, canals provided critical commercial shipping infrastructure for many locations worldwide. But connecting canals at different elevations required locks–sometimes a whole series of them–as in the case of Scotland’s Union Canal and the Forth and Clyde Canal. In the canals’ heyday, navigating the 11 locks between them took the better part of a day–one of many reasons that canals fell out of use over time.

When Scotland decided to reconnect the canals in the 1990s, they picked a very different solution for this elevation challenge: the Falkirk Wheel. Grady walks us through the clever engineering of this impressive piece of infrastructure in this Practical Engineering video. (Video and image credit: Practical Engineering)

Read Locks Are Not Your Friends

https://eventual-consistency.vercel.app/posts/write-locks-faster

#HackerNews #Read #Locks #Are #Not #Your #Friends #write #locks #consistency #performance #concurrency

Maximum resistance to picking.

If "maximum" is about 20 seconds, I'd hate to see their less-secure locks.

#AlicePics #Locksport #Locks