[From MySQL Developer Zone
In my first article on partitioning, I demonstrated that you can get some pretty impressive performance benefits when you properly design partitioned tables to match the SQL queries that are routinely shot across the bow of your database server. Id now like to continue in that vein and show you how easy and efficient partitioning is in terms of managing how partitions are created and removed within tables.
One thing DBAs love about partitioning is that it gives them much finer control over the underlying storage and data contained within tables and indexes. This control can make a DBAs life a lot easier when it comes to things like managing logical separations of data as well as removing obsolete information from a database.
The article continues at