outside the slop, i liked this post that was linked on innodb locking: https://jahfer.com/posts/innodb-locks/