title: Will Mysql Partitioning auto-add a new partition?
body: <p>I am setting up partitions to separate very large datasets by quarter. Is there a way to have  Mysql automatically create a new partition each quarter or do I have to pre-allocate them? </p>
  
  <p>What are best practices for this? Perhaps to just make all the partitions for the next few years and forget about it? Or run a quarterly cron? </p>
  
  <p>Thanks for any advice. </p>