#sqlgaplock — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlgaplock, aggregated by home.social.
-
Why does this SQL gap lock block an insert you never touched?
Why does this SQL gap lock block an insert you never touched. The SQL code uses SELECT FOR UPDATE. In MySQL InnoDB locks the gap. In SQL another session cannot insert in that range.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlgaplock #sqlforupdate #sql...
-
Why does this SQL gap lock block an insert you never touched?
Why does this SQL gap lock block an insert you never touched. The SQL code uses SELECT FOR UPDATE. In MySQL InnoDB locks the gap. In SQL another session cannot insert in that range.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlgaplock #sqlforupdate #sql...
-
Why does this SQL gap lock block an insert you never touched?
Why does this SQL gap lock block an insert you never touched. The SQL code uses SELECT FOR UPDATE. In MySQL InnoDB locks the gap. In SQL another session cannot insert in that range.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlgaplock #sqlforupdate #sql...