title: MySQL - archive table data
body: <p>I would like to learn how I can archive old table data in a separate table automatically.</p>
  
  <p>I have a very big table which grows and grows constantly. The actually relevant data for me is the latest ~1000 rows. All other data is "nice to have" but is irrelevant. So I want to move it to separate location in order to speed up SELECT queries.</p>