title: MySQL table partition by month
body: <p>I have a huge table that stores many tracked events, such as a user click.</p>
  <p>The table is already in the 10s of millions, and it's growing larger every day.
  The queries are starting to get slower when I try to fetch events from a large timeframe, and after reading quite a bit on the subject I understand that partitioning the table may boost the performance.</p>
  <p>What I want to do is partition the table on a per month basis.</p>
  <p>I have only found guides that show how to partition manually each month, is there a way to just tell MySQL to partition by month and it will do that automatically?</p>
  <p>If not, what is the command to do it manually considering my partitioned by column is a datetime?</p>