title: MySQL Horizontal Partition by Age
body: <p>In my MySQL database table only the most recent two weeks of records are used by our front end users. Any data older then this is only used by administration.</p>
  <p>What I would like to do is optimize the performance for front end users by horizontally partitioning the database based on the age of the record in the database.</p>
  <p>So the front end would need one of the partitions made that would only contain the past two weeks of records and another partition made to contain any record older then 2 weeks.</p>
  <p>However, I did not see in the MySQL documentation (<a href="http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html" rel="nofollow noreferrer">here</a>) if this can or cannot be done.</p>
  <p>Can someone please advise if this can be accomplished and how the table's create statement might look?</p>