I took a deep dive at one point into understanding concurrent transaction behavior in MySQL and its ramifications. Probably go back and reference that post about once a month...