Showing posts with label mysql partitioning. Show all posts
Showing posts with label mysql partitioning. Show all posts

Partitioning MySQL 5.6 Style

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.