title: Mysql query performance with autocommit=0
body: <p>I am trying to delete more than 2 million records from a table by a mysql query (no joins).  The table has around 80 million records.</p>
  
  <p>I used <code>set autocommit=0;</code> and it is taking long time to complete.  Will this be faster if I run the query with <code>autocommit=1</code>?</p>