title: What is the good practice on update query with big volume of data to avoid a lock wait timeout?
body: <p>So basically, I have this current query :</p>
  <pre><code>UPDATE act AS a
  INNER JOIN blok AS b
  ON b.fav_pat = a.pat_id
  SET a.blok_id = b.id
  </code></pre>
  <p>Because of the volumn of data i have, its currently timing out. is there a way around to avoid the time out without modifying db config ?</p>