Deadlocks have little to do with queries and everything to do with transactions. They happen for a very good reason and never happen "randomly". I assume you

Deadlocks have little to do with queries and everything to do with transactions. They happen for a very good reason and never happen "randomly". I assume you are using the innodb storage engine: http://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html http://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html