title: Efficient way to delete a large amount of records from a big table
body: <p>I want to delete a large amount of records (~200K) from a large table (~500K records) in my MySql DB.</p>
  
  <p>I want to make this call as efficient as possible because i dont want the DB to become "unresponsive" while executing the call.
  <strong>I need to delete records that are "older" than 10 days</strong> (according to <code>created_at</code> column), currently I use:</p>
  
  <pre><code>delete from table_name where created_at &lt; DATE_SUB(CURDATE(),INTERVAL 10 DAY)
  </code></pre>
  
  <p>The table also have a primary key <code>id</code> if it helps.</p>
  
  <p>Any thoughts?</p>