title: How to deal with huge database in mysql?
body: <p>I am working with on project where they deal huge data. In each table 100k or more data are available. Now I need to run sql update query but I don't works.</p>
  
  <p>How can I solve this problem ? Query runs successfully on my localhost with few data. But On server it does not work</p>
  
  <p>Please help me.</p>
  
  <pre><code>UPDATE buzz_business_view b, daily_deals d
  SET d.business_id = b.`Business ID`
  WHERE d.phone = b.phone 
  </code></pre>
  
  <p>Thanks</p>