This post is
about partitioning a MySQL table by year by using range partition type. This
post does not deal with the theories on partition, if you would like to
understand the complete partitioning methods and types visit the official MySQL
documentation. In this post we are directly focus on the implementation steps,
assuming that we have knew the basics of MySQL partitioning types and its
usages.