title: MySQL Partitions & Frequently Moving Rows
body: <p>I am looking to partition on a datetime stamp that will used to show which data is most currently.</p>
  
  <p>This will occur frequent movement of data between partitions.</p>
  
  <ul>
  <li>What issues if any will this create?</li>
  <li>Would if affect speed over time?</li>
  <li>Is changing a row from one partition to another just updating the partition indexes (thus not a big deal)?</li>
  </ul>
  
  <p>thx</p>