In this blog post I discussed one of the common MySQL index deadlock issues that had occured in our rails application. https://www.elitmus.com/blog/technology/debugging-and-fixing-mysql-deadlock-issue/