One of the major feature enhancement in MySQL 5.6 is partitioning. We use partitioning on a table that stores archive data. The data is partitioned via a date range. Pre 5.6 we had to select the specified range for reporting. Now with some code modification we can select the exact partition.