add transaction-isolation=READ-COMMITTED to my.cnf