More on MySQL 5.1 Partitioning

Tuesday May 23rd 2006 by DatabaseJournal.com Staff
Share:

Robin Schumacher demonstrates how easy and efficient partitioning is in terms of managing how partitions are created and removed within tables.

[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. I’d 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 DBA’s 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 http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitioning.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved