News for hackers. Stuff that matters.
Re:Advanced SQL window function quiz by barrkel on Friday February 09, 2018 @06:06AM (#16339356)
MySQL foreign keys add locks to referenced rows, and can have surprising effects on concurrent queries, particularly if you aren't running at read committed or lower isolation level.

There's also this: https://bugs.mysql.com/bug.php?id=48652 - still open after all these years (and yes I know there are much longer open bugs).

There are no comments on this comment yet.