#sqlupdate — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlupdate, aggregated by home.social.
-
Why does this SQL UPDATE lock the entire table?
Why does this SQL UPDATE lock the entire table. The SQL code updates with a condition that has no index. In MySQL it locks every row it scans. In SQL services one update blocks all other writes.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlupdate #sqllock #sqlfullsca...